Alvaro Herrera <alvherre@commandprompt.com> writes:
> Josh Berkus wrote:
>> Right. What I'm saying is that if it *didn't* require a sighup, then
>> users could cronjob starting and stopping Autovac themselves.
> Hmm, I'm not sure I understand what you're suggesting. Maybe what you
> want is that we have a SQL-accesible function that sends SIGHUP to the
> postmaster?
Like, say, pg_reload_conf()? But actually a cron job would almost
certainly find it more pleasant to use pg_ctl reload and never bother
with a database connection at all.
regards, tom lane