Re: Fast logical replication jump start with PG 10

2018-05-26 Thread Olivier Gautherot
On Sat, May 26, 2018 at 1:27 PM, Adrian Klaver wrote: > On 05/26/2018 06:23 AM, Olivier Gautherot wrote: > >> On Sat, May 26, 2018 at 12:11 AM, Adrian Klaver < >> adrian.kla...@aklaver.com > wrote: >> On 05/25/2018 06:35 PM, Olivier Gautherot wrote: >> [snip]

Re: Fast logical replication jump start with PG 10

2018-05-26 Thread Jeff Janes
On Fri, May 25, 2018 at 5:12 PM, Olivier Gautherot 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 twitch

Re: Fast logical replication jump start with PG 10

2018-05-26 Thread Martín Marqués
Hi, El 26/05/18 a las 14:27, Adrian Klaver escribió: > > I am still learning what logical replication is capable of so take the > following with that in mind. > > 1) I used > pg_basebackup(www.postgresql.org/docs/10/static/app-pgbasebackup.html) > to create a new $DATA directory for a replica in

Re: Fast logical replication jump start with PG 10

2018-05-26 Thread Adrian Klaver
On 05/26/2018 06:23 AM, Olivier Gautherot wrote: Hi Adrian! On Sat, May 26, 2018 at 12:11 AM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 05/25/2018 06:35 PM, Olivier Gautherot wrote: Hi Adrian, thanks for your reply. Here is the clarification. 1) It is in

Re: Fast logical replication jump start with PG 10

2018-05-26 Thread Adrian Klaver
On 05/26/2018 06:23 AM, Olivier Gautherot wrote: Hi Adrian! On Sat, May 26, 2018 at 12:11 AM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 05/25/2018 06:35 PM, Olivier Gautherot wrote: Hi Adrian, thanks for your reply. Here is the clarification. 1) It is in

Re: Fast logical replication jump start with PG 10

2018-05-26 Thread Olivier Gautherot
Hi Adrian! On Sat, May 26, 2018 at 12:11 AM, Adrian Klaver wrote: > On 05/25/2018 06:35 PM, Olivier Gautherot wrote: > >> Hi Adrian, thanks for your reply. Here is the clarification. >> >> 1) It is indeed a pg_upgrade from 9.2 to 10.4. Depending on the test >> machine, it runs in between 15 and

Re: Fast logical replication jump start with PG 10

2018-05-25 Thread Adrian Klaver
On 05/25/2018 06:35 PM, Olivier Gautherot wrote: Hi Adrian, thanks for your reply. Here is the clarification. 1) It is indeed a pg_upgrade from 9.2 to 10.4. Depending on the test machine, it runs in between 15 and 20 minutes for just over 100GB. I can negotiate this time with our customer. The

Re: Fast logical replication jump start with PG 10

2018-05-25 Thread Olivier Gautherot
Hi Adrian, thanks for your reply. Here is the clarification. 1) It is indeed a pg_upgrade from 9.2 to 10.4. Depending on the test machine, it runs in between 15 and 20 minutes for just over 100GB. I can negotiate this time with our customer. The vacuum process took another 5 to 7 minutes. This thi

Re: Fast logical replication jump start with PG 10

2018-05-25 Thread Adrian Klaver
On 05/25/2018 02:12 PM, Olivier Gautherot wrote: 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 rathe