[opencms-dev] Opencms under PostgreSQL : done & howto

[Joachim Arrasz]

Hello Emanuel,

it would be very very nice, if you`re able to write a tutorial for this on

opencms-forum.de

So all people can find it with google very easily! Are you able to do that?

Kind Regards

Joachim Arrasz

Synyx oHG, Karlsruhe Germany

-- 
Questions about OpenCMS?
--> www.opencms-forum.de


> Emmanuel>
> Hello,
> We are curently running OpenCMS 5.0.0 under PostgreSQL 7.3.4-9 (Linux
> OS). Our driver : pg74.1jdbc3.jar
>
> For the moment, the database creation process is not done.
> So, I joined a script allowing to create all the opencms tables
> (postgresql.sql)
>
> To begin with, I modified the com.opencms.boot.dbsetup.properties to
> integrate the postgresql support.
>
> Next, I modified the com.opencms.file.genericsql.query.properties (yes
> it is not very proper ..  but I didn't have time)
>
> To end with, I added com.opencms.file.postgresql directory.
>
> Just recompile your project with all those added files.
>
> Next, configure your opencms.properties file (with your driver, your
> jdbc connection, password...)
>
> Launch the ocsetup process, do not choose to create the database and
> launch the workplace import process. Opencms should work under
> postgresql  :o))))
>
>
> Emmanuel LORICH
> France
>
>
>
> ---------------------------------
> Yahoo! Mail : votre e-mail personnel et gratuit qui vous suit partout !
> Créez votre Yahoo! Mail