On Fri, 7 Sep 2001, David Ford wrote:
> Help if you would please :)
>
> I have a 10million+ row table and I've only got a couple hundred megs
> left. I can't delete any rows, pg runs out of disk space and crashes.
> I can't pg_dump w/ compressed, the output file is started, has the
> schema and a bit other info comprising about 650 bytes, runs for 30
> minutes and pg runs out of disk space and crashes. My pg_dump cmd is:
> "pg_dump -d -f syslog.tar.gz -F c -t syslog -Z 9 syslog".
Try putting the output into ssh or something similar. You don't have to
keep it on the local machine.
From the bigger machine, something like
ssh server-with-data "pg_dump <options>" > syslog-dump
or from the smaller machine,
pg_dump <options> | ssh big-machine "cat > syslog-dump"
should do the trick. Maybe you can even pipe the output directly into
psql or pg_restore. Make sure the pg_dump throws output to stdout.
HTH.
--
Alvaro Herrera (<alvherre[@]atentus.com>)