Though I recently started working for Alfresco, i haven't spoken with anyone involved with the database support and i cannot give an official opinion. However, I have successfully run Alfresco 3.2 Enterprise, 3.2r Enterprise, and 3.3 Community against PostgreSQL. I didn't install any AMP, I just put these settings in alfresco-global.properties:
<start snip>
#
# Sample database connection properties
#————-
db.name=<db_name>
db.username=<user_name>
db.password=<password>
db.host=localhost
db.port=5432
#
# PostgreSQL connection (requires postgresql-8.2-504.jdbc3.jar or equivalent)
#
db.driver=org.postgresql.Driver
db.url=jdbc
ostgresql://${db.host}:${db.port}/${db.name}
hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
hibernate.query.substitutions=true TRUE, false FALSE
</snip>
Of course I also had to comment out the MySQL stuff and copy postgresql-jdbc3-8.2.jar to tomcat/lib. When I startup Alfresco it detects the PostgreSQL dialect, loads the talbes, and runs without errors.
I usually run Ubuntu Linux.
Hopefully this helps people get unstuck.
<start snip>
#
# Sample database connection properties
#————-
db.name=<db_name>
db.username=<user_name>
db.password=<password>
db.host=localhost
db.port=5432
#
# PostgreSQL connection (requires postgresql-8.2-504.jdbc3.jar or equivalent)
#
db.driver=org.postgresql.Driver
db.url=jdbc
ostgresql://${db.host}:${db.port}/${db.name}hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
hibernate.query.substitutions=true TRUE, false FALSE
</snip>
Of course I also had to comment out the MySQL stuff and copy postgresql-jdbc3-8.2.jar to tomcat/lib. When I startup Alfresco it detects the PostgreSQL dialect, loads the talbes, and runs without errors.
I usually run Ubuntu Linux.
Hopefully this helps people get unstuck.
