PostgreSQL - Allowing remote connections on Ubuntu 8

The following steps were used to allow remote connections to postgreSQL:

• Declare IPs allowed to connect
  
  
  
  • vi /etc/postgresql/8.3/main/pg_hba.conf
  
  
  • add line: host all all 71.199.0.0/16 password
  
  
  • This enables any IPs 71.199.x.x to connect remotely and authenticate via password.
  
  
  • Refer to pg_hba.conf file reference: http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html
  
  
  
  


• Specify listen addresses for postgres
  
  
  
  • vi /etc/postgresql/8.3/main/postgresql.conf
  
  
  • modify listen_addresses='localhost' line to be listen_addresses='*'
  
  
  
  


• Restart PostgreSQL
  
  
  
  • /etc/init.d/postgresql-8.3 restart
  
  
  
  

At this point I was able to be able to connect via dbVisualizer. Note, this does not enable SSL or any sort of secure authentication. That will be the subject of another post.