Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 7B5EB2D4D06 for ; Wed, 4 Jan 2012 07:42:47 -0400 (AST) Received: from s1v2.e-lietuva.lt ([82.135.156.154] helo=centos5.e-lietuva.lt) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RiPEx-0001EF-PC for pgsql-performance@postgresql.org; Wed, 04 Jan 2012 11:42:48 +0000 Received: (qmail 22180 invoked from network); 4 Jan 2012 13:42:27 +0200 Received: from ip-195-14-173-2.bnk.lt (HELO ?192.168.10.129?) (195.14.173.2) by s1v2.e-lietuva.lt with (DHE-RSA-AES256-SHA encrypted) SMTP; 4 Jan 2012 13:42:27 +0200 Message-ID: <4F043B22.3030801@ruptela.lt> Date: Wed, 04 Jan 2012 13:42:26 +0200 From: Aleksej Trofimov User-Agent: Mozilla/5.0 (X11; Linux i686; rv:8.0) Gecko/20111124 Thunderbird/8.0 MIME-Version: 1.0 To: Saurabh CC: pgsql-performance@postgresql.org Subject: Re: Postgresql Replication Performance References: <1325151184846-5107278.post@n5.nabble.com> <4EFC7A49.6070107@ruptela.lt> <4EFC8FD0.9020100@ruptela.lt> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201201/6 X-Sequence-Number: 46019 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