[postgis-users] pg_dump of a big table

[Guillaume Lelarge]

Le lundi 13 juillet 2009 à 20:51:50, Nelson Correia a écrit :
> [...]
> 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?
>

If you do on server b:
  pg_dump -h a db > a_db.dump
Then you need space on server b, but not on server a.

> Is there a better way to do this?
>

Nope.


-- 
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com