[pgpool-general: 7119] Re: Queries regarding installation
Praveen Kumar K S
praveenssit at gmail.com
Fri Jul 3 23:41:34 JST 2020
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 *
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200703/7b5b5135/attachment-0001.html>
More information about the pgpool-general
mailing list