public inbox for [email protected]
help / color / mirror / Atom feedFrom: p sn <[email protected]>
To: [email protected]
Subject: Inquiry on Setting Up Automatic Failover with Stream Replication
Date: Mon, 11 Nov 2024 15:02:44 +0900
Message-ID: <CA+Z6K-U_hSkoCeBu5WLrxyz4kHNnj_orFP3cghBHj_di3OW9+g@mail.gmail.com> (raw)
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,
view thread (3+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: Inquiry on Setting Up Automatic Failover with Stream Replication
In-Reply-To: <CA+Z6K-U_hSkoCeBu5WLrxyz4kHNnj_orFP3cghBHj_di3OW9+g@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox