From: David F. Skoll <dfs@roaringpenguin.com>
To: pgsql-admin@postgresql.org
Subject: Re: archive falling behind
Date: Sat, 27 Apr 2013 16:51:17 -0400
Message-ID: <20130427165117.396a2952@shishi.roaringpenguin.com> (raw)
In-Reply-To: <E1UWBbJ-0001Lh-Eb@malur.postgresql.org>
References: <E1UWBbJ-0001Lh-Eb@malur.postgresql.org>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
From: German Becker <german.becker@gmail.com>
Subject: Re: archive falling behind
> Actually this seems like a very strange filesystem /hw problem. The
> wal segments keep "changing" even after I stoped the database and
> noone is supposly accesing it:
I've seen this before. It was bad RAM. I bet it's a hardware problem
for you as well... either bad RAM or a flaky disk.
In my case, I found it out because I got syntax errors in the
PostgreSQL logs: SELGCT was not a valid keyword. It turns out
that the flaky RAM was flipping bit 1 occasionally, so it would
randomly add or subtract 2 from a byte.
Regards,
David.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: dfs@roaringpenguin.com
Subject: Re: archive falling behind
In-Reply-To: <20130427165117.396a2952@shishi.roaringpenguin.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