Fast Logical replication setup, via VM clone , PostgreSQL 16.9
От | Achilleas Mantzios |
---|---|
Тема | Fast Logical replication setup, via VM clone , PostgreSQL 16.9 |
Дата | |
Msg-id | 7bcef1b5-6e29-4eea-8c85-23a80dab4e2c@cloud.gatewaynet.com обсуждение исходный текст |
Ответы |
Re: Fast Logical replication setup, via VM clone , PostgreSQL 16.9
Re: Fast Logical replication setup, via VM clone , PostgreSQL 16.9 |
Список | 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 ?
В списке pgsql-admin по дате отправления: