Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
> > 1. Reset max_standby_delay = 0 in postgresql.conf
> > 2. pg_ctl reload
> > 3. Create a trigger file
> As far as I read the HS code, SIGHUP is not checked while a recovery
> is waiting for queries :( So pg_ctl reload would have no effect on
> the conflicting queries.
> Independently from the problem I raised, I think that we should call
> HandleStartupProcInterrupts() in that sleep loop.
Hmmm, if reload doesn't work, can we write a query like below?
NTT Open Source Software Center
In response to
pgsql-hackers by date
|Next:||From: Robert Haas||Date: 2010-06-10 01:27:09|
|Subject: Re: Invalid YAML output from EXPLAIN|
|Previous:||From: David Gardner||Date: 2010-06-10 00:55:36|
|Subject: 'create or replace function' no longer allows parameters|