From: | Harshad Adalkonda <adalkondaharshad(at)gmail(dot)com> |
---|---|
To: | vjoshi(at)zetainteractive(dot)com |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: How to upgrade psql client |
Date: | 2015-02-10 05:38:58 |
Message-ID: | CANnQH_i33TodMxkx6NNrgY-vG3Egpj62Le1Bs=y61=AkfY0CTw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Mon, Feb 9, 2015 at 7:55 PM, 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
>
Hi Vivekanand,
You don't need to upgrade psql client if you have installed PostgreSQL
9.3.5 from sources without specifying *--prefix*
then your all postgresql 9.3 binaries are under /usr/bin
So you just need to specify the path of that directory in .bash_profile
which is under users home directory.
Following example of .bash_profile file.
PATH=/usr/bin:$PATH
export PATH
After creating file just reload the file
source .bash_profile
Hope this will solve your problem.
--
*Thanks & Regards,*
Harshad Adalkonda
Database Administrator
http://www.shreeyansh.com
From | Date | Subject | |
---|---|---|---|
Next Message | Shreeyansh Dba | 2015-02-10 06:26:31 | Re: Lost statistics after restore database |
Previous Message | David G Johnston | 2015-02-10 05:02:37 | Re: [PERFORM] <empty string> Vs NULL |