Postgresql

[kurtkbee]

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 it has come a long way since 3.x.x or 4.0.x) and i would prefer to use postgres 8.2 as my DB of choice.

Anyone out there doing this, and are there any problems i should be aware of (a.k.a "don't do it because everything fails to work after" sort of thing)

TIA,

-Kurt

[frederick]

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.

[dbaran]

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

[kurtkbee]

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

[kurtkbee]

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.