[pgpool-general: 7870] Re: pgpool and postgresql 13

[Bo Peng]

Hello,

On Tue, 9 Nov 2021 18:01:08 +0000
Jon SCHEWE <jon.schewe at raytheon.com> wrote:

> I'm new to pgpool and using it to setup a high availability postgresql cluster. I have 3 systems, each one running pgpool and postgresql. I'm using pgpool 4.1 and postgresql 13 with streaming replication. I have most everything working, except failover across the postgresql servers. I see that in postgresql versions 12 and higher the file recover.conf file is no longer read. The scripts for pgpool creates myrecovery.conf instead. A couple of questions about this config
> 
> 1. Should I be modifying my postgresql.conf file to include myrecovery.conf? I haven't found this referenced in the documentation.
> 2. Should I be putting my primar_conninfo parameters in this file instead of postgresql.conf?

Are you using the scripts included in Pgpool-II 4.1 RPM?

https://git.postgresql.org/gitweb/?p=pgpool2.git;a=blob_plain;f=src/sample/scripts/follow_master.sh.sample;hb=refs/heads/V4_1_STABLE

If you are using the follow_master.sh.sample scripts included in Pgpool-II,
the script will automatically modify postgresql.conf to include myrecovery.conf.

======================
            if [ ${PGVERSION} -ge 12 ]; then
                sed -i -e \"\\\$ainclude_if_exists = '$(echo ${RECOVERYCONF} | sed -e 's/\//\\\//g')'\" \
                       -e \"/^include_if_exists = '$(echo ${RECOVERYCONF} | sed -e 's/\//\\\//g')'/d\" ${NODE_PGDATA}/postgresql.conf
                touch ${NODE_PGDATA}/standby.signal
            else
                echo \"standby_mode = 'on'\" >> ${RECOVERYCONF}
======================

> Thank you
> 
> 
> Jon Schewe
> 
> Principal Software Systems Technologist
> C: +1 612.263.2718
> O: +1 952.545.5720
> jon.schewe at raytheon.com
> Raytheon Technologies
> Raytheon Intelligence & Space
> 5775 Wayzata Blvd. Suite 630
> St. Louis Park, MN 55416
> 
> 
> RTX.com
> |
> LinkedIn
> |
> Twitter
> |
> Instagram
> 
> 
> 
> 
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
http://www.sraoss.co.jp/