Re: Data now showing up

From: Ken Kinder <ken(at)kenkinder(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Data now showing up
Date: 2001-01-29 03:45:00
Message-ID: 20010128204500.A29983@kenkinder.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Someone suggested upgrading to 0.0.3, although I didn't see anything about
this problem in the history... I did.

What kind of details do we need here? It's a one-column, one-table database.
About as simple as it gets. This is on Debian/GNU Linux although it's not
the packaged Postgres, I installed it myself.

On Sun, Jan 28, 2001 at 08:14:12PM -0500, Tom Lane wrote:
> Ken Kinder <ken(at)kenkinder(dot)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

--
Ken Kinder
www.kenkinder.com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2001-01-29 03:55:50 Re: Data now showing up
Previous Message Tom Lane 2001-01-29 01:14:12 Re: Data now showing up