title: Upgrading Postgre 8.4 to 9.1 on Ubuntu (Turnkey Linux)
body: <p>I am trying to get Postgre 9.1 to work because I need the features available in the 2.0 version of PostGIS. Turnkey Linux offers a Postgre 8.4 appliance which works great and even has PostGIS built in... but it's only version 1.2.</p>
  
  <p>I followed this guide which basically showed how I could install 9.1 via apt-get, which seems to have worked:
  <a href="http://netadminlinux.blogspot.com/2011/11/installing-postgresql-91-on-ubuntu-1104.html" rel="nofollow">http://netadminlinux.blogspot.com/2011/11/installing-postgresql-91-on-ubuntu-1104.html</a></p>
  
  <p>My problem now, is that while both 8.4 and 9.1 are installed, I only seem to be able to access 8.4. I installed pgadmin3, but I have no idea how to access it since the default Turnkey Appliance is set up to host pgadmin2.</p>
  
  <p>in /etc/init.d/ there are two entries, postgres-8.4. and postgres. I believe the second is the 9.1 instance, and I can even start it up with /etc/init.d/postgres start. I tried shutting down the 8.4 instance, and then starting the 9.1... but when I try to use command line psql to access the server I get the following message:</p>
  
  <blockquote>
    <p>psql: could not connect to server: No such file or directory Is the
    server running locally and accepting connections on Unix domain socket
    "/var/run/postgresql/.s.PGSQL.5432"?</p>
  </blockquote>
  
  <p>What do I need to do to my new instance of 9.1 to get it to run? What are the post-installation steps that I seem to have missed?</p>