Re: Fast logical replication jump start with PG 10

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Fast logical replication jump start with PG 10
Дата
Msg-id CAMkU=1wy7cxDpF1OteTimzM1Y7eOudW5hW8g0hQwwBKF+_QOUw@mail.gmail.com
обсуждение исходный текст
Ответ на Fast logical replication jump start with PG 10  (Olivier Gautherot <olivier@gautherot.net>)
Список pgsql-general
On Fri, May 25, 2018 at 5:12 PM, Olivier Gautherot <olivier@gautherot.net> wrote:

Is there a way to speed up the replication or should I rather stick to streaming replication? As I have only 1 database on the server, it would not be a show-stopper.

You have a method that works, and a client that is already twitchy about downtime and only upgrades their database once every 5 years.

I would not even consider the idea of combining a major-version upgrade with a complete change-over in replication technology in a single step in this situation.

If you will get some kind of benefit from switching to logical replication, you could first upgrade production and get a new physical replica going, then once that is returned to production you can create a new logical replica and get it all synced over at your leisure, then get it all tested and then cut the clients over from the physical replica to the logical replica.  

 Cheers,

Jeff

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

Предыдущее
От: Martín Marqués
Дата:
Сообщение: Re: Fast logical replication jump start with PG 10
Следующее
От: Maroš Kollár
Дата:
Сообщение: Update rules on views