From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | pg_ctl inappropriately timing out? |
Date: | 2005-06-07 23:16:49 |
Message-ID: | 200506071616.49757.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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?
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2005-06-08 00:27:12 | Re: pg_ctl inappropriately timing out? |
Previous Message | Frank van Vugt | 2005-06-07 16:37:44 | Re: BUG in temp tables involving a temp table not properly |