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

Praveen Kumar K S praveenssit at gmail.com
Tue Jun 9 17:31:26 JST 2020


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


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


More information about the pgpool-general mailing list