Re: setting up streaming replication - Mailing list pgsql-general

From David G. Johnston
Subject Re: setting up streaming replication
Date
Msg-id CAKFQuwbYz+N1D26V77q_wxY5WVTwBmzA+SdfH6qa3n9kV284kQ@mail.gmail.com
Whole thread Raw
In response to setting up streaming replication  (Brad White <b55white@gmail.com>)
List pgsql-general
On Monday, October 23, 2023, Brad White <b55white@gmail.com> wrote:
I'm stumped.

Using this command to set up the slave and replication on PG v 15:


You must, by some means:

Have PostgreSQL binaries installed on the machine that is to become the replica.
Have the output of pg_basebackup present on the replica; removing the cluster that is initially installed and replacing it with the backup tends to be easiest.

The means by which you run pg_basebackup aren’t all that interesting since there is this thing called copy file.

The output of pg_basebackup is the data directory for the cluster so of course the cluster cannot be running until you’ve put the contents into place and ensured the proper configuration and added the standby.signal file.  Admittedly, if you choose to destroy an existing cluster in order to install the new one in its location of course you’ll need to shut down that existing cluster before destroying it.  But this later point isn’t going to be documented because it isn’t an inherent task but rather one you choose as a convenience due to using a packager that handles most of cluster configuration for you and a lack of desire to configure the replica cluster from scratch.

David J.


pgsql-general by date:

Previous
From: b55white
Date:
Subject: Re: setting up streaming replication
Next
From: Ron
Date:
Subject: Re: setting up streaming replication