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