Re: archive falling behind

Поиск
Список
Период
Сортировка
От German Becker
Тема Re: archive falling behind
Дата
Msg-id CALyjCLs4F9CbaS=5MUbNXmWmzRD4kgdUxoP1CZu3srBcJu3O3g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: archive falling behind  ("David F. Skoll" <dfs@roaringpenguin.com>)
Список pgsql-admin
David, You were absolutly right. I broght the server down and it was a faulty RAM indeed.Thank you very much for your help!


On Sat, Apr 27, 2013 at 5:51 PM, David F. Skoll <dfs@roaringpenguin.com> wrote:

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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Rodrigo Barboza
Дата:
Сообщение: Delete xlog files
Следующее
От: German Becker
Дата:
Сообщение: Point in time recovery + replication