From: Greg Smith <greg@2ndquadrant.com>
To: bluestar43@gmail.com
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: Stumped by a version conflict.
Date: Sat, 17 Jul 2010 01:29:39 -0400
Message-ID: <4C413FC3.50005@2ndquadrant.com> (raw)
In-Reply-To: <AANLkTin6xg4Wt2Vay1FIcKCnT59rXnSSgaKPFrBleQ8H@mail.gmail.com>
References: <AANLkTimvYZbjG_g_TnSItb7vxzHxolXFMrB5cHmOmIfC@mail.gmail.com>
<AANLkTinEKjPBpHbUVqAC2I7cwLJBowIx18MehShgsi91@mail.gmail.com>
<AANLkTikRAspk3fhBwyiKGBKPkG8BWMpfFZS-DQ6LCsxL@mail.gmail.com>
<25504.1279322937@sss.pgh.pa.us>
<AANLkTilfpzhbaeZAZdEbw8nj0IERKAsBUUASm5usgurX@mail.gmail.com>
<AANLkTiniwbSrCHiXF2pRrq2aZ6HdcrT1efH-b_oK20TO@mail.gmail.com>
<AANLkTin6xg4Wt2Vay1FIcKCnT59rXnSSgaKPFrBleQ8H@mail.gmail.com>
Patric Michael wrote:
> /usr/share/pgsql/postgresql.conf.sample
> /var/lib/pgsql/data/postgresql.conf
> /home/archives/db/postgresql.conf
> /home/postgres/data/postgresql.conf
>
> The first line is the --datadir as reported by pg_configure --configure
> The second line is the 7.4 data dir according to its PG_VERSION
> The third line was a directory backup I made when I upgraded to 8.1
> The fourth line is the most recently updated database according to the
> time stamps. (three days ago)
Is there a PG_VERSION suggesting the 4th one is an 8.1 system? It's
completely possible you manually started the database cluster like this:
pg_ctl start -D /home/postgres/data
And that's the one that's been running for the last two years. The
default system PostgreSQL install is going to point at
/var/lib/pgsql/data by default and try to start whatever database is
there, which is the 7.4 one and therefore won't start with your current
binaries.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us
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: greg@2ndquadrant.com, bluestar43@gmail.com, scott.marlowe@gmail.com, tgl@sss.pgh.pa.us
Subject: Re: Stumped by a version conflict.
In-Reply-To: <4C413FC3.50005@2ndquadrant.com>
* 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