I am shifting from a UAT environment to production environment,and in both instances I connect to a postgres
database using the following code:
con <- DBI::dbConnect(RPostgres::Postgres(), dbname = "my_db", host = "10.10.10.194", port = 5432, user = "my_user", password = "my_password")
Problem:
- While this works in UAT, in Production it throws an error of connection being closed unexpectedly/server terminated abnormally before or while processing request
- I am able to
telnet
successfully to the host + port - I am unable to debug and find out why the connection is closed while using DBI
How can I debug and sort this problem out?
Thank you kind people.