On 7 Sep 2001, Calvin Dodge wrote:
> You could even do:
>
> pg_dump mydatabase|gzip -c|ssh othersystem.com 'gunzip -c |psql
> mydatabase'
This is getting off topic, but I just thought I'd mention that
pg_dump mydatabase | ssh -C othersystem.com 'psql mydatabase'
does effectively the same thing
There is no way to add a temporary hard drive, or mount another drive on
another machine, and then dump to that?
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 spac
