On Tue, Mar 31, 2009 at 9:57 AM, SHARMILA JOTHIRAJAH
<sharmi...@yahoo.com> wrote:
> --- 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

It's hard to say.  Why can't you RUN the example command on each db
and see for yourself?  It doesn't create a backup, per se, it just
creates one and hands it to wc to see how big it is.

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to