STEP #1 – get pgAdmin
Install pgAdmin from pgadmin.org
STEP #2 – allow postgre server remote connections from everywhere
Open etc/postgresql/9.x/main/pg_hba.conf and add following line:
host all all all md5
STEP #3 – let the postgre server listen to everyone
Open etc/postgresql/9.x/main/postgresql.conf and change following line:
listen_addresses = ‘*’
STEP #4 – give the user “postgres” a password
Start the psql terminal: sudo -u postgres psql
Give a password: ALTER USER postgres PASSWORD ‘yourpassword';
Leave the psql terminal: \q
Restart postgre server by executing this terminal command:
sudo /etc/init.d/postgresql restart
You are ready!
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!