Thread: How to upgrade psql client

How to upgrade psql client

From
Vivekanand Joshi
Date:
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


Re: How to upgrade psql client

From
John Scalia
Date:
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
isusually done from a source build. 
--
Jay


Re: How to upgrade psql client

From
Harshad Adalkonda
Date:

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

Re: How to upgrade psql client

From
Devrim Gündüz
Date:
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 from my Android device with K-9 Mail. Please excuse my brevity.