Connectivity of postgres DB with AEM

[sahilg75191328]

Hi Team,

We are trying to create the connectivity between AEM and postgres sql.

I am following the below documentation and stuck with below error can someone help me out.

Error Logs:-

20.06.2019 17:29:14.382 *INFO* [CM Event Dispatcher (Fire ConfigurationEvent: pid=com.day.commons.datasource.jdbcpool.JdbcPoolService)] day.commons.datasource.jdbcpool deactivating data source with name=datasourcename

20.06.2019 17:29:14.385 *INFO* [CM Event Dispatcher (Fire ConfigurationEvent: pid=com.day.commons.datasource.jdbcpool.JdbcPoolService)] day.commons.datasource.jdbcpool Service [8173, [javax.sql.DataSource]] ServiceEvent UNREGISTERING

20.06.2019 17:29:14.388 *INFO* [CM Event Dispatcher (Fire ConfigurationEvent: pid=com.day.commons.datasource.jdbcpool.JdbcPoolService)] day.commons.datasource.jdbcpool Service [com.day.commons.datasource.jdbcpool.JdbcPoolService,8172, [com.day.commons.datasource.poolservice.DataSourcePoolProvider]] ServiceEvent UNREGISTERING

20.06.2019 17:29:14.390 *INFO* [CM Event Dispatcher (Fire ConfigurationEvent: pid=com.day.commons.datasource.jdbcpool.JdbcPoolService)] day.commons.datasource.jdbcpool Configuring and activating data source with name=datasourcename

20.06.2019 17:29:14.390 *INFO* [CM Event Dispatcher (Fire ConfigurationEvent: pid=com.day.commons.datasource.jdbcpool.JdbcPoolService)] day.commons.datasource.jdbcpool Datasource configured, name=datasourcename, connectionURI=xya_url, default readonly=false, default autocommit=true, validation query=null

20.06.2019 17:29:14.392 *INFO* [CM Event Dispatcher (Fire ConfigurationEvent: pid=com.day.commons.datasource.jdbcpool.JdbcPoolService)] day.commons.datasource.jdbcpool Service [8175, [javax.sql.DataSource]] ServiceEvent REGISTERED

20.06.2019 17:29:14.394 *INFO* [CM Event Dispatcher (Fire ConfigurationEvent: pid=com.day.commons.datasource.jdbcpool.JdbcPoolService)] day.commons.datasource.jdbcpool Service [com.day.commons.datasource.jdbcpool.JdbcPoolService,8174, [com.day.commons.datasource.poolservice.DataSourcePoolProvider]] ServiceEvent REGISTERED

20.06.2019 17:29:48.560 *INFO* [sling-threadpool-d9f18639-77ad-4d0a-855f-365d54c37495-(apache-sling-job-thread-pool)-160-com_day_cq_replication_job_publish(com/day/cq/replication/job/publish)] com.day.cq.replication.Agent.publish.queue Processing job for agent publish

20.06.2019 17:29:48.560 *INFO* [sling-threadpool-d9f18639-77ad-4d0a-855f-365d54c37495-(apache-sling-job-thread-pool)-160-com_day_cq_replication_job_publish(com/day/cq/replication/job/publish)] com.day.cq.replication.Agent.publish Create new HttpClient for Default Agent

20.06.2019 17:29:48.561 *INFO* [sling-threadpool-d9f18639-77ad-4d0a-855f-365d54c37495-(apache-sling-job-thread-pool)-160-com_day_cq_replication_job_publish(com/day/cq/replication/job/publish)] com.day.cq.replication.Agent.publish * Auth User: admin

20.06.2019 17:29:48.561 *INFO* [sling-threadpool-d9f18639-77ad-4d0a-855f-365d54c37495-(apache-sling-job-thread-pool)-160-com_day_cq_replication_job_publish(com/day/cq/replication/job/publish)] com.day.cq.replication.Agent.publish * HTTP Version: 1.1

20.06.2019 17:29:48.562 *INFO* [sling-threadpool-d9f18639-77ad-4d0a-855f-365d54c37495-(apache-sling-job-thread-pool)-160-com_day_cq_replication_job_publish(com/day/cq/replication/job/publish)] com.day.cq.replication.Agent.publish Sending POST request to http://localhost:4503/bin/receive?sling:authRequestLogin=1

20.06.2019 17:29:49.568 *ERROR* [sling-threadpool-d9f18639-77ad-4d0a-855f-365d54c37495-(apache-sling-job-thread-pool)-160-com_day_cq_replication_job_publish(com/day/cq/replication/job/publish)] com.day.cq.replication.Agent.publish Error while sending request: java.net.ConnectException: Connection refused: connect

Thanks in advance.

[hamidk92094312]

Please note that support for PostgreSQL is provided only for demo purposes. It will not be available for production environments. you may want to use one of the RDBMS that is officially supported:

RDBMS Support in AEM 6.4

[Divya_13]

Hi Hamid,

We have similar requirement of fetching data from PostgreSQL and we are using AaCS. Is it recommended to use AEM+PostgreSQL?

Thanks,

Divya

[Jörg_Hoh]

What do you want to do with postgresql? If you want to store your repository in there, please see Hamid's response.

The error you see is totally unrelated to JDBC or postgresql. It's just saying that your AEM instance tries to replicate data (caused by whatever reason) and the publish instance is not reachable.

Jörg

[sahilg75191328]

Hi Joerg,

I can understand this error is related to replication but whenever i am trying to connect with database it is trying to replicate something due to which connection is refusing.

Our Use Case:-

We need to read the data from the Postgres DB to process some transactions in AEM.

I am following the below article to achieve this connectivity.

https://helpx.adobe.com/experience-manager/6-3/sites/developing/using/jdbc.html

[Bharath_valse]

If I understand correctly, you are trying to fetch some information from postgresql for some transaction in AEM and not trying to replace  tarMK with RDBMS. Couple of options to look at

- Are you able to successfully install the driver specific to postgreSQL? Make sure you have wrapped the driver jar to osgi bundle. If the drivers are not installed correctly, program to connect to the DB should spit some errors in the logs

- Do you have these osgi configs as part of your code under /apps. This article might help AEM Concepts | AEM Tutorial | Know Adobe CQ better: November 2017

[Former Community Member · Accepted solution]

Querying data from a relational database to display in an AEM component can be done:

Adobe Experience Manager Help | Querying MySQL data using an Adobe Experience Manager 6.4 DataSource...

[anandkilli]

Hi Sahil,

What version of AEM you are trying this on? The error that you posted doesn't seem to be related to the issue you are seeing. Let us know at a high level what you have tried (you already mentioned one, wrapping the PostegreSql jdbc jar as osgi bundle).

What are you expecting to see and what you are seeing.

I will try to reproduce from my end and share any suggestions I can think of. Good luck.

[kavalidurga]

@sahilg75191328  

Can you share your experience in connectivity of PostgreSQL with AEM, 

pls let me know if you faced any challenges or limitations?

Thanks,

Durga Kavali.