| From: | Aleksej Trofimov <aleksej(dot)trofimov(at)ruptela(dot)lt> |
|---|---|
| To: | Saurabh <saurabh(dot)b85(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Postgresql Replication Performance |
| Date: | 2012-01-04 11:42:26 |
| Message-ID: | 4F043B22.3030801@ruptela.lt |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 01/04/2012 12:41 PM, Saurabh wrote:
> Thank you all for the valuable information. Now we have decide to go
> with streaming replication. I did the setup on machine and it is
> working good. Now I have to implement the automatic failover. Please
> share a solution for the same.
>
> Saurabh Gupta
>
You ca use pgpool-II for automatic failover and connection cache. This
article is good enough
http://pgpool.projects.postgresql.org/contrib_docs/simple_sr_setting/index.html
Also do not forget to configure Postgres max_connections >= (pgpool)
num_init_children*max_pool if you'll use connections cache.
--
Best regards
Aleksej Trofimov
| From | Date | Subject | |
|---|---|---|---|
| Next Message | antoine | 2012-01-06 14:35:36 | Duplicate deletion optimizations |
| Previous Message | Saurabh | 2012-01-04 10:41:40 | Re: Postgresql Replication Performance |