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

[Todd Stein]

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?

Regards,

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?

Yes.

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