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

If you're going to switch DBs for performance reasons, and have the ability to change server software, I'd suggest you look into MariaDB - drop in replacement for the MySQL binary. — David Fells
– David Fells, Commented May 8, 2011 at 19:55
@David, it's the first time that I hear about MariaDB, thanks for the clue. — qliq
– qliq, Commented May 8, 2011 at 20:01
Drupal (especially Drupal 6) isn't really optimized to work with PostgreSQL and there is no guarantee that all your contrib modules will work with PostgreSQL (Most do, but there are always bugs or accidental use of MySQL only SQL syntax). I think you're better off improving the performance of your MySQL server. See for example drupal.stackexchange.com/questions/1715/… — Berdir
– Berdir, Commented May 8, 2011 at 23:22

Johan · Accepted Answer · 2011-05-08 20:48:52Z

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.

answered May 8, 2011 at 20:48

Johan

77.4k28 gold badges204 silver badges346 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

qliq Over a year ago

Thanks Johan for the links, actually I skimmed over some of them but what but I'd like to see is some first hand experience focusing on Drupal.

Johan Over a year ago

@qliq, I only found a 2004 link on drupal, not very relevant to 2011 MySQL I'm afraid.

David Chan · Accepted Answer · 2011-05-16 17:07:02Z

1

I've used this tool to successfully dump a mysql db to a postgres import file.

http://sqlfairy.sourceforge.net/

answered May 16, 2011 at 17:07

David Chan

7,5352 gold badges30 silver badges50 bronze badges

Comments

Morg. · Accepted Answer · 2011-09-23 12:30:43Z

1

What are the pros/cons of using postgresql instead of mysql?

The PostgreSQL Optimizer is much better, much better datatype support, faster for anything advanced like triggers/ etc. , really ACID compliant (not like InnoDB which is a fake), triggers on views, good GIS support, lots of advanced stuff and much much more

Is the conversion worth the effort?

No, Drupal is not about advanced SQL and you should not see much improvement switching from MySQL to PostgreSQL, and as already mentioned you would lose some compatibility (i.e. everyone uses mysql for drupal more or less).

answered Sep 23, 2011 at 12:30

Morg.

7115 silver badges7 bronze badges

Collectives™ on Stack Overflow

Converting drupal database from mysql to postgresql?

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related