How to Access Remote PostgreSQL Database Server Through VPN

I'm currently working with my office server, when i want to connect to the server, i have to use their VPN. I have installed PostgreSQL database in their server and have succesfully migrate data to database from Django project. But, when i want to remote access from HeidiSQL, it always gives me Connection Timed Out Error eventhough i have already connected to their VPN.

I've tried to this code below

/var/lib/pgsql/14/data/pg_hba.conf

host all all 0.0.0.0/0 md5
host all all ::/0 md5

/var/lib/pgsql/14/data/postgresql.conf

listen_addresses = '*'

i have tried to refresh everytime i change files and see if i'm in the correct port but it still gives me Connection Timed Out Error

this is the full error message

could not connect to server: Connection Timed out (0x0000274C/10060). Is the server running on host "xxx.xxx.xxx.xxx" and accepting TCP/IP connections on port 5432 ?

NOTES

  • OS : CentOS 8
  • DB : PostgreSQL 14
Back to Top