Il 10/10/2016 14:16, Achilleas Mantzios ha scritto:
On 10/10/2016 14:50, Moreno Andreo wrote:
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.
In fact, in the docs there is all the info you might ever need.
PostgreSQL project excels on that compared to *many* free-software
projects. Now what you could do is something like :
createdb -h your_big_server your_database
pg_dump -h your_small_server your_database | psql -h your_big_server
-f - your_database
Thanks, I was aware of this usage. I just wanted to be sure no
additional disk space has to be used in "small_server".
Thanks
Moreno.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
