Обсуждение: WARNING: psql version 8.4, server version 9.2.

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

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

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@ctcd.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

 

Thank you Rajesh for the instructions on how to set the PATH in the .bash_profile.

You are correct, the version in use is the 8.4:

# psql -V

psql (PostgreSQL) 8.4.13

contains support for command-line editing

I found the .bash_profile only under the home directory for 8.4 (/var/lib/pgsql), not for 9.2 (/var/lib/pgsql/9.2)

So I copied the /var/lib/pgsql/.bash_profile to /var/lib/pgsql/9.2/ and modified it there to include the PATH, which it did not have before:

-bash-4.1$ cat /var/lib/pgsql/9.2/.bash_profile

[ -f /etc/profile ] && source /etc/profile

PGDATA=/var/lib/pgsql/9.2/data

export PGDATA

PATH=/usr/pgsql-9.2/bin/:$PATH

export PATH

-bash-4.1$

Then I restarted the postgresql-9.2 service and then logged into one of my databases.  It worked -- I no longer get the warning, and it shows that it is using 9.2 psql, not 8.4 psql:

# su - postgres

-bash-4.1$ psql testdb

psql (9.2.9)

Type "help" for help.

testdb=#

Thanks again!

Julie

From: Shreeyansh dba [mailto:shreeyansh2014@gmail.com]
Sent: Monday, November 03, 2014 10:36 PM
To: Davenport, Julie
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] WARNING: psql version 8.4, server version 9.2.