pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to upgrade psql client
4+ messages / 4 participants
[nested] [flat]
* How to upgrade psql client
@ 2015-02-09 14:25 Vivekanand Joshi <vjoshi@zetainteractive.com>
0 siblings, 3 replies; 4+ messages in thread
From: Vivekanand Joshi @ 2015-02-09 14:25 UTC (permalink / raw)
To: pgsql-admin
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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: How to upgrade psql client
@ 2015-02-09 14:46 John Scalia <jayknowsunix@gmail.com>
parent: Vivekanand Joshi <vjoshi@zetainteractive.com>
2 siblings, 0 replies; 4+ messages in thread
From: John Scalia @ 2015-02-09 14:46 UTC (permalink / raw)
To: vjoshi@zetainteractive.com; pgsql-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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: How to upgrade psql client
@ 2015-02-10 05:38 Harshad Adalkonda <adalkondaharshad@gmail.com>
parent: Vivekanand Joshi <vjoshi@zetainteractive.com>
2 siblings, 0 replies; 4+ messages in thread
From: Harshad Adalkonda @ 2015-02-10 05:38 UTC (permalink / raw)
To: vjoshi@zetainteractive.com; +Cc: pgsql-admin
On Mon, Feb 9, 2015 at 7:55 PM, Vivekanand Joshi <vjoshi@zetainteractive.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@postgresql.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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: How to upgrade psql client
@ 2015-02-10 06:42 Devrim Gündüz <devrim@gunduz.org>
parent: Vivekanand Joshi <vjoshi@zetainteractive.com>
2 siblings, 0 replies; 4+ messages in thread
From: Devrim Gündüz @ 2015-02-10 06:42 UTC (permalink / raw)
To: vjoshi@zetainteractive.com; pgsql-admin
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@zetainteractive.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@postgresql.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.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2015-02-10 06:42 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-02-09 14:25 How to upgrade psql client Vivekanand Joshi <vjoshi@zetainteractive.com>
2015-02-09 14:46 ` John Scalia <jayknowsunix@gmail.com>
2015-02-10 05:38 ` Harshad Adalkonda <adalkondaharshad@gmail.com>
2015-02-10 06:42 ` Devrim Gündüz <devrim@gunduz.org>
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