Postgresql

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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 

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.