Re: Practical maximums (was Re: PostgreSQL theoretical

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>, pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Practical maximums (was Re: PostgreSQL theoretical
Date: 2006-08-07 19:59:08
Message-ID: 20060807195908.62569.qmail@web31807.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> Say we have a 7GB database. Is there a way to way to use 2 tape
> drives... Argh, I guess not, since the Unix pipe mentality presumes
> that the mode of operation will be:
> $ pg_dump /some/database | tar cvfz /dev/st0/db.tgz
>
> What would be darned useful (but only, I think, with heavy usage of
> tablespaces) is:
> $ pg_tapedump /some/database /dev/st0,/dev/st1,/dev/st2,/dev/st3

Would passing the --multi-volume option be useful to you?

http://www.apl.jhu.edu/Misc/Unix-info/tar/tar_97.html

Regards,

Richard Broersma Jr.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2006-08-07 20:00:05 Re: Practical maximums (was Re: PostgreSQL theoretical
Previous Message Ron Johnson 2006-08-07 19:51:12 Re: Practical maximums (was Re: PostgreSQL theoretical