| From: | Sergey Ushakov <sergey(at)verify(dot)kg> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Bug report for Postgresql 8.0-beta1 for WINDOWS. |
| Date: | 2004-10-31 07:00:34 |
| Message-ID: | 7702970.20041031120034@verify.kg |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Hello pgsql-bugs,
The bug description is as follows:
Then server with running postmaster unexpectedly shut down, server
cannot be started next time.
I've found that manual starting of that service also unsuccessful.
I investigated the bug, and found that the .pid file exists at
PGDATA folder. So I decided to delete that file, and try to start
service. It works!
Probably pg_ctl looks for .pid file, and if it exists it supposes
that the service is already started. In fact it's wrong.
How to repeat the bug:
1. Stop service
2. Create postmaster.pid at PGDATA
3. Try to start service. It will refuse.
Suggested solution: Change service detection logic. May be not just
looking for the pid file, but parsing it and finding the service
process itself and testing it for existance.
Sorry if it is already fixed in new version.
--
Best regards,
Sergey mailto:sergey(at)verify(dot)kg
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Dick | 2004-10-31 08:22:10 | locale related problem with debian |
| Previous Message | Matthew "Cheetah" Gabeler-Lee | 2004-10-31 04:54:20 | date_trunc problems crossing DST border |