Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 4DFE31337990 for ; Fri, 15 Oct 2010 18:19:17 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 59702-09 for ; Fri, 15 Oct 2010 21:19:10 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from nrccenhts1.nrc.ca (nrccenhts2.nrc.ca [132.246.15.89]) by mail.postgresql.org (Postfix) with ESMTP id 084301335B36 for ; Fri, 15 Oct 2010 18:19:09 -0300 (ADT) Received: from NRCWSTHCM1.NRC.CA (132.246.216.66) by nrccenhts2.nrc.ca (132.246.15.89) with Microsoft SMTP Server (TLS) id 8.1.436.0; Fri, 15 Oct 2010 17:19:09 -0400 Received: from [132.246.194.17] (132.246.216.202) by WSTMAIL.NRC.CA (132.246.216.66) with Microsoft SMTP Server (TLS) id 8.1.436.0; Fri, 15 Oct 2010 14:19:08 -0700 Message-ID: <4CB8C54B.5080505@nrc-cnrc.gc.ca> Date: Fri, 15 Oct 2010 14:19:07 -0700 From: Isabella Ghiurea Reply-To: isabella.ghiurea@nrc-cnrc.gc.ca Organization: CADC -NRC User-Agent: Thunderbird 2.0.0.19 (X11/20090105) MIME-Version: 1.0 To: Subject: virtual ip's for Pg host Content-Type: text/plain; charset="ISO-8859-1"; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.301 tagged_above=-10 required=5 tests=BAYES_40=-0.001, RCVD_IN_DNSWL_MED=-2.3 X-Spam-Level: X-Archive-Number: 201010/135 X-Sequence-Number: 35876 Hi All we would like to implement a virtual ip for two of our of our PG db hosts to help us with switching hosts with less downtime for clients, is there any specific change need to be done on PG database hosts configuration , I was thinking maybe pg_hba.conf file ? Thank you Isabella -- ----------------------------------------------------------- Isabella A. Ghiurea Isabella.Ghiurea@nrc-cnrc.gc.ca Canadian Astronomy Data Centre |http://www.nrc-cnrc.gc.ca/eng/services/hia/data-centre.html National Research Council of Canada, Herzberg Institute of Astrophysics 5071 West Saanich Road, Victoria BC V9E 2E7, Canada Phone: 250 363-3446 fax: 250 363-0045