title: Conflicting versions of postgres database and server
body: <p>I installed postgres on Mac OS X 10.6.x. 
  When I ran for postgres database version: </p>
  
  <pre><code>psql --versionpsql (PostgreSQL) 9.1.1
  contains support for command-line editing
  </code></pre>
  
  <p>When I checked for the version of the server:</p>
  
  <pre><code>psql -c "select version();"                                                                     version                                                                      
  --------------------------------------------------------------------------------------------------------------------------------------------------
   PostgreSQL 9.0.5 on x86_64-apple-darwin10.8.0, compiled by GCC i686-apple-darwin10-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc. build 5666) (dot 3), 64-bit
  (1 row)
  </code></pre>
  
  <p>So when I run </p>
  
  <pre><code>bash-3.2$ psql
  psql (9.1.1, server 9.0.5)
  WARNING: psql version 9.1, server version 9.0.
           Some psql features might not work.
  </code></pre>
  
  <p>I am not sure what those features are. These versions are conflicting. I am new to using postgres so I dont know how to upgrade just the postgres server. I tried to search for something online but did not find much help. I don't want to uninstall and reinstall postgres. Is there anyway I could use them both together without them conflicting? Or just upgrade the server to the same version as database?</p>
  
  <p>Edit:</p>
  
  <pre><code>which psql
  /opt/local/lib/postgresql91/bin//psql
  
  which postgres
  /opt/local/lib/postgresql91/bin//postgres
  
  ps -eaf|grep postgres
      0    60     1   0   0:00.07 ??         0:00.09 /opt/local/bin/daemondo --label=postgresql90-server --start-cmd /opt/local/etc/LaunchDaemons/org.macports.postgresql90-server/postgresql90-server.wrapper start ; --stop-cmd /opt/local/etc/LaunchDaemons/org.macports.postgresql90-server/postgresql90-server.wrapper stop ; --restart-cmd /opt/local/etc/LaunchDaemons/org.macports.postgresql90-server/postgresql90-server.wrapper restart ; --pid=none
    103  3971  3967   0   0:00.69 ??         0:01.17 postgres: writer process     
    103  3972  3967   0   0:00.67 ??         0:00.88 postgres: wal writer process     
    103  3973  3967   0   0:00.18 ??         0:00.23 postgres: autovacuum launcher process     
    103  3974  3967   0   0:00.19 ??         0:00.21 postgres: stats collector process     
      0  3616  2726   0   0:00.04 ttys000    0:00.06 su postgres
    103  3967  3619   0   0:00.23 ttys000    0:00.34 postgres -D /usr/local/pgsql/data
      0  4559  4055   0   0:00.03 ttys001    0:00.05 su postgres
    103  5922  4560   0   0:00.01 ttys001    0:00.01 grep postgres
  </code></pre>
  
  <p>Thank you. </p>