| From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: can't stop autovacuum by HUP'ing the server |
| Date: | 2008-08-25 17:07:20 |
| Message-ID: | 8988FC15-3886-4239-9F80-62A81F11F98C@fastcrypt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2008-08-25 17:09:56 | Re: initdb change |
| Previous Message | Joshua Drake | 2008-08-25 16:54:26 | Re: initdb change |