From: jayknowsunix@gmail.com
To: Payal Singh <payal@omniti.com>
Cc: Davenport, Julie <JDavenport@ctcd.edu>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: WARNING: psql version 8.4, server version 9.2.
Date: Mon, 3 Nov 2014 18:55:25 -0500
Message-ID: <089E837D-1E78-41B9-BC6A-9731FBA5E2C7@gmail.com> (raw)
In-Reply-To: <CANUg7LAN2dMv48iTzHprKMwqVr-1jGAdwSgC0VCM8hEUCA4wpw@mail.gmail.com>
References: <53AA753E5EA4A14784092D825AD4FD3D4F9F8093@CTC3650D>
<CANUg7LAN2dMv48iTzHprKMwqVr-1jGAdwSgC0VCM8hEUCA4wpw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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@omniti.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@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
>>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jayknowsunix@gmail.com, payal@omniti.com, JDavenport@ctcd.edu
Subject: Re: WARNING: psql version 8.4, server version 9.2.
In-Reply-To: <089E837D-1E78-41B9-BC6A-9731FBA5E2C7@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox