Re: WARNING: psql version 8.4, server version 9.2. - Mailing list pgsql-admin

From Davenport, Julie
Subject Re: WARNING: psql version 8.4, server version 9.2.
Date
Msg-id 53AA753E5EA4A14784092D825AD4FD3D4F9F8521@CTC3650D
Whole thread Raw
In response to Re: WARNING: psql version 8.4, server version 9.2.  (Shreeyansh dba <shreeyansh2014@gmail.com>)
List pgsql-admin

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.

 

I suspect there is 8.4 is installed on the server.

check psql version whether it is 9.2 or 8.4

To check psql version psql -V it will show version of psql if it is 8.4 then set .bash_profile to 9.2 binaries.

Go to home directory of postgres and edit .bash_profile

vim .bash_profile

export PATH=/path till bin/:$PATH and save the file this will help you to solve the issue.

 

 

Thanks and regards,

Rajesh

Database Administrator

 

On Tue, Nov 4, 2014 at 4:02 AM, 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

 

pgsql-admin by date:

Previous
From: "Davenport, Julie"
Date:
Subject: Re: WARNING: psql version 8.4, server version 9.2.
Next
From: "Tom Fischer"
Date:
Subject: xlog-cleanup problem