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

Поиск
Список
Период
Сортировка
От Dave Johansen
Тема Re: Setting up streaming replication with new server as master?
Дата
Msg-id CAAcYxUe7zkKz6DSeqW88mPv4BasJnWwO2APnbU8=S20sSyTDMw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Setting up streaming replication with new server as master?  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: Setting up streaming replication with new server as master?  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-admin
Дерево обсуждения
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?

В списке pgsql-admin по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: Setting up streaming replication with new server as master?
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Setting up streaming replication with new server as master?