Re: Space for pg_dump - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: Space for pg_dump
Date
Msg-id 20090331220006.GA12545@depesz.com
Whole thread Raw
In response to Re: Space for pg_dump  (SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com>)
List pgsql-general
On Tue, Mar 31, 2009 at 08:57:28AM -0700, SHARMILA JOTHIRAJAH wrote:
> > 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

I'm not sure if you realize that you don't need any space for the
command that Scott showed (pg_dump dbname | wc). it will not write
anything to disk.

Best regards,

depesz

--
Linkedin: http://www.linkedin.com/in/depesz  /  blog: http://www.depesz.com/
jid/gtalk: depesz@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

pgsql-general by date:

Previous
From: Patrick Desjardins
Date:
Subject: ERROR: XX001: could not read block 2354 of relation…
Next
From: Scott Marlowe
Date:
Subject: Re: [GENERAL] ERROR: XX001: could not read block 2354 of relation…