Re: How pg_dump works

>> 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