On 04/17/2018 12:35 AM, Ron wrote:
On 04/16/2018 11:07 PM, Adrian Klaver wrote:
On 04/16/2018 06:43 PM, Ron wrote:
More promising would be the suggestion from Michael Nolan:
https://www.postgresql.org/message-id/CAOzAqu%2BVpOfzBHwcqptSzm3PkeZAjkqqc0XqB%2BA-jBNioU6x%2Bg%40mail.gmail.com
ggraben.net]
Sent: Tuesday, April 17, 2018 18:00
To: pgsql-general@lists.postgresql.org
Subject: Re: pg_dump to a remote server
## Ron (ronljohnso...@gmail.com):
> > pg_dump -h host1 dbname | psql -h host2 dbname
>
> But that assumes --format=plain which will send a whole lot of
> un
ort method like gzip, -Fc, -Ft, -Fd -j 4(faster).
--
Jack Gao
jackg...@outlook.com
> -Original Message-
> From: Ron
> Sent: Tuesday, April 17, 2018 9:44 AM
> To: Adrian Klaver ; pgsql-general gene...@postgresql.org>
> Subject: Re: pg_dump to a remote server
>
>
On 04/16/2018 11:07 PM, Adrian Klaver wrote:
On 04/16/2018 06:43 PM, Ron wrote:
On 04/16/2018 07:18 PM, Adrian Klaver wrote:
On 04/16/2018 04:58 PM, Ron wrote:
We're upgrading from v8.4 to 9.6 on a new VM in a different DC. The
dump file will be more than 1TB, and there's not enough disk sp
## Ron (ronljohnso...@gmail.com):
> > pg_dump -h host1 dbname | psql -h host2 dbname
>
> But that assumes --format=plain which will send a whole lot of
> uncompressed text across the wire.
You can also use pg_restore with standard input, i.e. pg_dump | pg_restore.
Regards,
Christoph
--
Spare
On 04/16/2018 06:43 PM, Ron wrote:
On 04/16/2018 07:18 PM, Adrian Klaver wrote:
On 04/16/2018 04:58 PM, Ron wrote:
We're upgrading from v8.4 to 9.6 on a new VM in a different DC. The
dump file will be more than 1TB, and there's not enough disk space on
the current system for the dump file.
On 04/16/2018 07:18 PM, Adrian Klaver wrote:
On 04/16/2018 04:58 PM, Ron wrote:
We're upgrading from v8.4 to 9.6 on a new VM in a different DC. The dump
file will be more than 1TB, and there's not enough disk space on the
current system for the dump file.
Thus, how can I send the pg_dump f
On 04/16/2018 07:47 PM, Gao Jack wrote:
-Original Message-
From: Ron
Sent: Tuesday, April 17, 2018 7:59 AM
To: pgsql-general
Subject: pg_dump to a remote server
We're upgrading from v8.4 to 9.6 on a new VM in a different DC. The dump
file will be more than 1TB, and there's not enough
> -Original Message-
> From: Ron
> Sent: Tuesday, April 17, 2018 7:59 AM
> To: pgsql-general
> Subject: pg_dump to a remote server
>
> We're upgrading from v8.4 to 9.6 on a new VM in a different DC. The dump
> file will be more than 1TB, and there's not enough disk space on the current
On Mon, Apr 16, 2018 at 6:58 PM, Ron wrote:
> We're upgrading from v8.4 to 9.6 on a new VM in a different DC. The dump
> file will be more than 1TB, and there's not enough disk space on the
> current system for the dump file.
>
> Thus, how can I send the pg_dump file directly to the new server w
On 04/16/2018 04:58 PM, Ron wrote:
We're upgrading from v8.4 to 9.6 on a new VM in a different DC. The
dump file will be more than 1TB, and there's not enough disk space on
the current system for the dump file.
Thus, how can I send the pg_dump file directly to the new server while
the pg_dum
11 matches
Mail list logo
