Mantis with Postgres

jmax · Post by **jmax** » 30 Mar 2005, 12:05

I have made some adaptations to mantis last version in order to work with Postgres 8.0. It run fine. Anyone interested ?

thraxisp · Post by **thraxisp** » 30 Mar 2005, 12:47

Sure. Please post them to the issue tracker (http://bugs.mantisbt.org/) and we will look at integrating them.

filip · Post by **filip** » 11 Apr 2005, 10:37

Thanks jmax for your work!!!

Has this been integrated? I would be very interested in testing mantis on Postgresql (will it also run against version 7.4?) as I'm trying to move away from mysql.

Jason · Post by **Jason** » 04 Jul 2005, 07:59

where can I get this mod? is this now part of Mantis?
I dont like mysql, I'm already running postgres and I also really like Mantis when I have used it in the past. so If theres a postgres option I will definitely use it.

Post by **vboctor** » 24 Jul 2005, 14:02

I would recommend for PostgreSQL users to test using Mantis 1.0.0rc1.

Regards,
Victor
MantisConnect
http://www.futureware.biz/mantisconnect/

filip · Post by **filip** » 09 Aug 2005, 10:33

I've just migrated my mantis installion (was still 0.18.3) from MySQL to version 1.0.0.rc1 on PostgreSQL 7.4.8.

Everything seems to run perfect.

It was slightly tricky to migrate the old data (used import/export to csv files for this) but had trouble with the uploaded files in the database.

Apart from that, everything went fine. (it might be usefull to have a migration script that is able to migrate the information over from mysql to postgresql automatically during an upgrade).

Thanks again for making mantis run on PostgreSQL (I'm moving everything to Postgresql and was very keen to stay with mantis...)

~ Filip

Post by **vboctor** » 09 Aug 2005, 12:14

I published a post on my blog regarding the fact that Mantis 1.0.0rc1 is working with PostgreSQL.

http://www.futureware.biz/blog/index.ph ... =1#more132

Regards,
Victor
Subscribe to Mantis blog
http://www.futureware.biz/

Narcissus · Post by **Narcissus** » 09 Aug 2005, 21:21

Regarding copying from one database to another: I once wrote a little web interface that used ADODB to do just this.

It would connect to the source DB, work out the schema (as far as I know: for me, ADODB is still a bit of a black-art :) ) then start copying chunks of the data to another database that has the same schema. I had plans to make it generate the schema itself, but kinda got bored with it...

It did do some cool things like trying to copy chunks but reverting to single lines for a while if the DB server couldn't handle the size of that chunk and so on. Plus, it would draw pretty tables :)

If anyone is interested in this tool I'd be more than happy to stick it up, though I'd really need someone to test it, as I only ever tested MySQL -> MySQL (admittedly on different servers, with ADODB so in theory it should be fine, right?)

vboctor: would you see a use for this in the main admin section?

PatPowerMan · Post by **PatPowerMan** » 22 Mar 2006, 22:00

Could I use your web interface to export everything from the database to a csv-file? Or even better: Export a whole single project?

I desperately looking for a export-all-to-csv-solution - but it really has to to be a csv, not a mysql-database-dump... :(

Narcissus · Post by **Narcissus** » 23 Mar 2006, 00:14

You definitely wouldn't be able to export a single project: the code has no concept of what Mantis is... it's just a database exporter.

In theory you could change the code so that instead of inserting in to the database, you dump to a CSV file, yes.

Give me a few days then hit this thread again if you're interested. Firstly, I need to find the code and then secondly, I need to tidy up my site before I can find a place to put it for you!