We started with MySQL and switched to PostgreSQL when some unit tests started to fail after doing a minor MySQL upgrade. Something like going from 5.0.1 to 5.0.2. We tracked this down to MySQL giving completely different result sets for the same (not very complex) query after the small upgrade.
We never looked back. PostgreSQL is really powerful and we use it in a clustered and soon sharded setup. Works well for us.