Обсуждение: Version details for psql/postmaster

hi,
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??

Got a bit confusd on this on... Instant help appreciated a lot!!

Thanks in ADVANCE!!

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.

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.