Re: Tables dissapearing - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Tables dissapearing
Date
Msg-id 20070827204129.GA30693@phlogiston.dyndns.org
Whole thread Raw
In response to Re: Tables dissapearing  (Kamil Srot <kamil.srot@nlogy.com>)
Responses Re: Tables dissapearing
List pgsql-general
On Mon, Aug 27, 2007 at 10:31:11PM +0200, Kamil Srot wrote:
> The script is very simple one:

Well, I don't see anything obvious, but. . .

> I can easily rewrite it to use the vacuumdb command, but I doubt it'll
> make any difference.

The point is that you don't have to rewrite it.  Just run "vacuumdb
-a" and it vacuums _all_ databases.

> Is there a way how to find out the problem is here? I scanned the log
> output of pgsql for wrap around but didn't found aby recent relevant
> entries... I'm pretty sure, I miss something stupid :-(

Are you quite sure you're getting all your logs where you think you
are?

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
The plural of anecdote is not data.
        --Roger Brinner

pgsql-general by date:

Previous
From: Erik Jones
Date:
Subject: Re: Out of Memory - 8.2.4
Next
From: Dizzy
Date:
Subject: pgsql Windows installer fixed registry key