Re: What Version Installed? - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: What Version Installed?
Date
Msg-id 20040116050619.GA32715@svana.org
Whole thread Raw
In response to Re: What Version Installed?  (Alex Satrapa <alex@lintelsys.com.au>)
List pgsql-general
That's the file the backend uses to determine whether the directory it's
looking at is:

a) an initdb'd location
b) initdb'd with the right version

It bears no relation to your actual installed binaries though.

On Fri, Jan 16, 2004 at 10:32:24AM +1100, Alex Satrapa wrote:
> Roberto Andrade Fonseca wrote:
> >El jue, 15-01-2004 a las 16:56, Phil Campaigne escribió:
> >
> >>Hi All,
> >>How can I determine what version of postgresql is installed.
> >
> >SELECT version();
>
> What's the function or purpose of the file "PG_VERSION" in $PGDATADIR?
>
> In my case, /var/lib/postgres/data/PG_VERSION contains "7.3"
>
> Is this the version of PostgreSQL that created the database?
>
> Alex Satrapa
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faqs/FAQ.html

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> (... have gone from d-i being barely usable even by its developers
> anywhere, to being about 20% done. Sweet. And the last 80% usually takes
> 20% of the time, too, right?) -- Anthony Towns, debian-devel-announce

Attachment

pgsql-general by date:

Previous
From: "LitelWang"
Date:
Subject: how to catch the error in procedure ?
Next
From: Michael Glaesemann
Date:
Subject: tinterval operators and functions