pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
virtual ip's for Pg host 2+ messages / 2 participants [nested] [flat]
* virtual ip's for Pg host @ 2010-10-15 21:19 Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca> 2010-10-17 11:07 ` Re: virtual ip's for Pg host Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it> 0 siblings, 1 reply; 2+ messages in thread From: Isabella Ghiurea @ 2010-10-15 21:19 UTC (permalink / raw) To: pgsql-admin 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: virtual ip's for Pg host 2010-10-15 21:19 virtual ip's for Pg host Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca> @ 2010-10-17 11:07 ` Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it> 0 siblings, 0 replies; 2+ messages in thread From: Gabriele Bartolini @ 2010-10-17 11:07 UTC (permalink / raw) To: isabella.ghiurea@nrc-cnrc.gc.ca; +Cc: pgsql-admin 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-10-17 11:07 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2010-10-15 21:19 virtual ip's for Pg host Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca> 2010-10-17 11:07 ` Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>
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