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

From Stephen Frost
Subject Re: Setting up streaming replication with new server as master?
Date
Msg-id 20160205205456.GA3331@tamriel.snowman.net
Whole thread Raw
In response to Re: Setting up streaming replication with new server as master?  (Dave Johansen <davejohansen@gmail.com>)
Responses Re: Setting up streaming replication with new server as master?  (Dave Johansen <davejohansen@gmail.com>)
List pgsql-admin
Dave,

* Dave Johansen (davejohansen@gmail.com) wrote:
> So will pg_basebackup keep copying the new data that is added over the
> weekend until I tell it to stop? If so, then on Monday, can I close things
> down, wait for the WAL to finish, swap the roles of the 2 server and then
> restart?

No, pg_basebackup will take a snapshot of the current system,
essentially.  You can set up the new system to connect to the current
system, using recovery.conf, to pull the WAL records and apply them to
the new server.

Thanks!

Stephen

Attachment

pgsql-admin by date:

Previous
From: Dave Johansen
Date:
Subject: Re: Setting up streaming replication with new server as master?
Next
From: Dave Johansen
Date:
Subject: Re: Setting up streaming replication with new server as master?