Albe Laurenz wrote: > We sometimes need to move a database from one machine to another > (hardware old/broken, upgrades, etc.). Now whenever a database is > moved to a different computer, all the clients have to address the > database at the new hostname. > A lower-tech solution is:
http://freshmeat.net/projects/postgresql-relay/ It sits on top of PG and intercepts the connection protocol, as I understand it. Seems to work... ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster