By mcking on

Has anyone out there had any experience migrating a drupal install from mysql to postgresql? I am in the process of doing this and I wonder if anyone had any tips/hints to ease the process.

I am only going to migrate content, as I want to re-do my taxonomy and other settings. I don't have a lot of content to migrate (only about a 100 blog posts and a few static pages), but it is a little too many to migrate by hand.

Both the old and new sites run drupal 4.3.2 and the db's are mysql-4.0.13 on Gentoo Linux and postgresql-7.3.2 on OpenBSD.

Comments

mcking’s picture

mcking commented

I have imported all of my old content into postgresql and I must say it was pretty easy. I simply took the 'INSERT INTO node' statements from the mysql dump and put them into a file that I imported into postgresql.

The only problem that I have now is that when I try to give the static pages a 'link name' and 'link description' to add them into the menu bar at the top, the form is accepted just fine, but the link nam is not created. When I edit the post again, the link name and description fields are empty, as if I never put anything in them. I had to go in by hand and create the rows in the page table.

dries’s picture

dries commented

Were the link names and descriptions saved in the page table along with the proper nid? If not, did page_insert() or page_update() get called? Any errors in your watchdog (administer > messages > errors)?

mcking’s picture

mcking commented

I had to go back and create the entries in the page table by hand. No biggie, since there were only 4 of them.

I'm now having a problem with the book module. I tries to create a new page with nid == 3, but that nid is taken. I need to update the node_nid_seq (postgres' autoincrement) to reflect the new last_value.