[pgpool-general: 8319] start/stop pgpool & postgres

Todd Stein todd.stein at microfocus.com
Fri Jul 8 22:16:57 JST 2022

Starting and stopping postgres and pgpool.
I've seen several posts and questions regarding the correct method to use for controlling postgres and pgpool.  I'm referring to the use of pg_ctl, deamon mode/systemd, or other creative ways....

The problem I've seen is that sometimes these methods do not remain in sync.  You may start postgres with pg_ctl and get false results when running sysemctl status postgresql-<ver>.

The pgpool scripts all use pg_ctl instead of systemd.

Is one way better?  Why?


Todd Stein

-----Original Message-----
From: pgpool-general <pgpool-general-bounces at pgpool.net> On Behalf Of Tatsuo Ishii
Sent: Friday, July 8, 2022 3:26 AM
To: Todd Stein <todd.stein at microfocus.com>
Cc: pgpool-general at pgpool.net
Subject: [pgpool-general: 8317] Re: scram authentication

> I'd like to use scram authentication with my pgpool/postgresql cluster.
> I don't know what to do with the pcp.conf file.  I don't find anything other than md5 encryption for this file.

pcp.conf only accepts md5 encryption.

> Should I be using md5 encryption for this file while using scram-sha-256 everywhere else?


Best reagards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
pgpool-general mailing list
pgpool-general at pgpool.net

More information about the pgpool-general mailing list