Connectivity of postgres DB with AEM | Community
Skip to main content
S
sahilg75191328
Level 2
June 20, 2019
Solved

Connectivity of postgres DB with AEM

  • June 20, 2019
  • 7 replies
  • 5118 views

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.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by

    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 DataSourcePool

    7 replies

    H
    Adobe Employee
    Hamid1350Adobe Employee
    Adobe Employee
    June 20, 2019

    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

    D
    Divya_13
    Level 2
    July 13, 2023

    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

    joerghoh
    Adobe Employee
    joerghohAdobe Employee
    Adobe Employee
    June 20, 2019

    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

      S
      sahilg75191328Author
      Level 2
      June 20, 2019

      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
      Bharath_valse
      Level 4
      June 21, 2019

      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

      A
      Anonymous
      Accepted solution
      June 21, 2019

      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 DataSourcePool

        A
        anandkilli
        June 22, 2019

        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.

        durga_kavali
        durga_kavali
        Level 3
        July 13, 2023

        @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.

        Terms & ConditionsAccessibility statement

        Loading footer...