From: John Scalia <jayknowsunix@gmail.com>
To: vjoshi@zetainteractive.com
To: pgsql-admin@postgresql.org
Subject: Re: How to upgrade psql client
Date: Mon, 09 Feb 2015 09:46:47 -0500
Message-ID: <54D8C857.9060405@gmail.com> (raw)
In-Reply-To: <6658be918d92355be589a80f7b941ff2@mail.gmail.com>
References: <6658be918d92355be589a80f7b941ff2@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On 2/9/2015 9:25 AM, Vivekanand Joshi 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
>
If you built from source, did it build a psql executable for 9.3.5? And if you built from source and then did a "make install", then you may have the new psql under your bin
directory. (I'm only used to centOS and RedHat, which puts these under /usr/pgsql-9.3/bin, My experience is that this is usually done from a source build.
--
Jay
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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, vjoshi@zetainteractive.com
Subject: Re: How to upgrade psql client
In-Reply-To: <54D8C857.9060405@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