Fast Logical replication setup, via VM clone , PostgreSQL 16.9

From: Achilleas Mantzios <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Fast Logical replication setup, via VM clone , PostgreSQL 16.9
Date: 2025-06-30 07:36:13
Message-ID: 7bcef1b5-6e29-4eea-8c85-23a80dab4e2c@cloud.gatewaynet.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I gotta provide again a logical repl subscriber for our devs, we are
running PostgreSQL 16.9 .

Instead of going the traditional logical replication way (which involves
long running COPY, catchup, etc), I am thinking of doing something along
the lines :

1) @publisher (master) create repl slot, create publication

2) shutdown postgresql ,

3) clone the VM,

4) boot the clone (subscriber),

5) @subscriber start postgresql , drop publication, drop replication
slot, create the subscription using repl slot of 1)

6) @master start postgresql .

or a version with less downtime for the publisher (aka master , primary) :

1) @publisher (master) create repl slot, create publication

2) shutdown postgresql ,

3) clone the VM,

4) start master,

5) boot the clone (subscriber),

6) @subscriber start postgresql , drop the publication, drop the
replication slot, create the subscription using repl slot of 1)

do you find any gotchas in the above ?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2025-06-30 07:47:17 Re: Fast Logical replication setup, via VM clone , PostgreSQL 16.9
Previous Message Ron Johnson 2025-06-26 14:54:14 Re: Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation