DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:sender:in-reply-to:references:from:date
	:x-google-sender-auth:message-id:subject:to:cc:content-type
	:content-transfer-encoding;
	b=XH/4K7RvZ4ftfd4Zg3+I74Le9kBFPE+Fk1cZmdjh5aNgfL9NjfWgbmOccLRYTELsIU
	qKfBFZ6cR4a8CFsl9OAHP9zxmNEEoICDXjYVv3u8zIcMQYw2RNzSDp4oPO55uEw5rmez
	908fqjA2RKjC5pfGo4csdmO7tEjLGCkG08Cu8=
MIME-Version: 1.0
In-Reply-To: <g2v4b46b5f01004080557j25cb26f1ic054f92b4f543baa@mail.gmail.com>
References: <g2o4b46b5f01004010610ib8625426uae6ee90ac1435ba1@mail.gmail.com>
	<t2u407d949e1004072159yaf03feffu1c18e03d75859bba@mail.gmail.com>
	<g2v4b46b5f01004080557j25cb26f1ic054f92b4f543baa@mail.gmail.com>
From: Greg Stark <gsstark@mit.edu>
Date: Thu, 8 Apr 2010 15:16:41 +0100
Message-ID: <t2j407d949e1004080716iff21f326p4cd52c79ed204359@mail.gmail.com>
Subject: Re: PD_ALL_VISIBLE flag warning
To: Jonathan Foy <thefoy@gmail.com>
Cc: pgsql-admin@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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 th=
at
> 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.=A0 Across the board 8.4 update will ta=
ke
> much more testing due to the typing issue. Other 8.4 updates will take pl=
ace
> 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.=A0 We went straight from 8.3.3 to 8.4.1.=A0 =
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.


--=20
greg