Re: Idea: cross-check versions during initdb

Sounds like an easy one for a newbie to pick up.  Let me look at it,
but I think I'd like dibs on it. 

LER

* Tom Lane <tgl@sss.pgh.pa.us> [001026 13:29]:
> While answering the n'th why-is-initdb-failing question that looked like
> a version mismatch problem, it occurred to me to wonder why we don't
> make initdb verify that the executable and library files it's using
> are all from the same release it is.  I think this would eliminate an
> installation mistake that's practically reached FAQ status.
> 
> A sketch of a way to do this is:
> 
> 1. Add a --version switch to postgres or postmaster to print its version
> and exit.  Then initdb could check the executable's version against its
> own.  (Alternatively we could rely on pg_config, but at a minimum that
> would mean checking to make sure that pg_config is found in the same
> directory that postgres is in.  A direct check on the key executable
> seems a lot safer.)
> 
> 2. During "make install", generate a PGVERSION file and store it in the
> same directory that global.bki etc are stored in (the .../share install
> directory).  initdb could look for this to ensure that PGLIB is pointing
> to a compatible library directory.  Alternatively, add version info as
> a comment in the first line of global.bki.
> 
> I don't have time to pursue this right now, but maybe someone else would
> like to pick up on it.
> 
>             regards, tom lane
-- 
Larry Rosenman                      http://www.lerctr.org/~ler
Phone: +1 972-414-9812 (voice) Internet: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749