Database Error: Failed to connect to database using user [ ]and connection string [Postgres Liferay Source].].

Database Error: Failed to connect to database using user and connection string [Postgres Liferay Source].].

solution:

Below parameters were changed in odbc.ini file and the jobs succeeded subsequently.
 

EnableDescribeParam=0(was pointing to 1 earlier)

EncryptionMethod=1(was pointing to 0 earlier)

Primary checks before doing the above thing.

1. check are you able to connect to that data base,if you are able to connect to that data base but still its giveing error then you need to check the above parameter settings.

2.if you are not able to connect to that data base then there was a problem at data base side.

3.There may be a case that we need to check the ConnectionRetryCount in ODBC driver,this will occur because of the network latency so that the client is not able to sent the credentials with in the 5 seconds.

Try changing the ODBC parameter“ConnectionRetryCount” from 0 to 3.