From: | Kamil Srot <kamil(dot)srot(at)nlogy(dot)com> |
---|---|
To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Tables dissapearing |
Date: | 2007-08-27 17:57:15 |
Message-ID: | 46D3107B.5000606@nlogy.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Alvaro Herrera wrote:
> Kamil Srot wrote:
>
>> Martijn van Oosterhout wrote:
>>
>>> On Mon, Aug 27, 2007 at 06:57:54PM +0200, Kamil Srot wrote:
>>>
>>>
>>>> Correct...the script does echo "vacuum full;" | $PGDIR/bin/psql -U
>>>> postgres $db for each database...
>>>> Hope it's correct?
>>>>
>>>>
>>> Well, I'd drop the "full" part, it tends to bloat indexes. Also, did
>>> you check it was actually completing (no errors)?
>>>
>>>
>> Yes, it completes w/o errors... just VACUUM as output...
>> OK, I'll drop the full part and do it less often...
>>
>
> What user is doing it? Is it a superuser? If it's not, then there's
> your problem.
>
>
It's user postgres... the vacuum completes correctly...
Thank you,
--
Kamil
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2007-08-27 18:18:49 | Re: PostgreSQL vs Firebird feature comparison finished |
Previous Message | Alvaro Herrera | 2007-08-27 17:52:44 | Re: Tables dissapearing |