From: Tom Lane <tgl@sss.pgh.pa.us>
To: bluestar43@gmail.com
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Stumped by a version conflict.
Date: Fri, 16 Jul 2010 19:28:57 -0400
Message-ID: <25504.1279322937@sss.pgh.pa.us> (raw)
In-Reply-To: <AANLkTikRAspk3fhBwyiKGBKPkG8BWMpfFZS-DQ6LCsxL@mail.gmail.com>
References: <AANLkTimvYZbjG_g_TnSItb7vxzHxolXFMrB5cHmOmIfC@mail.gmail.com>
<AANLkTinEKjPBpHbUVqAC2I7cwLJBowIx18MehShgsi91@mail.gmail.com>
<AANLkTikRAspk3fhBwyiKGBKPkG8BWMpfFZS-DQ6LCsxL@mail.gmail.com>
Patric Michael <bluestar43@gmail.com> writes:
> HI Scott. I think if anything, the reverse is true. It is entirely
> possible that I started 7.4 in a different directory by hand and that the
> 7.4 server had been running all this time. Since I can't find any other
> instances pf pg_ctl, I may well have deleted the old tree afterward as Craig
> suggested. (And with me being unaware that it was the old version running
> and not the new.)
Yeah, I too think that Craig's theory is the most likely explanation,
if you're sure there is no 7.4 executable to be found on the machine.
On most modern Unixen it's perfectly possible for an existing process to
continue to run an executable that's been deleted from the filesystem.
> My only concern at this point, and the one that makes me hesitate, is
> wondering whether or not the current database is somehow erroneously
> reporting itself as 7.4 when it is in fact 8.1.
Pretty much impossible --- the version number is compiled into the
executable at build time.
> Is there any other means
> aside from PG_VERSION for the binaries to determine which database structure
> was initialized?
The PG_VERSION files contain a human-readable version number, but there
is also a "catalog version number" stored in the pg_control file. You
might try pg_controldata for an additional check on whether the
executables you have at hand match the database, but it seems pretty
clear they don't :-(
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, bluestar43@gmail.com, scott.marlowe@gmail.com
Subject: Re: Stumped by a version conflict.
In-Reply-To: <25504.1279322937@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox