> I was planning on using pgbouncer, but I've spent very little time> evaluating it or experimenting with test environments.
Great. I am currently investigating possibilities. I'm setting up a
replicated HA PgSQL which will be used for a bunch of projects -
including my instance of sourcehut.
Pgbouncer is fine for me, but it doesn't include automatic failover. I
am considering between pgpool II and pgbouncer with repmgr. I would like
to limit used software, so pgpool II is preferred now, but I'm not fully
satisfied with its automatic failover. What's more I have some non
standard errors on quite standard configuration, so I'm not convinced.
I would be glad of hearing from you about your solutions when you will
be preparing HA setup.