|
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@xxxxxxxxx]
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@xxxxxxxx> 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 |
