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

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Dave Johansen <davejohansen(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Setting up streaming replication with new server as master?
Date: 2016-02-05 20:54:57
Message-ID: 20160205205456.GA3331@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dave,

* Dave Johansen (davejohansen(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dave Johansen 2016-02-05 21:02:08 Re: Setting up streaming replication with new server as master?
Previous Message Dave Johansen 2016-02-05 20:44:42 Re: Setting up streaming replication with new server as master?