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
host all all 0.0.0.0/0 md5 host all all ::/0 md5
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 ?
- OS : CentOS 8
- DB : PostgreSQL 14