| From: | Ashish Chauhan <Ashish(dot)Chauhan(at)support(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Setup pgpool-II with streaming replication |
| Date: | 2016-09-06 21:10:52 |
| Message-ID: | 6837D32772C03D42BF09864A2DACFF9B1DF94528@dcmail02.supportsoft.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
We do have Postgres 9.4 streaming replication in Prod environment, currently we are having issue with our DB connections and planning to implement PgPool-II for database pooling with streaming replication.
Key Challenges:
* Cannot afford downtime on db servers.
* Add PgPool-II with current streaming replication.
* Not planning to use PgPoolAdmin tool.
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?
http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/
http://www.wirabumisoftware.com/en/openbravo-developer-guide/postgresqldevtutorial/25-pgsqlid/82-install-pgpool2
Thanks,
Ashish Chauhan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrick B | 2016-09-06 22:22:54 | Postgres UPGRADE from 9.2 to 9.4 |
| Previous Message | Tom Lane | 2016-09-06 20:32:30 | Re: Privileges on public schema can't be revoked? |