Re: WARNING: psql version 8.4, server version 9.2.

From: Devrim Gündüz <devrim(at)gunduz(dot)org>
To: "Davenport, Julie" <JDavenport(at)ctcd(dot)edu>
Cc: "jayknowsunix(at)gmail(dot)com" <jayknowsunix(at)gmail(dot)com>, Payal Singh <payal(at)omniti(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: WARNING: psql version 8.4, server version 9.2.
Date: 2014-11-07 17:46:13
Message-ID: 1415382373.2974.20.camel@asus-laptop-03.gunduz.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hi,

On Tue, 2014-11-04 at 22:57 +0000, Davenport, Julie wrote:
> 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

I haven't tested recently, but if you remove 8.4 RPMs, I think you will
need to run

yum reinstall postgresql92 postgresql92-server

to rebuild the alternatives link (or extract them from the RPMs)

Regards,

--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message christian.echerer 2014-11-10 13:48:40 Missing timeline history file after execution of pg_upgrade
Previous Message Albe Laurenz 2014-11-07 10:03:33 Re: Autocommit off in psql