Re: Setting up streaming replication with new server as master?

From: Dave Johansen <davejohansen(at)gmail(dot)com>
To: John Scalia <jayknowsunix(at)gmail(dot)com>
Cc: Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Setting up streaming replication with new server as master?
Date: 2016-02-17 15:02:14
Message-ID: CAAcYxUftZpHqCb8O70JO1g-7_FbAP1bNPNvFkRxcqOSWeCSP6A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sat, Feb 6, 2016 at 6:38 PM, John Scalia <jayknowsunix(at)gmail(dot)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?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Keith 2016-02-17 15:32:21 Re: Setting up streaming replication with new server as master?
Previous Message Andrea Suisani 2016-02-17 14:59:56 Re: oracle db reads from postgresql