PostgreSQL in 1.x?

[gerb42]

Just did a search for db_postgresql issues in the bug tracker. There are still several open items. Are there plans to fix these in the near future? We have a 1.0.6 running smoothly on PostgreSQL 8.1 but we'd like to switch to a more recent version which seems to be a no-go at the moment.

thx
gb

[smig1o]

I use Mantis 1.1.1 with PostgreSQL 8.2 without problems....

[gerb42]

No comments on this from the developers?

@smig: Did you install Mantis from scratch or did you upgrade from a previous version? We have a non-English 1.0.6 with some tweaks, so we will have to be very careful during upgrade anyway, and I do not like to be bitten by something like database incompatibilities.

[smig1o]

I live with Mantis from ver 1.0.5 or so. Doing upgrade and I had no problems with that.
I alo have modified sources. I made a patch and I was applying it after every upgrade.
Of coure I always did db backup and some tests on local db (local db made from main db backup) before applying it to main db.

Change from 1.1.X to 1.2x will be much more difficult.. but thats the future..

[zariok]

I use Mantis 1.1.1 with PostgreSQL 8.2 without problems....

Did you upgrade from a 1.0.7 series? You mentioned a patch, is this associated with a bugid on the mantis bugtracker?

The default install of 1.1.1 succeeds, but I get "Issue ### not found" for individual items selected.

I get the same results for the following environments:

(development v1.0.7 - > v1.1.1)
PHP v5.2.4
PostgreSQL v8.2.7

(production v1.0.7)
PHP v5.0.4
PostgreSQL v8.0.3


Is there a particular upgrade path I need to take to get to v1.1.1?

Example: v1.0.7 -> 1.0.8 -> v1.1.0 -> v1.1.1 ??

[smig1o]

I use Mantis 1.1.1 with PostgreSQL 8.2 without problems....

Did you upgrade from a 1.0.7 series? You mentioned a patch, is this associated with a bugid on the mantis bugtracker?

The default install of 1.1.1 succeeds, but I get "Issue ### not found" for individual items selected.

I get the same results for the following environments:

(development v1.0.7 - > v1.1.1)
PHP v5.2.4
PostgreSQL v8.2.7

(production v1.0.7)
PHP v5.0.4
PostgreSQL v8.0.3


Is there a particular upgrade path I need to take to get to v1.1.1?

Example: v1.0.7 -> 1.0.8 -> v1.1.0 -> v1.1.1 ??

Hmm..
@ patch
I've added new bug status and written mail notification for it. To make life easier I made a patch with this changes and use it every time I upgrade mants. This patch also contains my config file so I have almost nothing to do when upgrading.

@ upgrading
My way of upgrading:
1. Get the sources
2. backup db
3. Run new_mantis/admin/install.php (or so)
3. upgrade db schema
4. be happy....
My path of upgrading was 1.0.5 -> 1.0.6 -> 1.0.7-> ... -> 1.1.1
But, according to my knowledge, there should be no problem with
1.0.7 -> 1.1.1