Re: [GENERAL] Setting up replication slave on remote high latency host - Mailing list pgsql-general

From Rory Falloon
Subject Re: [GENERAL] Setting up replication slave on remote high latency host
Date
Msg-id CANP_6+NaXWNbapLHNZsfPPOgDJ+0h4wdVo67r6fLT0uFW8Fpgg@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Setting up replication slave on remote high latencyhost  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Thank you for that. Back to the drawing board!

On Wed, Nov 15, 2017 at 9:30 PM, John R Pierce <pierce@hogranch.com> wrote:
On 11/15/2017 6:02 PM, Rory Falloon wrote:

Right now I am trying to dump the database, gzip, move across, and import into the new slave (which is configured as a master to perform the initial setup). Ideally I do this dump, move and import during a period of inactivity on the master so the new server will come up and immediately be able to catch up on replication due to lack of activity. However, I have been importing the current db as a test and after 90 minutes it seems to have only got 2/3 of the way. I am not confident this will work but it seems like the most efficient way to start.


you can't use pg_dump to create a slave, as it won't have the same timeline.

I would use pg_basebackup, but in general streaming replication over a high latency erratic link will never work real well.


--
john r pierce, recycling bits in santa cruz



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: [GENERAL] Setting up replication slave on remote high latencyhost
Next
From: Jeff Janes
Date:
Subject: Re: [GENERAL] pg_basebackup running from a remote machine