| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
| Cc: | pgsql general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Practical maximums (was Re: PostgreSQL theoretical |
| Date: | 2006-08-07 18:55:23 |
| Message-ID: | 1154976923.20252.22.camel@state.g2switchworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 2006-08-07 at 13:51, Ron Johnson wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Jeff Davis wrote:
> > On Mon, 2006-07-31 at 09:53 -0500, Ron Johnson wrote:
> > pg_dump just produces output. You could pretty easily stripe that output
> > across multiple devices just by using some scripts. Just make sure to
> > write a script that can reconstruct the data again when you need to
> > restore.
>
> But doesn't that mean that pg_dump must dump to disk?
>
> With a *big* database, that's a whole lot of extra kit (not just
> spindles) to buy.
I'm certain you can backup direct to tape, as I've done it in the past
with postgresql. This was in the day of 4 gig 4 mm tape drives...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | MargaretGillon | 2006-08-07 19:05:42 | Re: Varchar concatenate fields as Char or Varchar, not Text |
| Previous Message | MargaretGillon | 2006-08-07 18:54:25 | Re: Varchar concatenate fields as Char or Varchar, not Text |