Re: pg_dump to a remote server

From: Michael Nolan <htfoot(at)gmail(dot)com>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dump to a remote server
Date: 2018-04-17 00:21:45
Message-ID: CAOzAqu+VpOfzBHwcqptSzm3PkeZAjkqqc0XqB+A-jBNioU6x+g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Apr 16, 2018 at 6:58 PM, Ron <ronljohnsonjr(at)gmail(dot)com> 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_dump command is running? NFS is one method, but are there others
> (netcat, rsync)? Since it's within the same company, encryption is not
> required.
>

Can you run pg_dump on the new server, connecting remotely to the current
one?
--
Mike Nolan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gao Jack 2018-04-17 00:47:45 RE: pg_dump to a remote server
Previous Message Adrian Klaver 2018-04-17 00:18:02 Re: pg_dump to a remote server