Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved Is it possible to switch from MySQL to PostgreSQL?
#1
Not Solved
Would it be possible to take a MyBB install on MySQL and switch over to PostgreSQL later on? What's the migration process like for anyone whose done this?
Software Engineer specializing in Crystal Program Development

Reply
#2
Not Solved
There is no issue to switch over to PostgreSQL database engine.
The migration process only needs an export of the current database and the re-import to PostgreSQL. After that make the change to the config file and set the new database type:

./inc/config.php
$config['database']['type'] = 'postgresql';

Be carefull with database encoding (Latin, Unicode, UTF etc.) while exporting and importing.
When you're using UTF-8 at all, there should be no mismatch.

Further ensure the pgsql PHP module is enabled.

[ExiTuS]
Reply
#3
Not Solved
I've had some success importing a database from MySQL into Postgres using pgloader before, but I did have to do some manual work afterwards. I've not tried it on a MyBB database before, but we don't use any particularly fancy features so it should work fairly well.
Reply
#4
Not Solved
Take care if you're using plugins: most of them (mines first) are developed only for MySQL and some queries can make errors
[MyBB 1.8 mods] - Offer me a coffee
Do not ask me help through PM
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)