How to connect to a PostgreSQL DB on a remote server?

V

Vlad Gapanovich2021-03-17 00:23:32

PostgreSQL

Vlad Gapanovich, 2021-03-17 00:23:32

Right now the base is on a local server (PC). And there is hosting from Amazon. And right now, I don’t understand how I can connect to the database on the hosting. hosting and PC are on Windows. Preferably in stages. Picture of pg_hba file on hosting.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

S

Sergey Gornostaev, 2021-03-17
@Mario172

Make sure PostgreSQL is listening on the external network interface.
Make sure that the address of your PC is included in the subnet specified in pg_hba.conf.
Make sure that the operating system firewall is not blocking connections on the port.
Make sure that there is a rule in the security groups that allows connection to the port.

When all conditions are met and there is no connection, you need to pick up network diagnostic utilities and dig into all available logs.