| 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: | Whole Thread | Raw Message | 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
| 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 |