I've been developing an app w/ server infrastructure for a while now, and I'm getting ready to release soon(ish).
So far the server backend has been running on PostgreSQL 8.4.7, and it's working as it should.
Right now, though, I'm thinking about upgrading to 9.0.X to be on a more recent release for the beta testing (and subsequent release), and to make it easier to set up database replication in the future.
My questions:
Is PostgreSQL 9.0.4 a viable DB to use as of now? Are there any known major bugs?
Are there any noticeable performance differences?
Is replication (async ok, sync preferred) easier to set up in 9.0.X than in 8.4.X?