PostgresQL DB Connection via pgAdminon local laptop

tdsgitHOBBY

6 months ago

I am trying to connect to postgresQL database in project index1 using pgAdmin on my local laptop.

It is giving me the error "Unable to connect to server: [Errno 11001] getaddrinfo failed"

Register Server

General Tab -> Name: index1

Connections Tab -> Host name / address (PGHOST): postgres.railway.internal

Connections Tab -> Port (PGPORT): 5432

Connections Tab -> Maintenance Database (PGDATABASE): railway

Connections Tab -> Username (PGUSER): postgres

Connections Tab -> Password (PGPASSWORD): *********************

Parameters Tab -> NO CHANGES

SSH Tunnel Tab -> NO CHANGES

Advanced Tab -> NO CHANGES

Thank You!

3 Replies

6 months ago

Locally you need to use the public host and port.


tdsgitHOBBY

6 months ago

Under variables I only see PGHOST and PGPORT. Is there public host and port variables defined somewhere else?

Thank You!


6 months ago

Hello,

They would be in the service settings under networking!