| From: | Dave Johansen <davejohansen(at)gmail(dot)com> |
|---|---|
| To: | Stephen Frost <sfrost(at)snowman(dot)net> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Setting up streaming replication with new server as master? |
| Date: | 2016-02-05 21:02:08 |
| Message-ID: | CAAcYxUe7zkKz6DSeqW88mPv4BasJnWwO2APnbU8=S20sSyTDMw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Fri, Feb 5, 2016 at 1:54 PM, Stephen Frost <sfrost(at)snowman(dot)net> wrote:
> 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.
>
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2016-02-05 21:09:28 | Re: Setting up streaming replication with new server as master? |
| Previous Message | Stephen Frost | 2016-02-05 20:54:57 | Re: Setting up streaming replication with new server as master? |