Re: Data now showing up - Mailing list pgsql-admin

From Tom Lane
Subject Re: Data now showing up
Date
Msg-id 11403.980730852@sss.pgh.pa.us
Whole thread Raw
In response to Data now showing up  (Ken Kinder <ken@kenkinder.com>)
Responses Re: Data now showing up  (Ken Kinder <ken@kenkinder.com>)
List pgsql-admin
Ken Kinder <ken@kenkinder.com> writes:
> After a few months of running, I have a database that consistantly stops
> taking inserts. It isn't a high-use database, doesn't give an error, and
> is really very odd. The table has one column (text) and never more than
> a dozen rows.

> After a while, it just stops inserting. You type an insert in psql, it
> acts like it did it, you select from the data, and it's simply not there.
> If I dump and rebuild the database, the problem is solved.

More details please?  We would certainly have heard of this before if
it were a generic problem.

            regards, tom lane

pgsql-admin by date:

Previous
From: Jie Liang
Date:
Subject: Re: Admin tutorials?
Next
From: Ken Kinder
Date:
Subject: Re: Data now showing up