Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

I have 2 different versions of PostgreSQL installed on my system (Ubuntu Lucid):

  • /var/lib/postgresql/8.4
  • /var/lib/postgresql/9.0

By default, when I run a PostgreSQL command such as createdb or psql, the 9.0 version is used.

How do I configure my system to use the 8.4 version by default instead?

share|improve this question

1 Answer 1

The various PostgreSQL command line tools will talk to the server listening on the default port (5432) by default.

You can determine which port each server is listening on by looking for the port variable in the /etc/postgresql/$VERSION/main/postgresql.conf file for the relevant server.

To get the command line tools to talk to the other server by default, you have two options:

First, you could switch the ports the two servers are listening on by editing the previously mentioned configuration files and then restarting both servers (you'll probably want to stop each one before starting either).

Alternatively, you can set the PGPORT environment variable to the port number of the desired default server. That should affect all applications using the PostgreSQL client library.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.