Setup PostgreSQL as DataSource for AEM Forms

[Mahedi_Sabuj]

Hi Community Members,

I wanted to setup PostgreSQL as DataSource for AEM Forms. I have configured "Apache Sling Connection Pooled DataSource" for Postgres with below details:

Postgres is now available as DataSource during create new Form Model however getting an error message "Error in fetching DataSource". Can anyone please guide me how to complete the setup?

[Shashi_Mulugu]

@Mahedi_Sabuj where are you getting above error? On publisher?

[Mahedi_Sabuj]

Author Environment @Shashi_Mulugu 

After checking the documentation, It seems need to install the PostgreSQL OSGi Bundle, but not sure where to get the JAR bundle file.

[Pulkit_Jain_]

@Mahedi_Sabuj 

What is the error msg that you're getting in the author error logs for the attempt?

And yes, database driver wrapper bundle jar needs to be installed to make a successful connection. You can convert the postgres DB driver jar into a bundle by adding the manifest file and deploy the bundle.

[kautuk_sahni]

@Mahedi_Sabuj Did you find the suggestions from users helpful? Please let us know if more information is required. Otherwise, please mark the answer as correct for posterity. If you have found out solution yourself, please share it with the community.