[pgpool-hackers: 4543] PgPool doesn't update password into the file mentioned in pool_passwd parameter

[Sadhuprasad Patro]

Hi Hackers,

Checked in PgPool 4.5 version.

During the test, we modified the location of the "pool_passwd"
parameter in pgpool.conf file and restarted the PGPOOL services.
Then we executed the "pg_enc" utility to update the password but it is
updating the password in old file "/etc/pgpool-II/pgpool.conf" rather
than "/home/postgres/pool_passwd" new file.


#-- modifying location
[postgres at pgpgp01 ~]$ vi /etc/pgpool-II/pgpool.conf
[postgres at pgpgp01 ~]$ cat /etc/pgpool-II/pgpool.conf|grep pool_passwd
pool_passwd = '/home/postgres/pool_passwd'

#-- restart pgpool
[postgres at pgpgp01 ~]$ pgpool stop
2024-11-22 08:27:41.060: main pid 24051: LOG:  stop request sent to
pgpool (pid: 5372). waiting for termination...
.done.
[postgres at pgpgp01 ~]$ pgpool -D -f /etc/pgpool-II/pgpool.conf
-rw-rw-r--.  1 postgres postgres    0 Nov 22 08:27 pool_passwd
[postgres at pgpgp01 ~]$ cat /home/postgres/pool_passwd
[postgres at pgpgp01 ~]$
[postgres at pgpgp01 ~]$ cat /etc/pgpool-II/pool_passwd
pgpool:AESTceUCq7IXKAqtzX5L6t1Tw==

#-- generate password
[postgres at pgpgp01 ~]$ pg_enc -k .pgpoolkey -f
/etc/pgpool-II/pgpool.conf -m -u test test
trying to read key from file .pgpoolkey
[postgres at pgpgp01 ~]$ cat /home/postgres/pool_passwd -- current
"pool_passwd" location
[postgres at pgpgp01 ~]$ cat /etc/pgpool-II/pool_passwd -- not current
"pool_passwd" location
pgpool:AESTceUCq7IXKAqtzX5L6t1Tw==
test:AESKA9Z8LUAIaomz6Jl3fRLVQ==


Why does Pgpool-II keep updating the old pool_passwd file even after I
modified its location?
Please help to understand this as a behavior or there is some issue...
-- 
thank u
               SADHU PRASAD