Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id D4F04632982
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu,  8 Apr 2010 12:04:33 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 41175-02 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu,  8 Apr 2010 15:04:22 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-fx0-f225.google.com (mail-fx0-f225.google.com
	[209.85.220.225])
	by mail.postgresql.org (Postfix) with ESMTP id 9ED2C6327E6
	for <pgsql-admin@postgresql.org>; Thu,  8 Apr 2010 12:04:06 -0300 (ADT)
Received: by fxm25 with SMTP id 25so203fxm.3
	for <pgsql-admin@postgresql.org>; Thu, 08 Apr 2010 08:04:05 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:received:message-id:subject:from:to:cc:content-type;
	bh=LROI1eFkcs4ve68iXCfZ74iQPQfF/Z/xeJSxycywPPw=;
	b=OTkJggLLwBTB7obHwCFJYxzALGN8XTsi+IEW/3LR4FdxmSfNoJDbFGJOyH2uo6BhPu
	UW9RLkVo27TNRGQMCZfbMI4vATXbFtBe2y2sakAdLFw6JSH3Zy/syZu6gMB+gLbXy+Bk
	BoronRT7/kTBkWxI/6VvMdUBVxdcDHlJ3fRXc=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=RKEv82W9TmXMjm9zdeH8y65oXwAMDIktSEVVVEvWdcH8JabpuvYGDyZV6+KP3uKG+f
	LvCGV5aVuJrTVCRKOdNyHif6l9DntwhE7XkwmdFaPSLcagckOhdK2B3RWNk56Zl7NSVn
	5JyGYqSzVwHCOE4Sfg+A2JBJhY+Jk/tN2cBuI=
MIME-Version: 1.0
Received: by 10.103.228.19 with HTTP; Thu, 8 Apr 2010 08:03:14 -0700 (PDT)
In-Reply-To: <t2j407d949e1004080716iff21f326p4cd52c79ed204359@mail.gmail.com>
References: <g2o4b46b5f01004010610ib8625426uae6ee90ac1435ba1@mail.gmail.com>
	<t2u407d949e1004072159yaf03feffu1c18e03d75859bba@mail.gmail.com>
	<g2v4b46b5f01004080557j25cb26f1ic054f92b4f543baa@mail.gmail.com>
	<t2j407d949e1004080716iff21f326p4cd52c79ed204359@mail.gmail.com>
Date: Thu, 8 Apr 2010 11:03:14 -0400
Received: by 10.102.243.22 with SMTP id q22mr200946muh.9.1270738994245; Thu,
	08 Apr 2010 08:03:14 -0700 (PDT)
Message-ID: <j2y4b46b5f01004080803yc018a6cbqf38ceedd6933817d@mail.gmail.com>
Subject: Re: PD_ALL_VISIBLE flag warning
From: Jonathan Foy <thefoy@gmail.com>
To: Greg Stark <gsstark@mit.edu>
Cc: pgsql-admin@postgresql.org
Content-Type: multipart/alternative; boundary=001636417c495aaffd0483bafa81
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.098 tagged_above=-10 required=5 tests=AWL=0.500,
	BAYES_00=-2.599, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201004/89
X-Sequence-Number: 34183

--001636417c495aaffd0483bafa81
Content-Type: text/plain; charset=ISO-8859-1

On Thu, Apr 8, 2010 at 10:16 AM, Greg Stark <gsstark@mit.edu> wrote:

>
> 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.
>

Understood.  It's my current top priority.


>
> > 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)?
>

I have never turned off fsync.  Also, the server is showing an uptime of 281
days, and the postgres instance has been up since 2/21.


>
> What does the storage system on this server look like? Are they IDE or
> SCSI drives? Is there an LVM layer involved? etc.
>
> --
> greg
>

Storage is on an NFS mounted Fiber Netapp volume.

Let me know if you need more...

--001636417c495aaffd0483bafa81
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<br><div class=3D"gmail_quote">On Thu, Apr 8, 2010 at 10:16 AM, Greg Stark =
<span dir=3D"ltr">&lt;<a href=3D"mailto:gsstark@mit.edu">gsstark@mit.edu</a=
>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"margin: 0=
pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: =
1ex;">
<div class=3D"im">
<br>
</div>If you&#39;re on 8.1 it&#39;s important to be on the latest 8.1 -- th=
ere are<br>
at least 17 significant bugs that warranted bug-fix releases between<br>
8.1.3 and 8.1.20 including security bugs and data corruption bugs.<br></blo=
ckquote><div><br>Understood.=A0 It&#39;s my current top priority.<br>=A0</d=
iv><blockquote class=3D"gmail_quote" style=3D"margin: 0pt 0pt 0pt 0.8ex; bo=
rder-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">

<div class=3D"im"><br>
&gt; We never actually ran 8.4.0.=A0 We went straight from 8.3.3 to 8.4.1.=
=A0 I did a<br>
&gt; full dump/restore from the 8.3.3 database into the 8.4.1 database (usi=
ng the<br>
&gt; 8.4 pg_dump), partitioning as I went.<br>
<br>
</div>Ugh, then it sounds like there&#39;s a real as-yet unidentified probl=
em.<br>
<br>
The other thing to check before panicking is, has this server ever run<br>
with fsync off and crashed (either kernel panic or power failure)?<br></blo=
ckquote><div><br>I have never turned off fsync.=A0 Also, the server is show=
ing an uptime of 281 days, and the postgres instance has been up since 2/21=
.<br>
=A0</div><blockquote class=3D"gmail_quote" style=3D"margin: 0pt 0pt 0pt 0.8=
ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
What does the storage system on this server look like? Are they IDE or<br>
SCSI drives? Is there an LVM layer involved? etc.<br>
<br>
--<br>
<font color=3D"#888888">greg<br>
</font></blockquote></div><br>Storage is on an NFS mounted Fiber Netapp vol=
ume.<br><br>Let me know if you need more...<br>

--001636417c495aaffd0483bafa81--