[pgpool-general: 8742] Re: Config files in RPM package

Bo Peng pengbo at sraoss.co.jp
Mon Apr 17 15:43:04 JST 2023


hello,

On Fri, 14 Apr 2023 10:55:24 -0400
zam bak <zam6ak at gmail.com> wrote:

> Hi
> 
> I am migrating towards using packages in PgPool YUM repository instead
> of using the PGDG repo (pgdg-common).
> 
> I have noticed that the RPM package in PgPool repo contains config
> files (in addition to samples). I am used to having just .sample files
> and then copying them and making changes.
> 
> # dnf repoquery --disablerepo="*" --enablerepo="pgpool44" -l
> pgpool-II-pg14 | grep "/etc" | sort | uniq
> 
> Last metadata expiration check: 0:02:31 ago on Fri 14 Apr 2023 10:42:29 AM EDT.
> /etc/pgpool-II/pcp.conf
> /etc/pgpool-II/pcp.conf.sample
> /etc/pgpool-II/pgpool.conf
> /etc/pgpool-II/pgpool.conf.sample
> /etc/pgpool-II/pgpool_node_id
> /etc/pgpool-II/pool_hba.conf
> /etc/pgpool-II/pool_hba.conf.sample
> /etc/pgpool-II/pool_passwd
> /etc/pgpool-II/sample_scripts/aws_eip_if_cmd.sh.sample
> /etc/pgpool-II/sample_scripts/aws_rtb_if_cmd.sh.sample
> /etc/pgpool-II/sample_scripts/escalation.sh.sample
> /etc/pgpool-II/sample_scripts/failover.sh.sample
> /etc/pgpool-II/sample_scripts/follow_primary.sh.sample
> /etc/pgpool-II/sample_scripts/pgpool_remote_start.sample
> /etc/pgpool-II/sample_scripts/recovery_1st_stage.sample
> /etc/pgpool-II/sample_scripts/replication_mode_recovery_1st_stage.sample
> /etc/pgpool-II/sample_scripts/replication_mode_recovery_2nd_stage.sample
> /etc/sudoers.d/pgpool
> /etc/sysconfig/pgpool
> 
> 
> 
> My question is this:
> 
> If I make changes to .conf files or pool_passwd and then
> update/upgrade PgPool in the future. will my changes to these files
> get lost (overwritten by new versions)?

No. The changes will not be overwritten while upgrading.

It is always recommended to take a backup of all configuration files
before upgrading even if they won't be overwritten.

-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS LLC
https://www.sraoss.co.jp/



More information about the pgpool-general mailing list