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 ?
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 |