Sometimes you need to provide remote administration where you can not directly connect to your server via ssh and create tunnels. For security reasons, by default, postgresql disables all remote connections.
| Warning |
|---|
Only do this if SSH tunnels is not possible. SSH with Keys is the preferred method for providing remote administration. |
Here are my notes on how to make postgresql sql available to other systems on the same network. I found these instructions to be the easiest and generally secure. If you have a good understanding of networking, you can further lock this down.
...