--- On Tue, 3/31/09, Scott Marlowe <scott.marl...@gmail.com> wrote:
> From: Scott Marlowe <scott.marl...@gmail.com>
> Subject: Re: [GENERAL] Space for pg_dump
> To: "SHARMILA JOTHIRAJAH" <sharmi...@yahoo.com>
> Cc: "General postgres mailing list" <pgsql-general@postgresql.org>
> Date: Tuesday, March 31, 2009, 11:49 AM
> On Tue, Mar 31, 2009 at 7:57 AM,
> SHARMILA JOTHIRAJAH
> <sharmi...@yahoo.com>
> wrote:
> >
> > Hi,
> > How much space does a pg_dump usually take?
> > One of my databases is 600GB.... How much space do I
> need to dump this?
>
> Note you can find out by doing:
>
> pg_dump dbname | wc
>
Yes...I could find the space used after creating the dump.
But I need to pre-allocate some space for storing these dumps (there are other
databases too that needs to be dumped). So Im trying to find a space estimate
....
Do you have a rough estimate of pg_dump in general... like 1/4 th of the
database size or something like that...I just need a rough estimate for now
Thanks
Sharmila
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
