Re: Setup pgpool-II with streaming replication

On Fri, Sep 9, 2016 at 3:14 AM, Ashish Chauhan <Ashish(dot)Chauhan(at)support(dot)com>
wrote:

> Thanks Venkata for your reply.
>
>
>
> Currently, we have two Postgres server with master-slave streaming
> replication. All application servers are directly pointing to master server
> only. I am planning to setup new server for PgPool, at the time of divert
> app server to PgPool, I will pool out application server one by one from
> Load balancer and point it to PgPool which will not affect our application.
>

That should probably minimize your downtime. Still you need to change the
port number (from database port to pgpool port) in the App configuration,
will that not require the Application restart ? I am just curious to know.

> Could you pls send me steps how to install PgPool without PgPoolAdmin?
>

Below link has complete instructions to install and configure pgPool

http://www.pgpool.net/docs/latest/tutorial-en.html#install

pgPool Admin is a separate tool which does not come along with pgPool
software by default.

Regards,
Venkata B N

Fujitsu Australia

>