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