I had to find a new home for Teeview since its free plan was running full. So I would like it to use and external Postgres hosting on a VPS. So here’re simple processes to setup PostgreSQL on Ubuntu 12.04. Enjoy!
First, perform a quick update of the apt-get repository.
Once apt-get has updated go ahead and download Postgres and its helpful accompanying dependencies.
Postgres is installed, now time to set a new password for
Move on to configure postgres.
Enable remote access from any IP address (with password required).
Add this line to
Allow TCP/IP socket. Modify this line in
And restart Postgres after finish configuration.
Also make sure you enable a firewall for Postgres.
And done! Now you have your Postgres running and can be accessed from any remote. Thanks to many posts help me setting all this up.