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

[Bo Peng]

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