Re: Version details for psql/postmaster

Поиск
Список
Период
Сортировка
От Shabala Deshpande
Тема Re: Version details for psql/postmaster
Дата
Msg-id 16b7e2640903012143j847e620kf43b3ec9bf8d6cbb@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Version details for psql/postmaster  (John DeSoi <desoi@pgedit.com>)
Список 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 по дате отправления:

Предыдущее
От: Valentin Gjorgjioski
Дата:
Сообщение: Re: sorting and grouping with min/max
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: sorting and grouping with min/max