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,
