Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 2E2941337999 for ; Sun, 17 Oct 2010 08:07:46 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 14481-05 for ; Sun, 17 Oct 2010 11:07:40 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from delta01.pnet.xcon.it (delta01.pnet.xcon.it [62.48.53.16]) by mail.postgresql.org (Postfix) with ESMTP id 3E6B6133729E for ; Sun, 17 Oct 2010 08:07:37 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by delta01.pnet.xcon.it (Postfix) with ESMTP id C3ECF181035F; Sun, 17 Oct 2010 13:07:36 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at delta01.pnet.xcon.it Received: from delta01.pnet.xcon.it ([127.0.0.1]) by localhost (delta01.pnet.xcon.it [127.0.0.1]) (amavisd-new, port 10024) with LMTP id KHwI6Vt2Tpc7; Sun, 17 Oct 2010 13:07:34 +0200 (CEST) Received: from macbook-di-gabriele-bartolini.local (host135-132-dynamic.35-79-r.retail.telecomitalia.it [79.35.132.135]) (Authenticated sender: gabriele.bartolini@devise.it) by delta01.pnet.xcon.it (Postfix) with ESMTPSA id E71361810341; Sun, 17 Oct 2010 13:07:33 +0200 (CEST) Message-ID: <4CBAD8F5.2010403@2ndQuadrant.it> Date: Sun, 17 Oct 2010 13:07:33 +0200 From: Gabriele Bartolini User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; it; rv:1.9.2.9) Gecko/20100915 Thunderbird/3.1.4 MIME-Version: 1.0 To: isabella.ghiurea@nrc-cnrc.gc.ca CC: pgsql-admin@postgresql.org Subject: Re: virtual ip's for Pg host References: <4CB8C54B.5080505@nrc-cnrc.gc.ca> In-Reply-To: <4CB8C54B.5080505@nrc-cnrc.gc.ca> 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.6 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_LOW=-0.7 X-Spam-Level: X-Archive-Number: 201010/141 X-Sequence-Number: 35882 Hello Isabella, Il 15/10/10 23:19, Isabella Ghiurea ha scritto: > 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 ? That should not be an issue for pg_hba.conf - although you must make sure that requests coming from your virtual LAN are allowed. On the other hand, the main configuration option you should properly set is 'listen_addresses', which specifies on which interfaces/IP addresses PostgreSQL is listening for incoming requests (http://www.postgresql.org/docs/current/static/runtime-config-connection.html). I hope this helps. Ciao, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartolini@2ndQuadrant.it | www.2ndQuadrant.it