From: Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>
To: isabella.ghiurea@nrc-cnrc.gc.ca
Cc: pgsql-admin@postgresql.org
Subject: Re: virtual ip's for Pg host
Date: Sun, 17 Oct 2010 13:07:33 +0200
Message-ID: <4CBAD8F5.2010403@2ndQuadrant.it> (raw)
In-Reply-To: <4CB8C54B.5080505@nrc-cnrc.gc.ca>
References: <4CB8C54B.5080505@nrc-cnrc.gc.ca>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gabriele.bartolini@2ndQuadrant.it, isabella.ghiurea@nrc-cnrc.gc.ca
Subject: Re: virtual ip's for Pg host
In-Reply-To: <4CBAD8F5.2010403@2ndQuadrant.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox