Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: Space for pg_dump


  • From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
  • To: SHARMILA JOTHIRAJAH <sharmi_jo(at)yahoo(dot)com>
  • Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, General postgres mailing list <pgsql-general(at)postgresql(dot)org>
  • Subject: Re: Space for pg_dump
  • Date: Wed, 1 Apr 2009 00:00:06 +0200
  • Message-id: <20090331220006.GA12545@depesz.com> <text/plain>

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(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group