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

[Praveen Kumar K S]

Hello,

Can anyone help me on this please ?

On Tue, Jun 9, 2020 at 2:01 PM 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
>
>
> 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 *
>


-- 


*Regards,*


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