Re: WAL Async Replication Question

On 11/10/22 02:27, KK CHN wrote:
> List,
>
> I've done   WAL async replication  between two  Postgre servers in Pirmary
> and Standby node as a test bed on two Virtual Machines on CentOS 8.
> Postgres12.
>
> Now I want to do the same WAL replication on a  Production Postgres 
> server to a new standby server.
>
> Is there a way to do configurations for WAL async replication on  primary
> server without affecting the customers / applications that depend on this
> primary DB server?
>
> As it is a production server,  any changes we make to configuration files
> may affect the services right ?  or what unseen problems can arise in this
> use  case?
>
> How to minimize the downtime / without service interruptions from the
> Primary server while doing WAL replication to a Standby server.

As long as "wal_level = replica" (which is the default) you do not need to
stop and restart the Primary instance.  Testing should have demonstrated
that to you.

--
Angular momentum makes the world go 'round.