Re: Fast logical replication jump start with PG 10 - Mailing list pgsql-general

From Jeff Janes
Subject Re: Fast logical replication jump start with PG 10
Date
Msg-id CAMkU=1wy7cxDpF1OteTimzM1Y7eOudW5hW8g0hQwwBKF+_QOUw@mail.gmail.com
Whole thread Raw
In response to Fast logical replication jump start with PG 10  (Olivier Gautherot <olivier@gautherot.net>)
List 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 by date:

Previous
From: Martín Marqués
Date:
Subject: Re: Fast logical replication jump start with PG 10
Next
From: Maroš Kollár
Date:
Subject: Update rules on views