How do I enable remote access to my 3CX PostgreSQL DB?
Follow these steps to make external connections to your 3CX database, or any other PostgreSQL server:
- To be able to reach the server remotely you have to add the following line into the file
listen_addresses = '*'
- PostgreSQL by default refuses all connections it receives from any remote address. You have to relax these rules by adding this line to pg_hba.conf:
host all logsreader 0.0.0.0/0 password
- Restart your PostgreSQL services.
- Edit windows firewall to allow TCP port 5480
Now you will be able to login to your server remotely.