nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

PostgreSQL Database Support Scripts Now Available for 3.2

nancyg

Hello -

The PostgreSQL Database Support Scripts Now Available for 3.2, you can find them in the extensions area of this page, http://wiki.alfresco.com/wiki/Community_Edition_file_list. Sorry for the delay getting these out.

Nancy

Find more posts tagged with

Comments

wilayers

Hi,
The PostgreSQL scripts are outdated now. In the last version, the databases are differents.

An update is planned?

Thanks
Will

dward

There should be no differences and any differences you are aware of should be logged in JIRA.

wilayers

Where can I find the module that corresponds to the latest version?

I downloaded this module : https://issues.alfresco.com/jira/browse/ALFCOM-3280 to test with the lastest release (downloaded here : http://dev.alfresco.com/downloads/nightly/dist/) but this doesn't work…

Not is the same version but I have not found a postgresql module for 3.2, which works

dward

I'm sorry. I have got clarification on this from the experts on this and it seems that MySQL is the primary platform for HEAD and porting to Postgres is only done to coincide with released versions. So I'm afraid you cannot expect continuous updates of the Postgres scripts on HEAD.

pim

Did anyone test the new 3.2r release in combination with Postgres?

The original 3.2 version was working fine with the Postgres AMP.

But when I installed the 3.2r release and the 3.2r amp, the sqlMap error below (*) appeared as if the AMP was not present.
I checked, and a directory /tomcat/webapps/alfresco/WEB-INF/classes/alfresco/ibatis/org.hibernate.dialect.PostgreSQLDialect was created, containing 3 items.
- activities-insert-SqlMap.xml
- content-insert-SqlMap.xml and
- locks-insert-SqlMap.xml

(*) com.ibatis.sqlmap.client.SqlMapException: The <sqlMap> resource is missing: alfresco/ibatis/#resource.dialect#/content-insert-SqlMap.xml

paulweb

I have looked postgresSQL and I wish to tell the following
1. Works with alfresco 3.2 old
2. Does not work with alfresco 3.2 (from svn July-September)
3. Does not work with alfresco 3.2r

My version alfresco I took from svn. Last time I updated it in September.
For this version I have made amp oracle-alfresco3.2-community.amp. Now alfresco works with oracle. By the way, old version 3.2 the same works with oracle thanking achied. view this http://forge.alfresco.com/projects/oracle/
Yesterday I have downloaded 3.2r and have made new amp. On days off we will test it and the next weeks we will publish release for alfresco 3.2r.

alfresco database is simple: only tables and for oracle sequence.
For postgres you should rewrite ibatis and dbscripts. Look as we have made it.
In 3.2r new tables for avm and which that else have been added.

gyro_gearless

I'm sorry. I have got clarification on this from the experts on this and it seems that MySQL is the primary platform for HEAD and porting to Postgres is only done to coincide with released versions. So I'm afraid you cannot expect continuous updates of the Postgres scripts on HEAD.

Hi folks,

I think a clear statement from Alfresco regarding the continued support for Postgres is urgently needed! From the ongoing discussion i conclude that Postgres support in 3.2 is only halfhearted, which is IMHO worse than dropping suppoert at all!
The current situation generates a lot of questioning if Alfresco will support Postgres in 3.2x, 3.3, 4.0, whatever - and i hate to think about migrating my systems from Postgres to MySQL if i can avoid that.
And <troll-mode> did I say that would be a very unfortunate choice, IMHO? Dropping support for the superior database of 'em?</troll-mode>

Sorry for the ranting from a die-hard Postgresql lunatic 🙂

Cheers
Gyro

resplin

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.