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


 
You may request notification for Postgresql support status?.
Search: 

1: Postgresql support status?
08/25/08 06:26 PM
[ Reply | Forward ]
What's the status on support for postgresql? I don't see any recent posts about it.

Posted by Jonathan Meyers

2: Re: Postgresql support status?
In response to 1 08/25/08 06:31 PM
[ Reply | Forward ]
Hi Jonathan,

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

3: Re: Re: Postgresql support status?
In response to 2 09/02/09 10:33 AM
[ Reply | Forward ]
hi Ernie again

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

4: Re: Re: Re: Postgresql support status?
In response to 3 09/03/09 01:02 AM
[ Reply | Forward ]
Hi Marco,

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

Reply to first post on this page
Back to LAMS for Tech-Heads - General Forum