>> Hi all,
>>      I need to pg_dump a database to another server.
>> The particularity is that the database is bigger than remaining space on 
>> disk. Obviously, this is not a problem because i'm dumping to another 
>> host, but I need to know if the procedure streams data to remote host or 
>> the data itself is packed up in temporary file(s) that are sent to 
>> remote host.
>> The former would be such a problem, because there are good chances I'll 
>> have my disk filled up...
>> 
>> I've not found details on this in documentation.
>> 
>> Thanks
>> Moreno.
>> 
Hi Moreno,

it is one big stream.
I am sending compressed pg_dump and can actually use
zcat dumpfile.gz | psql mydatabase
on the other end

Regards
Wolfgang




-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to