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.

Alfresco with PostgreSQL in production environment

udayakumar_p

Hi,
Can anyone tell me is there any disadvantage of using alfresco with postgresql(inbuilt into alfresco) in a production environment? Is there any size limitation of using it?

Sometimes even in local we faced CmisContentStorageException. Is this attributed to using postregresql?

Is it better to go with MySQL in production?

Please clarify.

Find more posts tagged with

Comments

mrogers

Postgresql is a valid choice for a production database.

There will be some size limitations (just with every database or piece of software) however you are unlikely to get anywhere near them.

In general go with whatever database your DBAs are most comfortable with.

jiro

Hello, I want to deploy Alfresco on my production environment with PostgreSQL. What are size limitations ? Alfresco with Postgresql DB of ~2TB should be working without aby problem ? Are they any 'things' should I care about deploying such a big database ?