Re: Setup pgpool-II with streaming replication

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.

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

Thanks,
Ashish

From: Venkata B Nagothi [mailto:nag1010(at)gmail(dot)com]
Sent: Wednesday, September 07, 2016 5:46 PM, 17:46
To: Ashish Chauhan
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Setup pgpool-II with streaming replication

I gone through below articles but some or other way require DB server restart which is not possible in our case. Could you please provide some documentation or steps how to achive connection pooling without any downtime?

DB server restart ? Why do you think you need to restart the database ? that can be confirmed if you could help us know your planned architecture and the existing database configuration settings.
Yes, downtime is definitely needed as the Application needs to connect to the database using pgPool port instead of DB port which is something to do with the Application server.
Regards,
Venkata B N
Fujitsu Australia