On 25-Aug-08, at 10:43 AM, Alvaro Herrera wrote:
> Dave Cramer wrote:
>
>> Well, I go the extra mile and kill any remaing autovac procs
>>
>> Here are the logs
>>
>> 2008-08-25 04:00:01 EDT [32276] LOG: autovacuum launcher shutting
>> down
>> 2008-08-25 04:00:01 EDT [20526] LOG: autovacuum launcher started
>
> What did you SIGHUP, the launcher or postmaster? You need the latter.
> The launcher should exit automatically at that time.
No, I am HUP'ing the postmaster then subsequently killing any
autovacuums still around, which may be the problem.
I may be killing the launcher prematurely. I'll try again tonight.
Dave
>
>
> --
> Alvaro Herrera http://www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support