On Fri, Feb 5, 2016 at 1:54 PM, Stephen Frost <sfrost@snowman.net> wrote:
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.
So do I set that up before running pg_basebackup?
Or in other words, pg_basebackup will get all of the existing data and then the setup using recovery.conf will get the new data?
