Re: Version details for psql/postmaster

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(at)pgedit(dot)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.
>
>
>
>
>