MySQL->PostgreSQL Database migration strategy suggestions

planar1 · Post by **planar1** » Sat Apr 02, 2005 5:15 am

Greetings Thorsten and fellow users,

Looking for a FAQ engine that is easy to use and feature rich, Thorsten's phpMyFAQ popped on my radar screen today and I like what I see so far. Good thing I did not jump the gun installing faq-a-matic

My question has to do with the database choice. I have a strong affinity with PostgreSQL and have pretty much standardized on it on all my Linux systems.

I see official PostgreSQL support is coming in 1.5.x, which is RC3 at the moment. Current 1.4.x is MySQL only. I want to use only a stable release for this serious purpose - so my question is:

Can I get going with phpMyFAQ 1.4 and MySQL and when 1.5 is released, migrate to PostgreSQL? I noticed a datbase backup/restore feature but I do not know if it will work across different SQL databases. I was excited to see an XML export - but did not see a corresponding XML import. Please let me know what you think...

Best,

Planar1

Post by **Thorsten** » Sat Apr 02, 2005 12:57 pm

Hi,

the backu/restore with different databases won't work. If you want to use PostgreSQL, you should wait for the final release of version 1.5. The current RC3 is quite stable and I hope to release RC4 as last RC next weekend.

bye
Thorsten

planar1 · Post by **planar1** » Sat Apr 02, 2005 8:39 pm

Thorsten,

This sounds encouraging. However, when I originally tried installing RC3 on my test machine, the installation screen's "Database" dropdown menu did not even give "Postgresql" as a choice, although it is running with the database ready and all. I only get the "MySQL" in the dropdown...

I had no problems installing on MySQL but PostgreSQL is what I need.
I am using Fedora Core 3, PHP 4.3.10 and PostgreSQL 7.4.7

Thanks

Post by **Thorsten** » Sun Apr 03, 2005 3:28 pm

Hi,

it seems your PostgreSQL extension isn't loaded. The installer checks the available extensions in PHP.

bye
Thorsten