Re: Corrupted sequences - Mailing list pgsql-general

From Francisco Reyes
Subject Re: Corrupted sequences
Date
Msg-id 20030314152922.F31492-100000@zoraida.natserv.net
Whole thread Raw
In response to Re: Corrupted sequences  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
On Fri, 14 Mar 2003, scott.marlowe wrote:

> > Got 2 corrupted sequences, that I have discovered so far, and fixed them
> > with 'setval'. Is there a way to check all sequences in a database?
> > Something simmilar to reindex but for sequences?
> >
> >
> > Running 7.2.4 (at my ISP so don't have a choice there..)
>
> You need to demand that your service providers test their hardware.  When
> things randomly get corrupted in Postgresql it is about 95% of the time or
> more that you have either a bad disk or bad memory.  Postgresql is good,
> but it can't overcome broken hardware.



:-)
Ok I will tell Marc. (using hub.org)


pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: Corrupted sequences
Next
From: Dennis Gearon
Date:
Subject: Re: The folding of unquoted names to lower case in PostgreSQL