topic Re: Postgresql in Alfresco Archive

Postgresql

kurtkbee — Mon, 23 Apr 2007 21:27:52 GMT

Hello All,I recently installed Alfresco from SVN and after completing this immediately thought of ways to make this painless experience ……well how do i put this…PAINFUL :twisted: .Therefore i intend to strip out the default DB and use Postgresql. I have never really been a fan of Mysql (i am sure i

Re: Postgresql

frederick — Tue, 24 Apr 2007 07:02:10 GMT

Unfortunately, switching to another Hibernate-compatible DB in Alfresco isn't painful at all :wink:

You'll need to edit the following files:

custom-db-connection.properties
custom-hibernate-dialect.properties

which are located in your extension folder.

Alfresco only needs to find a user account and an empty schema in order to bootstrap itself (by default user 'alfresco' identified by 'alfresco' with access to schema 'alfresco').

Here at J&J, we used Alfresco on MySQL, HSQL, PostgreSQL and Oracle with little difficulty.

Re: Postgresql

dbaran — Tue, 24 Apr 2007 07:13:34 GMT

Hello,

We use Alfresco on PostgreSQL without problem. To configure database connection, just follow information provided in Wiki:

Repository configuration

Specific information about Oracle and PostgreSQL database configuration

Re: Postgresql

kurtkbee — Tue, 24 Apr 2007 14:19:51 GMT

Thanks so much for the response guys. i will configure this now.

Re: Postgresql

kurtkbee — Thu, 26 Apr 2007 12:49:40 GMT

Hello,

We use Alfresco on PostgreSQL without problem. To configure database connection, just follow information provided in Wiki:
Repository configuration
Specific information about Oracle and PostgreSQL database configuration

Thanks guys, this works so well.