[pgpool-general: 7122] Re: Queries regarding installation

Praveen Kumar K S praveenssit at gmail.com
Sat Jul 4 21:47:20 JST 2020 

Hello,

I managed to install package postgresql-9.6-pgpool2 on all postgres servers
and now am able to run the script.

On Sat, Jul 4, 2020 at 12:52 PM Praveen Kumar K S <praveenssit at gmail.com>
wrote:

> Hello,
>
> Any help on this is highly appreciated.
>
> On Fri, Jul 3, 2020 at 8:11 PM Praveen Kumar K S <praveenssit at gmail.com>
> wrote:
>
>> Hello,
>>
>> I'm facing issue executing this step at
>> https://www.pgpool.net/docs/40/en/html/install-pgpool-recovery.html
>>
>> I have 3 servers
>> pgpool1 - Only pgpool runs here
>> postgres1 - This is master
>> postgres2 - This is slave
>>
>> I have finished compilation of pgpool.
>>
>> On pgpool1, I have listed below.
>>
>> *ls -lrt /usr/lib/postgresql/9.6/lib/*
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> *-rw-r--r-- 1 root root  30632 May 13 13:09 utf8_and_win.so-rw-r--r-- 1
>> root root 284512 May 13 13:09 utf8_and_uhc.so-rw-r--r-- 1 root root 128864
>> May 13 13:09 utf8_and_sjis.so-rw-r--r-- 1 root root 190304 May 13 13:09
>> utf8_and_sjis2004.so-rw-r--r-- 1 root root  22368 May 13 13:09
>> tsearch2.so-rw-r--r-- 1 root root 173992 May 13 13:09 plpgsql.so-rw-r--r--
>> 1 root root  18272 May 13 13:09 libpqwalreceiver.so-rw-r--r-- 1 root root
>>  10080 May 13 13:09 euc2004_sjis2004.so-rw-r--r-- 1 root root 329640 May 13
>> 13:09 dict_snowball.so-rw-r--r-- 1 root root 280416 May 13 13:09
>> utf8_and_johab.so-rw-r--r-- 1 root root  34728 May 13 13:09
>> utf8_and_iso8859.so-rw-r--r-- 1 root root   5984 May 13 13:09
>> utf8_and_iso8859_1.so-rw-r--r-- 1 root root 354144 May 13 13:09
>> utf8_and_gbk.so-rw-r--r-- 1 root root 501600 May 13 13:09
>> utf8_and_gb18030.so-rw-r--r-- 1 root root 337760 May 13 13:09
>> utf8_and_euc_tw.so-rw-r--r-- 1 root root 137056 May 13 13:09
>> utf8_and_euc_kr.so-rw-r--r-- 1 root root 218976 May 13 13:09
>> utf8_and_euc_jp.so-rw-r--r-- 1 root root 124768 May 13 13:09
>> utf8_and_euc_cn.so-rw-r--r-- 1 root root 190304 May 13 13:09
>> utf8_and_euc2004.so-rw-r--r-- 1 root root  10080 May 13 13:09
>> utf8_and_cyrillic.so-rw-r--r-- 1 root root 227168 May 13 13:09
>> utf8_and_big5.so-rw-r--r-- 1 root root   5984 May 13 13:09
>> utf8_and_ascii.so-rw-r--r-- 1 root root  10080 May 13 13:09
>> latin_and_mic.so-rw-r--r-- 1 root root  10080 May 13 13:09
>> latin2_and_win1250.so-rw-r--r-- 1 root root  14176 May 13 13:09
>> euc_tw_and_big5.so-rw-r--r-- 1 root root   5984 May 13 13:09
>> euc_kr_and_mic.so-rw-r--r-- 1 root root  14176 May 13 13:09
>> euc_jp_and_sjis.so-rw-r--r-- 1 root root   5984 May 13 13:09
>> euc_cn_and_mic.so-rw-r--r-- 1 root root  14176 May 13 13:09
>> cyrillic_and_mic.so-rw-r--r-- 1 root root   5984 May 13 13:09
>> ascii_and_mic.so-rw-r--r-- 1 root root  74870 May 13 13:09
>> libpgport.a-rw-r--r-- 1 root root 141320 May 13 13:09
>> libpgfeutils.a-rw-r--r-- 1 root root  79926 May 13 13:09
>> libpgcommon.a-rw-r--r-- 1 root root   9944 May 25 12:04
>> pgpool-regclass.so-rw-r--r-- 1 root root  18136 May 25 12:04
>> pgpool_adm.sodrwxr-xr-x 4 root root   4096 Jul  3 12:29 pgxs-rwxr-xr-x 1
>> root root  46832 Jul  3 13:11 pgpool-recovery.so*
>>
>> ls -lrt pgpool-II-4.0.9/src/sql/pgpool-recovery
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> *-rw-rw-r-- 1 ubuntu ubuntu   136 May 19 10:00
>> uninstall_pgpool-recovery.sql-rw-rw-r-- 1 ubuntu ubuntu  1002 May 19 10:00
>> pgpool_recovery--1.1.sql-rw-rw-r-- 1 ubuntu ubuntu   533 May 19 10:00
>> pgpool-recovery.sql.in <http://pgpool-recovery.sql.in>-rw-rw-r-- 1 ubuntu
>> ubuntu   178 May 19 10:02 pgpool_recovery.control-rw-rw-r-- 1 ubuntu ubuntu
>>  9886 May 19 10:02 pgpool-recovery.c-rw-rw-r-- 1 ubuntu ubuntu  1246 May 19
>> 10:02 pgpool_recovery--1.2.sql-rw-rw-r-- 1 ubuntu ubuntu   430 May 19 10:02
>> pgpool_recovery--1.1--1.2.sql-rw-rw-r-- 1 ubuntu ubuntu   735 May 19 10:02
>> Makefile-rw-r--r-- 1 root   root   68240 Jul  3 13:09
>> pgpool-recovery.o-rwxr-xr-x 1 root   root   46832 Jul  3 13:09
>> pgpool-recovery.so-rw-r--r-- 1 root   root     640 Jul  3 14:18
>> pgpool-recovery.sql*
>>
>> Now, I executed "*psql -U postgres -h pg1 -f pgpool-recovery.sql
>> template1*" and got below output
>>
>>
>>
>>
>> *psql:pgpool-recovery.sql:4: ERROR:  could not access file
>> "$libdir/pgpool-recovery": No such file or
>> directorypsql:pgpool-recovery.sql:9: ERROR:  could not access file
>> "$libdir/pgpool-recovery": No such file or
>> directorypsql:pgpool-recovery.sql:14: ERROR:  could not access file
>> "$libdir/pgpool-recovery": No such file or
>> directorypsql:pgpool-recovery.sql:19: ERROR:  could not access file
>> "$libdir/pgpool-recovery": No such file or directory*
>>
>> I replaced $libdir with /usr/lib/postgresql/9.6/lib/pgpool-recovery
>>
>> cat pgpool-recovery.sql
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> *CREATE OR REPLACE FUNCTION pgpool_recovery(text, text, text,
>> text)RETURNS boolAS '/usr/lib/postgresql/9.6/lib/pgpool-recovery',
>> 'pgpool_recovery'LANGUAGE C STRICT;CREATE OR REPLACE FUNCTION
>> pgpool_remote_start(text, text)RETURNS boolAS
>> '/usr/lib/postgresql/9.6/lib/pgpool-recovery',
>> 'pgpool_remote_start'LANGUAGE C STRICT;CREATE OR REPLACE FUNCTION
>> pgpool_pgctl(text, text)RETURNS boolAS
>> '/usr/lib/postgresql/9.6/lib/pgpool-recovery', 'pgpool_pgctl'LANGUAGE C
>> STRICT;CREATE OR REPLACE FUNCTION pgpool_switch_xlog(text)RETURNS textAS
>> '/usr/lib/postgresql/9.6/lib/pgpool-recovery', 'pgpool_switch_xlog'LANGUAGE
>> C STRICT;*
>>
>> Again, I executed "psql -U postgres -h pg1 -f pgpool-recovery.sql
>> template1" and got below output
>>
>>
>>
>>
>> *psql:pgpool-recovery.sql:4: ERROR:  could not access file
>> "/usr/lib/postgresql/9.6/lib/pgpool-recovery": No such file or
>> directorypsql:pgpool-recovery.sql:9: ERROR:  could not access file
>> "/usr/lib/postgresql/9.6/lib/pgpool-recovery": No such file or
>> directorypsql:pgpool-recovery.sql:14: ERROR:  could not access file
>> "/usr/lib/postgresql/9.6/lib/pgpool-recovery": No such file or
>> directorypsql:pgpool-recovery.sql:19: ERROR:  could not access file
>> "/usr/lib/postgresql/9.6/lib/pgpool-recovery": No such file or directory*
>>
>> I'm following the official documentation and would like to know where I'm
>> going wrong.
>> Also, it is not explained in the docs on why this step is needed.
>>
>> Please suggest. TIA.
>>
>>
>>
>> On Thu, Jun 11, 2020 at 7:29 AM Bo Peng <pengbo at sraoss.co.jp> wrote:
>>
>>> Hello,
>>>
>>> On Tue, 9 Jun 2020 14:01:26 +0530
>>> Praveen Kumar K S <praveenssit at gmail.com> wrote:
>>>
>>> > Hello,
>>> >
>>> > I have installed only below dependencies on Ubuntu Server 16.04 till
>>> now.
>>> >
>>> > buildDeps=" \
>>> > docbook \
>>> > docbook-dsssl \
>>> > docbook-xsl \
>>> > libxml2-utils \
>>> > openjade1.3 \
>>> > opensp \
>>> > xsltproc \
>>> > openjade \
>>> > postgresql-server-dev-9.6 \
>>> > postgresql-common \
>>> > libpq-dev \
>>> > build-essential \
>>> > make \
>>> > gcc \
>>> > curl \
>>> > tar"
>>> >
>>> > 1. I'm not sure what path to specify if I have to configure using
>>> > "./configure --with-pgsql=  "
>>> > 2. In 2.5, there is a step to set
>>> >
>>> > pgpool.pg_ctl = '/usr/local/pgsql/bin/pg_ctl' in postgresql.conf But
>>> > pg_ctl is not there in my postgres server
>>>
>>> Sorry, I am not familiar with Ubuntu.
>>>
>>> You can get the top directory where PostgreSQL's libraries are installed
>>> using pg_config.
>>>
>>> >
>>> > On Tue, Jun 9, 2020 at 12:09 PM Bo Peng <pengbo at sraoss.co.jp> wrote:
>>> >
>>> > > Hello,
>>> > >
>>> > > On Tue, 9 Jun 2020 11:02:34 +0530
>>> > > Praveen Kumar K S <praveenssit at gmail.com> wrote:
>>> > >
>>> > > > Hello,
>>> > > >
>>> > > > May I know the equivalent package name for postgresql-libs and
>>> > > > postgresql-devel on Ubuntu 16.04 ? Without installing them, my
>>> > > compilation
>>> > > > got successful and I'm able to run pgpool. But I have issues
>>> connecting
>>> > > to
>>> > > > backend servers.
>>> > >
>>> > > I think the PostgreSQL library package may have been installed
>>> > > in your environment be default.
>>> > >
>>> > > > Also, it is described in the links below to execute scripts under
>>> > > template1
>>> > > > DB. Where should this be executed ? On all my 3 postgres servers ?
>>> > > >
>>> > > >
>>> > >
>>> https://www.pgpool.net/docs/pgpool-II-4.1.1/en/html/install-pgpool-recovery.html
>>> > > >
>>> > >
>>> https://www.pgpool.net/docs/pgpool-II-4.1.1/en/html/install-pgpool-regclass.html
>>> > > >
>>> > >
>>> https://www.pgpool.net/docs/pgpool-II-4.1.1/en/html/create-installlock-table.html
>>> > >
>>> > > Yes. You should execute on 3 PostgreSQL server
>>> > >
>>> > > As described in the links above, if you are using PostgreSQL 9.4 or
>>> later,
>>> > > and if you are not going to use the native replication mode,
>>> > > you can skip 2,6 and 2.7 section.
>>> > >
>>> > > [2.6. Installing pgpool-regclass]
>>> > > If you are using PostgreSQL 9.4 or later, you can skip this section.
>>> > >
>>> > > [2.7. Creating insert_lock table]
>>> > > If you are not going to use the native replication mode, you can
>>> skip this
>>> > > section.
>>> > >
>>> > >
>>> > > > On Tue, Jun 9, 2020 at 6:03 AM Bo Peng <pengbo at sraoss.co.jp>
>>> wrote:
>>> > > >
>>> > > > > hello,
>>> > > > >
>>> > > > > On Mon, 8 Jun 2020 16:04:33 +0530
>>> > > > > Praveen Kumar K S <praveenssit at gmail.com> wrote:
>>> > > > >
>>> > > > > > Hello All,
>>> > > > > >
>>> > > > > > I'm trying to install pgpool on Ubuntu 16.04 by compiling from
>>> > > source and
>>> > > > > > done till
>>> > > https://www.pgpool.net/docs/latest/en/html/install-pgpool.html
>>> > > > > >
>>> > > > > > Next steps at 2.6 2.7 2.8 are confusing. It says to execute
>>> scripts
>>> > > and
>>> > > > > set
>>> > > > > > some values. I would like to know where these steps should be
>>> > > performed.
>>> > > > > I
>>> > > > > > have 3 postgres servers with streaming enabled on a different
>>> set of
>>> > > VMs.
>>> > > > > > The one I'm trying to install pgpool is on a different VM. Am I
>>> > > missing
>>> > > > > > something?
>>> > > > >
>>> > > > > PostgreSQL libraries are required while compiling pgpool.
>>> > > > >
>>> > > > > You need to install postgresql-libs and postgresql-devel,
>>> > > > > and specify the path using "./configure --with-pgsql=  "
>>> > > > >
>>> > > > > > --
>>> > > > > >
>>> > > > > >
>>> > > > > > *Regards,*
>>> > > > > >
>>> > > > > >
>>> > > > > > *K S Praveen Kumar*
>>> > > > >
>>> > > > >
>>> > > > > --
>>> > > > > Bo Peng <pengbo at sraoss.co.jp>
>>> > > > > SRA OSS, Inc. Japan
>>> > > > >
>>> > > >
>>> > > >
>>> > > > --
>>> > > >
>>> > > >
>>> > > > *Regards,*
>>> > > >
>>> > > >
>>> > > > *K S Praveen Kumar*
>>> > >
>>> > >
>>> > > --
>>> > > Bo Peng <pengbo at sraoss.co.jp>
>>> > > SRA OSS, Inc. Japan
>>> > >
>>> >
>>> >
>>> > --
>>> >
>>> >
>>> > *Regards,*
>>> >
>>> >
>>> > *K S Praveen KumarM: +91-9986855625 *
>>>
>>>
>>> --
>>> Bo Peng <pengbo at sraoss.co.jp>
>>> SRA OSS, Inc. Japan
>>>
>>
>>
>> --
>>
>>
>> *Regards,*
>>
>>
>> *K S Praveen KumarM: +91-9986855625 *
>>
>
>
> --
>
>
> *Regards,*
>
>
> *K S Praveen KumarM: +91-9986855625 *
>


-- 


*Regards,*


*K S Praveen KumarM: +91-9986855625 *
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200704/98f973fd/attachment-0001.html>

More information about the pgpool-general mailing list