Forum LAMS for Tech-Heads - General Forum: Postgresql support status?

It has been done already, see this task in the LAMS Bug Tracker:

http://bugs.lamsfoundation.org/browse/LDEV-1103

Although I haven't test this in production though. If you do, please let us know.

Thanks,

Ernie

Posted by Ernie Ghiglione

i see this script is do dump the database and convert it to mysql

then restore it on postgres

and what i need to change on lams ?

is enough to change on the source code before deploy
the common.properties

the lines database related?

#database access
db.name=${conf.application}
db.driver=com.mysql.jdbc.Driver
....



can deploy directly to a server with postgres... i see on the forum that some one already did "Postgresql support"
so probably is working on lams2 currently

thanks
Marco

Posted by Marco Ramos

I haven't actually tried with Postgres in a very very long time.

The file I remember changing was the mysql-ds.xml file. Look in the lams_buid/conf/{unix or windows}/mysql-ds.xml.

Also, make sure you include the postgres driver.

Thanks,

Ernie

Posted by Ernie Ghiglione