From: | Shabala Deshpande <de(dot)shabala(at)gmail(dot)com> |
---|---|
To: | John DeSoi <desoi(at)pgedit(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Version details for psql/postmaster |
Date: | 2009-03-02 05:43:44 |
Message-ID: | 16b7e2640903012143j847e620kf43b3ec9bf8d6cbb@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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.
>
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | A. Kretschmer | 2009-03-02 06:14:25 | Re: sorting and grouping with min/max |
Previous Message | Valentin Gjorgjioski | 2009-03-01 16:26:43 | Re: sorting and grouping with min/max |