BI-TAGS

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 STEP #5 Restart postgre server by executing this terminal command: sudo /etc/init.d/postgresql restart STEP #6 Start pgAdmin and add a connection to a server like this: