Sample Header Ad - 728x90

Is it possible to add a PostgreSQL hot standby using pg_createcluster to a primary created with initdb?

0 votes
1 answer
86 views
Hi we are using PostgreSQL 16 on Ubuntu 22 LTS and have built a cluster using initdb. I'm wondering if it's possible to rebuild a standby using pg_createcluster instead to take advantage of various admin tools and join it to the cluster so that we can eventually failover (we use repmgr), and then remove the old nodes and rebuild them using pg_createcluster as well. As I understand it pg_createcluster is essentially a wrapper around initdb. Unfortunately being in production, simply rebuilding the entire cluster is a no-go, so our choice is to either live with it having been built using initdb, or add/remove nodes until the entire cluster is rebuilt with pg_createcluster.
Asked by Di Si (3 rep)
Oct 8, 2024, 06:34 PM
Last activity: Oct 9, 2024, 06:13 AM