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

Поиск
Список
Период
Сортировка
От Dave Johansen
Тема Re: Setting up streaming replication with new server as master?
Дата
Msg-id CAAcYxUftZpHqCb8O70JO1g-7_FbAP1bNPNvFkRxcqOSWeCSP6A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Setting up streaming replication with new server as master?  (John Scalia <jayknowsunix@gmail.com>)
Ответы Re: Setting up streaming replication with new server as master?  (Keith <keith@keithf4.com>)
Re: Setting up streaming replication with new server as master?  (John Scalia <jayknowsunix@gmail.com>)
Список pgsql-admin
On Sat, Feb 6, 2016 at 6:38 PM, John Scalia <jayknowsunix@gmail.com> wrote:
If you specify -X f or more likely -X s, that will cause pg_basebackup to include the WAL files that were written after you started the operation. Since you're setting up a replica, use the -X s option as that's for streaming.

I ran pg_basebackup with -X s and it finished in the middle of the night last night. I would now like to make the switch, but what's the best way to copy over the records that have been inserted since the backup stopped?

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

Предыдущее
От: Andrea Suisani
Дата:
Сообщение: Re: oracle db reads from postgresql
Следующее
От: Keith
Дата:
Сообщение: Re: Setting up streaming replication with new server as master?