Re: How to upgrade psql client

Hi,

Is this CentOS 5 and did you install 9.3 from RPMs?

If so, 9.3 psql is under /usr/pgsql-9.3/bin/psql .

You can run

yum remove postgresql

to remove 8.1 client, and then run

yum reinstall postgresql93

So that new symlinks will be created.

Regards,

On February 9, 2015 4:25:20 PM EET, Vivekanand Joshi <vjoshi(at)zetainteractive(dot)com> wrote:
>Hi Team,
>
>I want to upgrade my psql client which is version 8.1.23 right now. I
>am
>not been able to see the DDL for the tables using \d option. I have
>installed PostgreSQL through source.
>
>How to upgrade the client?
>
>============================
>
>postgres=# select version ();
> version
>--------------------------------------------------------------------------
>-------------------------------------
>PostgreSQL 9.3.5 on x86_64-unknown-linux-gnu, compiled by gcc (GCC)
>4.1.2
>20080704 (Red Hat 4.1.2-44), 64-bit
>(1 row)
>
>===============================
>
>psql -U postgres -W
>
>Welcome to psql 8.1.23 (server 9.3.5), the PostgreSQL interactive
>terminal.
>
>Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help with psql commands
> \g or terminate with semicolon to execute query
> \q to quit
>
>WARNING: You are connected to a server with major version 9.3,
>but your psql client is major version 8.1. Some backslash commands,
>such as \d, might not work properly.
>
>=====================================
>
>
>Thanks,
>Vivek
>
>
>--
>Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-admin

--
Sent from my Android device with K-9 Mail. Please excuse my brevity.