Re: Problem w/ dumping huge table and no disk space - Mailing list pgsql-general

From Tod McQuillin
Subject Re: Problem w/ dumping huge table and no disk space
Date
Msg-id 20010908160749.G89526-100000@glass.pun-pun.prv
Whole thread Raw
In response to Re: Problem w/ dumping huge table and no disk space  (caldodge@fpcc.net (Calvin Dodge))
List pgsql-general
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 as the above and saves you process
creation overhead on both systems.
--
Tod McQuillin



pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Abort state on duplicated PKey in transactions
Next
From: Peter Eisentraut
Date:
Subject: Re: Uniquely identify a connection?