up vote 0 down vote favorite
share [g+] share [fb]

Possible Duplicate:
How to install Postgres on LINUX with two verions?

I've installed multiple PostgreSQL version(9.0.3, 8.4.6) on same server . I've changed PORT also. I used to run:

 psql -h localhost -p 5437 -U postgres8 -d postgres.

It is working fine. But showing old version (8.3) instead of 8.4.

what is my mistake? Please help me...

link|improve this question
3  
How many dups of this are you going to open? – Denis Jun 10 '11 at 9:17
1  
Stop posting the same question! If you have more detail to put into your question please edit your original post to fine tune it, but please don't keep adding new questions. – Caleb Jun 10 '11 at 12:34
feedback

migrated from stackoverflow.com Jun 10 '11 at 9:31

This question came from our site for professional and enthusiast programmers.

closed as exact duplicate by Chopper3 Jun 21 '11 at 14:09

This question covers exactly the same ground as earlier questions on this topic; its answers may be merged with another identical question. See the FAQ for guidance on how to improve it.

1 Answer

up vote 1 down vote

You probably mean the version output of your psql binary. Try to make the server version visible:

$ psql -h localhost -p 5437 -U postgres8 -d postgres
SELECT version();

To avoid problems, I'd recommend to either use the psql binary from PostgreSQL 9 or to use the psql binary that matches the server version. Unter Debian/Ubuntu you'll find the binaries under /usr/lib/postgresql/<VERSION>/bin/psql.

link|improve this answer
feedback

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