[pgpool-general: 4361] Re: having trouble installing online_recovery.

[kiet.h.lieng]

I took your suggestion and it worked. 

Heres what I did if anybody is stuck like me:
1. remove all references of pgpool or postgres database from the server.  (went as far as deleting the data directory so we can get a new one)
2. Added the RPM
3. installed the following 
  postgresql-libs.x86_64              9.2.14-1.el7_1             @updates
  postgresql94.x86_64                 9.4.5-1PGDG.rhel7          @pgdg94
  postgresql94-contrib.x86_64         9.4.5-1PGDG.rhel7          @pgdg94
  postgresql94-debuginfo.x86_64       9.4.5-1PGDG.rhel7          @pgdg94
  postgresql94-devel.x86_64           9.4.5-1PGDG.rhel7          @pgdg94
  postgresql94-libs.x86_64            9.4.5-1PGDG.rhel7          @pgdg94 
  postgresql94-server.x86_64          9.4.5-1PGDG.rhel7          @pgdg94
4. reinitialize database
5. downloaded pgpool-II-3.4.3.tar.gz
6. install gcc
7. update path to include postgres bin path (for me it was /usr/pgsql-9.4/bin)
8. go into tar extract path /root/pgpool-II-3.4.3/src/sql/pgpool-recovery
9. make & make install
10. start and log into postgres 
11. CREATE EXTENSION pgpool_recovery;


Thanks a lot for the recommendations.



> On Jan 25, 2016, at 10:15 AM, Devrim GÜNDÜZ <devrim at gunduz.org> wrote:
> 
> 
> Hi,
> 
> On Mon, 2016-01-25 at 09:22 -0800, kiet.h.lieng wrote:
>> I’m running on Centos 7.2.  Postgres 9.2.  I’ve tried this on a
>> number of machines, nothing seems to work.
> 
> FWIW, http://yum.PostgreSQL.org has both PostgreSQL 9.2 and pgpool-II
> 3.4.3 RPMs.
> 
> Regards,
> -- 
> Devrim GÜNDÜZ
> Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
> PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
> Twitter: @DevrimGunduz , @DevrimGunduzTR
> 
>