Install pgpool from RPM

Question

I am installing pgpool-II on rhel 7. I want to install pgpool-II using RPM package for postgreSQL 9.2.

pgpool docs have below line mentioned

yum install pgpool-II-pg96
pg96 means PostgreSQL 9.5.

Does it mean pgpool-II-pg93 means pgpool for postgresql-9.2?

Also, i didnt find any package like pgpool-II-pg92

I would assume its a typo. I know 3.4 could not work with postgres 9.5, while 3.5 could. but eg 3.7 can work with both 9.6 and 10 - so logic is not minor release minus one :) btw pgpool docs have multiple typos — Vao Tsun, May 02 '18 at 16:25
ok got it. btw how can I install pgpool using rpm for PostgreSQL-9.2? — YogeshR, May 02 '18 at 18:20

score 1 · Accepted Answer · answered May 02 '18 at 18:59

1

the oldest release supporting Postgres 9.2 seems to be 3.4. Try one for your distro, eg for rhel-6-x86_64 here:

answered May 02 '18 at 18:59

Vao Tsun

I have one more question, do we need to setup pgppol on both master and slave? – YogeshR May 03 '18 at 12:56
1

mnah... if you aim to use `pgpool_recover` extension, you will need library and thus yes - you need it on every host you want to use in HA setup. but if you use it for load balancing or pooling - no, I would not say you need it on slaves – Vao Tsun May 03 '18 at 13:00
What are other alternates of Virtual IP that can be used so that we don't have to change connection strings after failover? Is there any tool for the same? – YogeshR May 04 '18 at 08:56

score 0 · Answer 2 · answered Apr 08 '22 at 07:53

0

You can install pgpool II for Postgresql 9.2 from link

answered Apr 08 '22 at 07:53

Viettel Solutions

2 Answers2