Re: What Version Installed?

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Alex Satrapa <alex(at)lintelsys(dot)com(dot)au>
Cc: Roberto Andrade Fonseca <randrade(at)abl(dot)com(dot)mx>, pgsql-general(at)postgresql(dot)org
Subject: Re: What Version Installed?
Date: 2004-01-16 05:06:19
Message-ID: 20040116050619.GA32715@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)svana(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2004-01-16 05:07:37 Re: [GENERAL] Bug and/or feature? Complex data types in
Previous Message LitelWang 2004-01-16 04:50:33 how to catch the error in procedure ?