Filed under: Projects · Date: Thu Feb 28 21:19:00 2008
This is an updated version of Kord Campbell's patch for enabling PostgreSQL support in Vanilla 1.0.1. It's been fixed to work with the latest version (1.1.4). The download is a patch file.
Here's a command line listing for your convenience. It's assumed that the Vanilla forum is in the folder called 'vanilla'.
$ wget 'http://jmz.iki.fi/pub/vanilla-1.1.4-postgresql.patch.bz2' $ bunzip2 vanilla-1.1.4-postgresql.patch.bz2 $ cd vanilla $ patch -p1 < ../vanilla-1.1.4-postgresql.patch
The patch must be applied prior to installing the forum. There is no way to upgrade an existing MySQL forum to PostgreSQL. Do create the PostgreSQL database for Vanilla with the -E UNICODE -switch.
By default, PostgreSQL is case-insensitive with regards to handling table and attribute names. Vanilla is programmed case-sensitive, so whenever you need to work directly with the database, allways add double quotes around attribute names and use proper capitalization.
The patched version of the forum has had only minimal testing.
I created the patch by first applying the 1.0 patch to 1.0, and then upgrading to 1.1.4 and fixing issues as I encountered them. There are still some issues left. That’s why I haven’t made any official announcement about this patch yet.
I’m currently working on improving the patch, and expect to deliver a better version in two days.
The patch has been updated.
Works like a charm! Thank You!
hello! does anybody know if this is gonna work with the 1.1.5 version of Vanilla? Thanks!!
Any response for patch with 1.1.5 version of Vanilla ?
thanks.
I guess you’ll have to test the patch yourself. I’m not going to upgrade my current Vanilla installations any time soon.
If the patch does not work, you can always checkout 1.4 version from Vanilla SVN repository. Be sure to update the external repositories to the correct version too, by default latest version is used for them. Then apply the patch as normal. If everything goes fine, update the sources with svn update. Any conflicts need to be resolved, of course.
| Version: | 1.1.4 |
|---|---|
| Download: | vanilla-1...patch.bz2 |
| Size: | 23.58 KB |
| Checksum: | 362195c510e 502f0c5e953 34d63ea5d0 |
Articles and code to help porting MySQL software to PostgreSQL.
Thanks for your patch. I get an error on the install because of no quotes around column names. In the 1.0 patch I see the SqlBuilder class GetInsert method is adding the quotes but this patch doesn’t seem to provide the changes in that area. If I install that patch it overlays some changes for the 1.1.4 version. Am I missing some instructions or another patch or is this something not yet done?