Re: How pg_dump works

Il 10/10/2016 14:16, hamann(dot)w(at)t-online(dot)de ha scritto:
>>> 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.
OK, that's good news :-)

Thanks
Moreno.
> I am sending compressed pg_dump and can actually use
> zcat dumpfile.gz | psql mydatabase
> on the other end
>
> Regards
> Wolfgang
>
>
>
>