Re: Version details for psql/postmaster - Mailing list pgsql-novice

From Shabala Deshpande
Subject Re: Version details for psql/postmaster
Date
Msg-id 16b7e2640903012143j847e620kf43b3ec9bf8d6cbb@mail.gmail.com
Whole thread Raw
In response to Re: Version details for psql/postmaster  (John DeSoi <desoi@pgedit.com>)
List pgsql-novice
yeah thanks, couldn't update over the weekend.Found that the postmaster/postgres in my /usr/bin was the older version and the newer version of postmaster/postgres was located  at /usr/local/pgsql and after installation of 8.3.4 the postmaster binary in  the /usr/bin had not been updated so it was giving me different version.Got it sorted.. thanks for your help and time.

Regards,
Shabala.

On Thu, Feb 26, 2009 at 7:50 PM, John DeSoi <desoi@pgedit.com> wrote:

On Feb 26, 2009, at 3:22 AM, Shabala Deshpande wrote:

I have postgres 8.3.4 installed on my test m/c.. I know that psql is a commandline client support for postgres. When I do psql --version i have

psql --version
psql (PostgreSQL) 8.3.4
contains support for command-line editing


and when i do postmaster/postgres version which i know that is a server for postgres it gives me:

postgres --version
postgres (PostgreSQL) 7.2.7

so my question is whether the Postgres 8.3.4 is the version for client or server??
is the internal version for server the same as above or it also should be 8.3.4??

psql --version always gives the version for psql (the client). postgres --version is the server. If the above is correct you have a very old server version and should consider upgrading it. In general, newer clients will work with older servers (and vice-versa) but you could run into various problems.

Note you can check the server version from the client (psql) using the command "SELECT version();"




John DeSoi, Ph.D.





pgsql-novice by date:

Previous
From: Valentin Gjorgjioski
Date:
Subject: Re: sorting and grouping with min/max
Next
From: "A. Kretschmer"
Date:
Subject: Re: sorting and grouping with min/max