Advertisement:

Author Topic: Migration to postgres?  (Read 14406 times)

Offline dbodner

  • Newbie
  • *
  • Posts: 5
Migration to postgres?
« on: January 01, 2009, 11:47:46 AM »
I have an sms 1.1X line forum running off of mysql.  My site uses postgres as a backend, and I would like to convert the forum to postgres as I'm looking to convert everything off of mysql.  Is there any tool to help accomplish this?  I think I can get the 1.1 forum updated to 2.0 beta, but I don't see anything to help in the transition from mysql to postgres.

Thanks.

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 16,431
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Migration to postgres?
« Reply #1 on: January 01, 2009, 01:29:00 PM »
There is no tool currently made to transfer from mysql to postgres.

At this time only installing for SMF 2.0 to postgres is supported.
Community Suite - Take your forum to the next level built for SMF, Gallery,Store,Classfieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Latest Mod:
EzPortal - Portal System for SMF
Newsletter Pro SMF Gallery Pro SMF Classifieds SMF Store

Offline nbviv

  • Semi-Newbie
  • *
  • Posts: 10
Re: Migration to postgres?
« Reply #2 on: May 23, 2010, 01:13:46 AM »
bumping this because I'm in the same boat. I'm wanting to move everything off of mysql. I'm currently running 2.0rc3 off of mysql, and am wanting to transfer everything over to postgres. Are there any tools for this yet?

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 16,431
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Migration to postgres?
« Reply #3 on: May 23, 2010, 09:06:11 AM »
No tools have been made for this.
Community Suite - Take your forum to the next level built for SMF, Gallery,Store,Classfieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Latest Mod:
EzPortal - Portal System for SMF
Newsletter Pro SMF Gallery Pro SMF Classifieds SMF Store

Offline Royalduke

  • SMF Hero
  • ******
  • Posts: 4,732
  • Gender: Male
    • 3dTechForum
Re: Migration to postgres?
« Reply #4 on: May 23, 2010, 09:31:46 AM »
Any reason why you want to convert?
Do you need help with your SMF forum? Contact me through PM for a free estimate. I have over 6 years experience with SMF, backed by positive reviews and recommendations

Offline nbviv

  • Semi-Newbie
  • *
  • Posts: 10
Re: Migration to postgres?
« Reply #5 on: May 23, 2010, 11:32:45 AM »
Any reason why you want to convert?
for me it's because my VPS has very little resources, so I don't want to have to run two different database engines. Since one of the 4 or so apps I run requires postgres, it makes sense to move everything over to postgres if possible.

If that one app could work in mysql, i'd switch everything over to that though. mysql has better administration/optimization tools, imo.

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,314
  • Blue Wolf
Re: Migration to postgres?
« Reply #6 on: May 23, 2010, 11:34:39 AM »
I am adding this script to our todo list, but to be honest I have no clue at the moment, when we can possibly take the time for it. We will consider such conversion tools in the future, though.

For the time being, you might want to take a look at various conversion tools between mysql and postgres, like:
http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL
Please note however, that I don't know how good they are (this is not a recommendation, I'm afraid).
In case you want to try, it would be best to try on local installations, not online.

In case they are helpful enough to import the database, at the very least you should also run the upgrade script (for postgres) to your SMF version after trying to import the database in Postgres. (meaning you need to upload the files upgrade.php and upgrade sql for postgres from a large upgrade package, and run the upgrade.php). it should, among other things, try to add the necessary functions in Postgres that are needed by SMF's queries.
To-do lists are for deferral. The more things you write down the later they're doneā€¦ until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline nbviv

  • Semi-Newbie
  • *
  • Posts: 10
Re: Migration to postgres?
« Reply #7 on: May 23, 2010, 11:50:50 AM »
I think the best solution to this problem is to do what mediawiki does (and I'm sure a few other projects); have a way for site owners to export their data into an XML format. Then have a way to import data from said XML. That way you can backup your data in a more user friendly and database backend agnostic way. A nice side effect of this is a way to easily migrate between database engines.