Problem during Windows service start - Mailing list pgsql-hackers

From Sakai, Teppei
Subject Problem during Windows service start
Date
Msg-id 99C4246E73ED1B478BBB9671718426203E37F485@G01JPEXMBKW03
Whole thread Raw
Responses Re: Problem during Windows service start
List pgsql-hackers
Hi,

This is my first posting to the mailing list.

Currently our customer uses PostgreSQL 9.5 and hits problem during Windows service start.
The Windows service status of the instance is different from actual status.

We got the following situation.
1. Register service with 'pg_ctl register -N "PostgreSQL" -U postgres -P xxxx -D D:\data\inst1 -w'
2. Start the instance from the Windows service screen.
3. After 60 seconds, the startup process fails with a timeout.
   Because crash recovery takes a lot of times.

Then, the service status of the instance become "STOPPED",
but the instance was running.
It cannot be stopped from the Windows service screen (it can be stopped only with pg_ctl).

PostgreSQL version : 9.5.12
Operating system : Windows Server 2012 R2

I think this is a bug.
I think it has not been fixed in the latest version, is my understanding correct?
If it is correct, I will fix it.

Regards,
SAKAI Teppei



pgsql-hackers by date:

Previous
From: Etsuro Fujita
Date:
Subject: Re: Expression errors with "FOR UPDATE" and postgres_fdw with partitionwise join enabled.
Next
From: "Daniel Verite"
Date:
Subject: Re: [HACKERS] Can ICU be used for a database's default sort order?