From: | Alvaro Herrera <alvherre(at)surnet(dot)cl> |
---|---|
To: | Josh Berkus <josh(at)agliodbs(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: pg_ctl inappropriately timing out? |
Date: | 2005-06-08 00:27:12 |
Message-ID: | 20050608002712.GF7407@surnet.cl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Tue, Jun 07, 2005 at 04:16:49PM -0700, Josh Berkus wrote:
> Folks:
>
> Issue: pg_ctl seems to be prematurely timing out.
> Version: 8.0.3
> Severity: Annoying
> Description:
> 1. Do an immense load on a database, like 2.5gb.
> 2. Right after the COPY finishes, send a pg_ctl -m fast stop to the server.
> 3. You will get:
> pg_ctl: postmaster does not shut down
>
> What Seems To Be Happening:
> When you call pg_ctl --stop, the WAL is still writing out to the database
> and postmaster won't shut down until it's done, which can take a couple
> minutes. In the meantime, pg_ctl is timing out and prematurely reporting
> failure.
>
> Resolution:
> Not sure, really. Is there some way for pg_ctl to intelligently detect
> this situation? To set a timeout value for pg_ctl via a command-line
> option?
Is there any way for pg_ctl to detect a "server is shutting down"
message? Not sure what it'd do with it though ...
--
Alvaro Herrera (<alvherre[a]surnet.cl>)
"Escucha y olvidarás; ve y recordarás; haz y entenderás" (Confucio)
From | Date | Subject | |
---|---|---|---|
Next Message | Nick Farrell | 2005-06-08 03:18:03 | BUG #1705: nextval being evaluated more than once |
Previous Message | Josh Berkus | 2005-06-07 23:16:49 | pg_ctl inappropriately timing out? |