Re: Setting up streaming replication with new server as master? - Mailing list pgsql-admin

From Dave Johansen
Subject Re: Setting up streaming replication with new server as master?
Date
Msg-id CAAcYxUftZpHqCb8O70JO1g-7_FbAP1bNPNvFkRxcqOSWeCSP6A@mail.gmail.com
Whole thread Raw
In response to Re: Setting up streaming replication with new server as master?  (John Scalia <jayknowsunix@gmail.com>)
Responses Re: Setting up streaming replication with new server as master?
Re: Setting up streaming replication with new server as master?
List pgsql-admin
On Sat, Feb 6, 2016 at 6:38 PM, John Scalia <jayknowsunix@gmail.com> wrote:
If you specify -X f or more likely -X s, that will cause pg_basebackup to include the WAL files that were written after you started the operation. Since you're setting up a replica, use the -X s option as that's for streaming.

I ran pg_basebackup with -X s and it finished in the middle of the night last night. I would now like to make the switch, but what's the best way to copy over the records that have been inserted since the backup stopped?

pgsql-admin by date:

Previous
From: Andrea Suisani
Date:
Subject: Re: oracle db reads from postgresql
Next
From: Keith
Date:
Subject: Re: Setting up streaming replication with new server as master?