Error when accessing the postgresql server in pgadmin

[JeyGR]

This is my first time trying to deploy my database hence, I couldn’t figure out what was going wrong.

When i tried to connect to my render PG server using the external link, the error arose, stating “Is the server running locally and accepting connections on that socket ?”

[ddupas]

remove the @ symbol in the Host name/address field perhaps

[al_ps]

Hi,

If you’re connecting to a Postgres DB from outside Render, this is covered in the docs here:
https://docs.render.com/databases#connecting-with-the-external-url

Which shows the breakdown of the credentials in the “External Database URL” shown on the DB dashboard:

postgres://USER:PASSWORD@EXTERNAL_HOST:PORT/DATABASE

Database = DATABASE
Server/Host = EXTERNAL_HOST
User Name = USER
Port = 5432 (Postgres default)
Password = PASSWORD

Also:
SSL Mode = “require”

You’d need to plug these details into pgAdmin.

Also, ensure the Access Control settings on the database are valid.

Alan