Re: Tables dissapearing

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: Kamil Srot <kamil(dot)srot(at)nlogy(dot)com>
Cc: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>, pgsql-general(at)postgresql(dot)org
Subject: Re: Tables dissapearing
Date: 2007-08-27 20:41:29
Message-ID: 20070827204129.GA30693@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)crankycanuck(dot)ca
The plural of anecdote is not data.
--Roger Brinner

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2007-08-27 20:48:19 Re: PostgreSQL vs Firebird feature comparison finished
Previous Message Erik Jones 2007-08-27 20:38:36 Re: Out of Memory - 8.2.4