Il 10/10/2016 14:16, hamann.w@xxxxxxxxxxx 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
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
