Inquiry on Setting Up Automatic Failover with Stream Replication

From: p sn <tkdsud01(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Inquiry on Setting Up Automatic Failover with Stream Replication
Date: 2024-11-11 06:02:44
Message-ID: CA+Z6K-U_hSkoCeBu5WLrxyz4kHNnj_orFP3cghBHj_di3OW9+g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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,

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Zaid Shabbir 2024-11-11 06:34:11 Re: Inquiry on Setting Up Automatic Failover with Stream Replication
Previous Message Tom Lane 2024-11-11 04:45:38 Re: How to check if session is a hung thread/session