Postgres Pro
Downloads
Home   >   mailing lists

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

From Olivier Gautherot
Subject Fast logical replication jump start with PG 10
Date
Msg-id CAJ7S9TVygExihaXt2E1bNH_0kGnx8bA62fmGreDGWTwb3_Pi7g@mail.gmail.com
Whole thread Raw
Responses Re: Fast logical replication jump start with PG 10  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Fast logical replication jump start with PG 10  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
Tree view
Hi,

I just sent the question on StackOverflow but realized that this audience may be more savvy. So sorry in advance for cross-posting...

I'm in the process of upgrading a PG from 9.2 to 10.4. pg_upgrade worked fine on the master and was rather fast. The problem is that the database is replicated and I'm planning to switch from streaming to logical. The problem is that it is rather slow (30 minutes for the master and over 3 hours for the replication, between data transfer and indexes).

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.


Thanks in advance

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Syndicating PostgreSQL mailing list to Discourse
Next
From: Tom Lane
Date:
Subject: Re: Syndicating PostgreSQL mailing list to Discourse