From: Greg Stark <gsstark@mit.edu>
To: Jonathan Foy <thefoy@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: PD_ALL_VISIBLE flag warning
Date: Thu, 8 Apr 2010 15:16:41 +0100
Message-ID: <t2j407d949e1004080716iff21f326p4cd52c79ed204359@mail.gmail.com> (raw)
In-Reply-To: <g2v4b46b5f01004080557j25cb26f1ic054f92b4f543baa@mail.gmail.com>
References: <g2o4b46b5f01004010610ib8625426uae6ee90ac1435ba1@mail.gmail.com>
<t2u407d949e1004072159yaf03feffu1c18e03d75859bba@mail.gmail.com>
<g2v4b46b5f01004080557j25cb26f1ic054f92b4f543baa@mail.gmail.com>
On Thu, Apr 8, 2010 at 1:57 PM, Jonathan Foy <thefoy@gmail.com> wrote:
> Thanks for the reply...
>
> We have an unhealthy habit of not updating very often around here, one that
> I'm trying to fix. We run both 8.1 and 8.4, and we're testing the update to
> 8.1.20 this weekend....from 8.1.3. Across the board 8.4 update will take
> much more testing due to the typing issue. Other 8.4 updates will take place
> soon.
If you're on 8.1 it's important to be on the latest 8.1 -- there are
at least 17 significant bugs that warranted bug-fix releases between
8.1.3 and 8.1.20 including security bugs and data corruption bugs.
> We never actually ran 8.4.0. We went straight from 8.3.3 to 8.4.1. I did a
> full dump/restore from the 8.3.3 database into the 8.4.1 database (using the
> 8.4 pg_dump), partitioning as I went.
Ugh, then it sounds like there's a real as-yet unidentified problem.
The other thing to check before panicking is, has this server ever run
with fsync off and crashed (either kernel panic or power failure)?
What does the storage system on this server look like? Are they IDE or
SCSI drives? Is there an LVM layer involved? etc.
--
greg
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: gsstark@mit.edu, thefoy@gmail.com
Subject: Re: PD_ALL_VISIBLE flag warning
In-Reply-To: <t2j407d949e1004080716iff21f326p4cd52c79ed204359@mail.gmail.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