Re: Tables dissapearing

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