Any real advantages? MySQL is becoming closed source as time goes by it seems. PostgreeSQL seems to still be free.
Here's a few comparisons: http://www-css.fnal.gov/dsg/external/freeware/pgsql-vs-mysql.html http://www.devx.com/dbzone/Article/20743/1763?supportItem=1 Why do you say that mysql is becoming closed source. Sun has been heading down the open source path for a while now.
Use the one available to you, if both are available try them both get to know them both. One example is the Index system in Postgresql you can feed the most weird functions into you index statement so in theory you can index the most complex where clauses directly into you index. If you need this then Postgresql is perfect. And Postgresql is a bit more neurotic with data integrity which I like but makes it harder to start with because you think Postgresql is fighting you but in the end when you learn more you know it is trying to protect you from mulilating data. On the other hand Mysql has its charmes as well. The bottom line is can it deliver what you need, only you can determine the specific advantages for your own project, I "needed" to switch to Postgresql because of the very custom indexing functionality. But when trying to do some full text searching I found the default Mysql easier to setup/use since at the time Postgresql had an addon package which I needed to setup manually on my Unix OS. Use them both and learn them both then you can decide the best one for your requirements. My personal favorite is Postgresql but thats just me.