The following bug has been logged online: Bug reference: 4234 Logged by: Lawrence Cohan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: Linux 4.1.1 Description: VACUUM dies in without error in a PGAgent job Details:
We are using PGAgent to do the maintenance and I noticed from the server status that there's no VACCUM running against the database however the job still says "Running" and the value is still "r" on the job step from pgagent.pga_jobsteplog.jslstatus The job has three steps as described below: 1_Analyze_db that does analyze verbose; 2_Vaccum_db that does vacuum verbose: 3_Analyze_db that does analyze verbose; the second step is set to "Ignore" if Fail so the analyze will kick off anyway. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs