Re: How to check what is current postgres version

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Markova, Nina" <nmarkova(at)nrcan(dot)gc(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to check what is current postgres version
Date: 2008-09-08 17:57:09
Message-ID: dcc563d10809081057r3838fe98n792919edfc34a8c8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

select version(); ??? (Note does NOT require psql, just a connection
you can issue sql over.)

Or were you looking for a way from the command line?

/usr/lib/postgresql/8.3/bin/postgres --version

works for me on centos 5.2

On Mon, Sep 8, 2008 at 11:40 AM, Markova, Nina <nmarkova(at)nrcan(dot)gc(dot)ca> wrote:
> Hi,
>
> Is there any way to check the exact current version without issuing 'psql'
> command?
>
> Say, 8.2.1 or 8.2.9?
>
> Thanks,
> Nina

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Markova, Nina 2008-09-08 18:03:07 Postgres in a solaris zone - patch 125077-02 needed
Previous Message Markova, Nina 2008-09-08 17:55:51 Re: How to check what is current postgres version