Expand my Community achievements bar.

Learn about Edge Delivery Services in upcoming GEM session
SOLVED

PostgreSQL with AEM

Avatar

Level 2

Hi,

 

Is it recommended to use a PostgreSQL database with AEM? We are using AEM cloud.

In one of the community posts, it is mentioned that PostgreSQL is provided only for demo purposes. It will not be available for production environments.

 

Please let me know if it is a recommended database or not. If not, please let me know the limitations.

 

Thanks,

Divya

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Although PostgreSQL is not supported in AEM 6.5 and above, as mentioned in https://experienceleague.adobe.com/docs/experience-manager-65/deploying/deploying/rdbms-support-in-a....

But you can still check with Adobe Support Team if this is true for AEM as Cloud.

 

For a list of supported databases, check https://experienceleague.adobe.com/docs/experience-manager-65/deploying/introduction/technical-requi... here.

 

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Although PostgreSQL is not supported in AEM 6.5 and above, as mentioned in https://experienceleague.adobe.com/docs/experience-manager-65/deploying/deploying/rdbms-support-in-a....

But you can still check with Adobe Support Team if this is true for AEM as Cloud.

 

For a list of supported databases, check https://experienceleague.adobe.com/docs/experience-manager-65/deploying/introduction/technical-requi... here.

 

Avatar

Level 2

We've checked with Adobe Support team and below is their response for "Is it recommended to use a PostgreSQL database with AEM? We are using AaaCS. In one of the community posts, it is mentioned that PostgreSQL is provided only for demo purposes. It will not be available for production environments. Please let us know if it is a recommended database or not. If not, please let us know the limitations and also, let us know the recommended RDBMS(MySQL,Microsoft SQL) to use with AaaCS.We have a requirement to retrieve data from an external database to display in our page. Do you have any recommended databases(MySQL,MSSQL) to use with AEMaaCS?".

 

1.There is no choice on persistence setup in AEMaaCS and in addition Adobe never supported RDBMS based persistence - those are only proof of concept solutions that are not production ready and don‘t satisfy our operational requirements for productive environments
2.If you have a requirement to retrieve data from an external database to display on your page then the best approach is to expose those data as APIs. You can expose them as REST APIs which can be consumed with AEM backend java or frontend script (js, angular, react) code based on needs.