Re: [GENERAL] pg_dump of a big table

2009-07-14 Thread Scott Mead
On Mon, Jul 13, 2009 at 3:29 PM, Sam Mason wrote: > On Mon, Jul 13, 2009 at 06:57:43PM +, Nelson Correia wrote: > > Running pg_dump from another machine needs much space on the DB > > host? Or it just outputs the data as it goes? > > pg_dump should use very little space on the server, it just

Re: [GENERAL] pg_dump of a big table

2009-07-13 Thread Sam Mason
On Mon, Jul 13, 2009 at 06:57:43PM +, Nelson Correia wrote: > Running pg_dump from another machine needs much space on the DB > host? Or it just outputs the data as it goes? pg_dump should use very little space on the server, it just streams it out to where ever you tell it. You could run pg_

[GENERAL] pg_dump of a big table

2009-07-13 Thread Nelson Correia
Hi all, I need to do a backup from a big table that is in a machine with almost no disk space. Running pg_dump from another machine needs much space on the DB host? Or it just outputs the data as it goes? Is there a better way to do this? Thanks, Nelson