Connecting Postgres and Coldfusion 2023

[Vishnu22410012h6s8]

Hi Team,

Could you please help me with connecting Coldfusion 2023 with PostGres? I don't know what driver Jar file and other files needed to be copied and  placed in the coldfusion directory. 

[Vikram Kumar M]

@Vishnu22410012h6s8  Have you tried the built-in PostgreSQL drivers?

Please ensure that the PostgreSQL package is installed under the Package Manager. 

Thanks,

Vikram

[Vishnu22410012h6s8]

Hi Vikram, 

I  think  posgres driver installed :

Could you please let me know the details that are to be filled in the Add Data Source. Please find the below image :

[Vikram Kumar M]

@Vishnu22410012h6s8  You need to add the server name or IP address of the PostgreSQL, DB name, user, and password. 

For example:

Thanks,

Vikram