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

Praveen Kumar K S praveenssit at gmail.com
Sat Jul 4 16:22:59 JST 2020 

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 *
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200704/6e10ca4f/attachment.html>

More information about the pgpool-general mailing list