pgAdmin4: remote access to PostgreSQL server

Question

I can access the remote PostgreSQL server in the lab from both the terminal and using pgAdmin4 when connected to same private network.

From Terminal:

PC:~$ psql -h 193.13x.xx.xx -U myusername -W dbname
#then password after prompt

Using pgAmin4:

Host name/address: 193.13x.xx.xx
Port: 5432
Maintainance database: dbname
Username: myusername
Password: *******

However, when I switched to another network eduroam, I can only connect to the remote server via the terminal, not from pgAdmin4. So it is not very easy to work away from the lab.

Is there a workaround to enable connecting via pgAdmin4?

Yes, 'could not connect to server: Connection refused. Is the server running on host "193.13x.xx.xx" and accepting TCP/IP connections on port 5432?' — arilwan
– arilwan, Commented Jan 7, 2020 at 16:59
Did you check for a Firewall ( on your local machine) blocking outgoing connections for one application but not the other? — clamp
– clamp, Commented Jan 7, 2020 at 17:07

Daniel Vérité · Accepted Answer · 2020-01-07 17:45:20Z

2

I can only connect to the remote server via the terminal, not from pgAdmin4. So it is not very easy to work away from the lab. Is there a workaround to enable connecting via pgAdmin4?

Yes. The generic answer to that is: use an SSH tunnel. It's very usual when you cannot access directly a database from outside a certain network, which appears to be your case based on the error message in the comments.

If you need specific advice for pgAdmin4, consider searching for "pgadmin4 ssh tunnel", there are many tutorials available online.

answered Jan 7, 2020 at 17:45

Daniel Vérité

62.3k16 gold badges134 silver badges160 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Laurenz Albe Over a year ago

If that is the solution, then why can OP connect with psql? Both are using libpq.

Daniel Vérité Over a year ago

@LaurenzAlbe: my interpretation of I can only connect to the remote server via the terminal is the OP does ssh and psql in the local session, not a remote psql.

Collectives™ on Stack Overflow

pgAdmin4: remote access to PostgreSQL server

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related