Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XlRTC-0005nq-PZ for pgsql-admin@arkaria.postgresql.org; Mon, 03 Nov 2014 23:55:34 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XlRTC-0002rA-8S for pgsql-admin@arkaria.postgresql.org; Mon, 03 Nov 2014 23:55:34 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XlRTA-0002r3-PM for pgsql-admin@postgresql.org; Mon, 03 Nov 2014 23:55:33 +0000 Received: from mail-qc0-x229.google.com ([2607:f8b0:400d:c01::229]) by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1XlRT6-0002IT-Ur for pgsql-admin@postgresql.org; Mon, 03 Nov 2014 23:55:30 +0000 Received: by mail-qc0-f169.google.com with SMTP id i17so10178108qcy.28 for ; Mon, 03 Nov 2014 15:55:27 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=references:mime-version:in-reply-to:content-type :content-transfer-encoding:message-id:cc:from:subject:date:to; bh=eCuNaL0Yr31pM8Ne2QmWB7AESMV5s7YHPwZAlBKLWdw=; b=IzN9623DY/0mHNgHFwCVg8BYk2NQm+4soWecLR/jwgBHEcFOaFoNcOtFUtBlwtCT/M 9bjYmQdKK9UuZhxZ8F5JZr9+SCx/zOjXDsKnvFZwW6kgzR+pQCgfEcr17x2a9YK1WKOB 1AvCdqrLGkNq+LrccULQk379sSNb57yN1/Jdw9USDos5pNgCBwcHrMKUWpqV29N/ozGL s7uwomsF8jdlGZR2ODgLmFEn/hQa2GOKKe5Mv8/XgNpoFy4CvbXWxBQjPG0HEmvt3GNh MONn5tDcWcOqNsbfqfs2ixnX2nj+sazU9WqCEgU2yFdEYU1V6Z3I9xZYqCaAi5HVkG3p AQ0A== X-Received: by 10.224.21.133 with SMTP id j5mr70646112qab.51.1415058927579; Mon, 03 Nov 2014 15:55:27 -0800 (PST) Received: from [192.168.254.3] (h77.89.102.166.static.ip.windstream.net. [166.102.89.77]) by mx.google.com with ESMTPSA id l2sm18160209qao.34.2014.11.03.15.55.26 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Mon, 03 Nov 2014 15:55:26 -0800 (PST) References: <53AA753E5EA4A14784092D825AD4FD3D4F9F8093@CTC3650D> Mime-Version: 1.0 (1.0) In-Reply-To: Content-Type: multipart/alternative; boundary=Apple-Mail-9741A169-4461-4A90-AED1-89B22C3BCC53 Content-Transfer-Encoding: 7bit Message-Id: <089E837D-1E78-41B9-BC6A-9731FBA5E2C7@gmail.com> Cc: "Davenport, Julie" , "pgsql-admin@postgresql.org" X-Mailer: iPad Mail (11D257) From: jayknowsunix@gmail.com Subject: Re: WARNING: psql version 8.4, server version 9.2. Date: Mon, 3 Nov 2014 18:55:25 -0500 To: Payal Singh X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --Apple-Mail-9741A169-4461-4A90-AED1-89B22C3BCC53 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Correct. More than likely, the path is giving the version in /usr/bin, and y= our new installation is something like /usr/pgsql-9.2/bin. You might want re= move 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 wrote: >=20 > the psql binary you are using to connect is default binary that is 8.4. Th= is message just means that the psql client is of an older version than the d= atabase.=20 >=20 > To correct this you can modify the default path to point to psql binary of= your newly installed postgres version.=20 >=20 > Payal Singh, > Database Administrator, > OmniTI Computer Consulting Inc. > Phone: 240.646.0770 x 253 >=20 >> On Mon, Nov 3, 2014 at 5:32 PM, Davenport, Julie wr= ote: >> Hello, >>=20 >> 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 r= an initdb on it. Instead, I installed postgres 9.2 via yum and di the initd= b, 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 in= to one of my databases, I always get this warning: >>=20 >> =20 >>=20 >> -bash-4.1$ psql testdb >>=20 >> psql (8.4.13, server 9.2.9) >>=20 >> WARNING: psql version 8.4, server version 9.2. >>=20 >> Some psql features might not work. >>=20 >> Type "help" for help. >>=20 >> testdb =3D# >>=20 >> =20 >>=20 >> Inside the database it says it is version 9.2: >>=20 >> testdb =3D# select version(); >>=20 >> version >>=20 >> -------------------------------------------------------------------------= ------------------------------------- >>=20 >> 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 >>=20 >> (1 row) >>=20 >> =20 >>=20 >> testdb =3D# >>=20 >> =20 >>=20 >> And the version file of the database says it is 9.2: >>=20 >> -bash-4.1$ cat /var/lib/pgsql/9.2/data/PG_VERSION >>=20 >> 9.2 >>=20 >> -bash-4.1$ >>=20 >> =20 >>=20 >> So how can my server have psql 8.4, but server 9.2? So far I have not no= ticed any problems with the databases and queries against them work, but cou= ld it become a problem at some time? Do I have to do something to upgrade t= he psql 8.4 to 9.2? >>=20 >> =20 >>=20 >> Thanks for any advice, >>=20 >> Julie >>=20 >=20 --Apple-Mail-9741A169-4461-4A90-AED1-89B22C3BCC53 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable

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 l= inux 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&g= t; 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 dat= abase.

To correct this you can modify the default path to poin= t 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, Ju= lie <JDavenport@ctcd.edu> wrote:

Hello,

I installed Postgres 9.2 on a new server that has Red= hat Enterprise Linux 6, which came with Postgres 8.4. I did not want t= o use the 8.4 and never ran initdb on it. Instead, I installed postgre= s 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 se= rvice shut down and set to not start up upon reboot. Whenever I log in= to one of my databases, I always get this warning:

-bash-4.1$ psql testdb

psql (8.4.13, serve= r 9.2.9)

WARNING: psql versi= on 8.4, server version 9.2.

&= nbsp; Some psql features might not work.

Type "help" for help.

testdb =3D#

Inside the database it says it is version 9.2:=

testdb =3D# select version();

= ; &nb= sp; &= nbsp; = ; version

-----------------------------------------------------= ---------------------------------------------------------

PostgreSQL 9.2.9 on x86_64-unknown-linux-gnu, compile= d by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit

(1 row)

testdb =3D#

And the version file of the database says it is 9.2:<= u>

-bash-4.1$ cat /var/lib/pgsql/9.2/data/PG_VERSION<= /u>

9.2

-bash-4.1$

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

Thanks for any advice,

Julie

= --Apple-Mail-9741A169-4461-4A90-AED1-89B22C3BCC53--