Tell me more ×
Drupal Answers is a question and answer site for Drupal developers and administrators. It's 100% free, no registration required.
up vote 7 down vote favorite
2

I need to know how to migrate my Drupal 6 database from MySQL to PostgreSQL. I also like to hear first hand experience tales about actual migrations.

P.S. I found this drupal-mysql2pgsql.pl migration script which apparently does the job but I could not make use of it due to the fact that I dont' know how to make " passwordless account in both databases". There is also this guide (in Thai) which adds credentials to database connection lines in the script. But it did not help either, as I could not connect to Postgresql. I know very little about Postgresql and may have had some silly mistake. Any through explanation/tutorial on this would be much appreciated.

share|improve this question

4 Answers

up vote 3 down vote

Module DBTNG Migrator will do it.

share|improve this answer
2  
The module is for Drupal 7. – kiamlaluno♦ Aug 19 '11 at 12:12
up vote 3 down vote

I have an experience with both postgres and mysql sites under high load, and I don't think migration can be done for performance reasons. Both engines are good, and final success depends on ability of your DB admins to tune up DB installation for specific site. Another point: to boost performance, you choose tools to minimize need in DB queries (boost/memcache/varnish), so you end up with relatively low weight of DB processing.

share|improve this answer
up vote 2 down vote

If you're using Drupal 7, there's a sandbox project called Portable Databse Dump that purports to allow you to dump a Drupal site from one database backend to another.

share|improve this answer
Unfortunately I'm using Drupal 6. – alfish Jun 15 '11 at 18:47
up vote 1 down vote

Check all of the modules that you use or ever may want to use on your site. Not all contrib modules are database agnostic. I can't think of any off the top of my head, but I have run into modules that use MySQL-only functions.

share|improve this answer
Do you think the effort to migrate to Postgresql worth at all? – alfish Jun 15 '11 at 18:48
I don't consider the risk of a module not working with PostgreSQL worth taking when working on projects for a client. – MPD♦ Jun 15 '11 at 20:00
Assuming that all modules work in Postgresql, will you suggest the migration, performance-wise? – alfish Jun 15 '11 at 20:45
Because of this complication, we don't deploy it, so I don't have real-world metrics to compare to. – MPD♦ Jun 16 '11 at 13:47

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.