Converting drupal database from mysql to postgresql?

Question

For a large production Drupal 6 site using mysql, I am wondering

• Is it realistically feasibly to convert to postgresql?
• What are the pros/cons of using postgresql instead of mysql?
• Does the conversion worth the effort?
• What is the easiest way to do so?

Thanks

Answer 1

Here's a few fresh links that might help you along:

http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL
http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL

http://dbconvert.com/convert-mysql-to-postgresql-pro.php
http://railsonpostgresql.com/2010/10/20/converting-rails-apps-from-mysql-to-postgresql

Most of the links on google are pretty old though and contain very outdated info, so beware.