Re: [ADMIN] VACUUM Error?

2006-03-09 Thread Fabrice . Sznajderman
Victory!! The Vacuum works well !!! Thanks for your help!!! cheers Fabrice SZNAJDERMAN DSI : Application Rendez-Vous - CCM tel : 01 41 49 60 77 Fabrice Sznajderman/Solutions/FR/[EMAIL PROTECTED] "Andy Shellam" <[EMAIL PROTECTED]> Envoyé par : [EMAIL PROTECTED]

Re: [ADMIN] VACUUM Error?

2006-03-08 Thread Fabrice . Sznajderman
Hello Andy, I tried last night, the way which you suggested me.. I looked at the log file of the vacuum process... and there is no error.. I tried to run the vacuum without the -f option , last night. So to the next night, I will add the -f option and will run again the vacuum process. Thanks a

Re: [ADMIN] VACUUM Error?

2006-03-07 Thread Fabrice . Sznajderman
Hello Andy, Thanks a lot for your answer, I'll retry with this new information! I will give you feedback when I would had made this new way ! Best regard Fabrice "Andy Shellam" <[EMAIL PROTECTED]> Envoyé par : [EMAIL PROTECTED] 07/03/2006 16:34 Veuillez répondre à <[EMAIL PROTECTED]

Re: [ADMIN] VACUUM Error?

2006-03-07 Thread Fabrice . Sznajderman
Hello Tom Lane, Thank you very much for your answer!! My PG version is older than 7.3 , I know it so old and so much old.. but I can't update this version... :-(( However, could you explain me how I can close  open transaction? Thanks in advance!! best regard Fabrice Tom Lane <[EMAIL P

[ADMIN] VACUUM Error?

2006-03-07 Thread Fabrice . Sznajderman
Hello, I executed a Vacuum on my Postgres database. You can see the command line : /vacuumdb -f -z -v -d ccm > /tmp/vacuum.txt 2> /tmp/vacuumError.txt  I used  performed the vacuum. But I had error :"ERROR:  Parent tuple was not found vacuumdb: vacuum  ccm failed"  each time I am executed the