How pg_dump works

From: Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it>
To: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: How pg_dump works
Date: 2016-10-10 11:50:35
Message-ID: c5f9de14-5dd8-0072-9eb5-70c1cafd47e0@evolu-s.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Achilleas Mantzios 2016-10-10 12:16:13 Re: How pg_dump works
Previous Message Geoff Winkless 2016-10-10 10:31:58 Re: Transactional-DDL DROP/CREATE TABLE