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.