Postgres Pro
Downloads
Home   >   mailing lists

Inquiry on Setting Up Automatic Failover with Stream Replication - Mailing list pgsql-admin

From p sn
Subject Inquiry on Setting Up Automatic Failover with Stream Replication
Date
Msg-id CA+Z6K-U_hSkoCeBu5WLrxyz4kHNnj_orFP3cghBHj_di3OW9+g@mail.gmail.com
Whole thread Raw
Responses Re: Inquiry on Setting Up Automatic Failover with Stream Replication
List pgsql-admin
Tree view
  Hello, I am currently setting up PostgreSQL Stream Replication for a replication configuration. 

 I am using PostgreSQL version 14.12 on a RedHat 8.9 environment, 
and my setup consists of a Primary-Standby replication configuration with two nodes.
 Due to certain constraints, I cannot add more nodes or use external nodes. 

  Questions: 
    1-1. How should I configure postgresql.conf and pg_hba.conf for this setup? I would like to implement automatic failover with only these two nodes. 
    1-2. Is it possible to achieve this setup? If so, could you advise on the specific configuration steps needed? I would greatly appreciate any guidance from those with experience in this area. Thank you. 


 Best regards,  

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to check if session is a hung thread/session
Next
From: Zaid Shabbir
Date:
Subject: Re: Inquiry on Setting Up Automatic Failover with Stream Replication