PostgreSQL 9.0 - Hot Standby, Streaming Replication
For those of you running postgresql with some kind of multi-server setup, how do you do load balancing and replication right now?I'm running pgpool-ii but just tonight noticed some pretty serious discrepancies between the two backend postgresql instances so I am getting rid of pgpool for the time being.Will this change make pgpool-ii obsolete?