I want to use graphical programs (particularly pgAdmin III) to administer PostgreSQL on an external, remote server. The existing documentation I can find doesn't cover that situation but i finally found a solution by multiple queries and trial and error. The solution follows.
Assumptions:
- You have root access to the remote server and thus full control over it and your PostgreSQL installation. You will need assistance from your server administrator if you don't have root access.
- The server is running a Linux O/S. My server is Ubuntu 10.04 LTS but the procedures should work with most Linux PostgreSQL installations.
There is one main problem that needs to be addressed that requires two major steps to solve: allowing remote access to the server by the "postgres" user.
(To be continued if there is interest...)
