| From: | Kamil Srot <kamil(dot)srot(at)nlogy(dot)com> |
|---|---|
| To: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Tables dissapearing |
| Date: | 2007-08-27 20:50:53 |
| Message-ID: | 46D3392C.3040404@nlogy.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Andrew Sullivan wrote:
>> 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.
>
>
Oh, I have it now! It takes some time, but at the end, I'll understand :-D
Sure, it's much better than coding some scripts etc. I already used it
in my script...
>> 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?
>
Yes, the log is correct... I can see statement errors I did selecting
from system tables few hours ago...
I have default debug level... should I increase it?
I really need to make sure, the next problem (if it's necessary to let
it happen) will be the last one... :-(
Thank you,
--
Kamil
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-08-27 21:08:22 | Re: Tables dissapearing |
| Previous Message | Matthew Schumacher | 2007-08-27 20:48:34 | Is this a bug? Insert float into int column inserts rounded value instead of error. |