Re: WARNING: psql version 8.4, server version 9.2.

Thank you Jay and Payal, you were right, the wrong bin was in use:

# ll /usr/bin/psql
-rwxr-xr-x 1 root root 342832 Aug 27 2012 /usr/bin/psql (8.4 binary)

# ll /usr/pgsql-9.2/bin/psql
-rwxr-xr-x 1 root root 439352 Jul 22 11:25 /usr/pgsql-9.2/bin/psql (9.2 binary)

# which psql
/usr/bin/psql

8.4 was being used

Julie

From: jayknowsunix(at)gmail(dot)com [mailto:jayknowsunix(at)gmail(dot)com]
Sent: Monday, November 03, 2014 5:55 PM
To: Payal Singh
Cc: Davenport, Julie; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] WARNING: psql version 8.4, server version 9.2.

Correct. More than likely, the path is giving the version in /usr/bin, and your new installation is something like /usr/pgsql-9.2/bin. You might want remove the package that came with your linux installation, that will save you a lot of grief later.
--
Jay

Sent from my iPad

On Nov 3, 2014, at 5:38 PM, Payal Singh <payal(at)omniti(dot)com<mailto:payal(at)omniti(dot)com>> wrote:
the psql binary you are using to connect is default binary that is 8.4. This message just means that the psql client is of an older version than the database.
To correct this you can modify the default path to point to psql binary of your newly installed postgres version.

Payal Singh,
Database Administrator,
OmniTI Computer Consulting Inc.
Phone: 240.646.0770 x 253

On Mon, Nov 3, 2014 at 5:32 PM, Davenport, Julie <JDavenport(at)ctcd(dot)edu<mailto:JDavenport(at)ctcd(dot)edu>> wrote:
Hello,
I installed Postgres 9.2 on a new server that has Redhat Enterprise Linux 6, which came with Postgres 8.4. I did not want to use the 8.4 and never ran initdb on it. Instead, I installed postgres 9.2 via yum and di the initdb, etc, on 9.2 and have been using only that version. I have the postgres 8.4 service shut down and set to not start up upon reboot. Whenever I log into one of my databases, I always get this warning:

-bash-4.1$ psql testdb
psql (8.4.13, server 9.2.9)
WARNING: psql version 8.4, server version 9.2.
Some psql features might not work.
Type "help" for help.
testdb =#

Inside the database it says it is version 9.2:
testdb =# select version();
version
--------------------------------------------------------------------------------------------------------------
PostgreSQL 9.2.9 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit
(1 row)

testdb =#

And the version file of the database says it is 9.2:
-bash-4.1$ cat /var/lib/pgsql/9.2/data/PG_VERSION
9.2
-bash-4.1$

So how can my server have psql 8.4, but server 9.2? So far I have not noticed any problems with the databases and queries against them work, but could it become a problem at some time? Do I have to do something to upgrade the psql 8.4 to 9.2?

Thanks for any advice,
Julie