Postgres Pro
Downloads
Home   >   mailing lists

Re: Setup pgpool-II with streaming replication - Mailing list pgsql-general

From Venkata B Nagothi
Subject Re: Setup pgpool-II with streaming replication
Date
Msg-id CAEyp7J-mZ-=SEgU6cJ_Sq87GCrLKFT5_QGSQv+OHLWgCSw_8jg@mail.gmail.com
Whole thread Raw
In response to Setup pgpool-II with streaming replication  (Ashish Chauhan <Ashish.Chauhan@support.com>)
List pgsql-general
Tree view

On Fri, Sep 9, 2016 at 3:14 AM, Ashish Chauhan <Ashish.Chauhan@support.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

pgsql-general by date:

Previous
From: Theron Luhn
Date:
Subject: Re: Understanding Postgres Memory Usage
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: qustion about pgaudit