Thread: BUG #13990: Postgres shutting down automatically

BUG #13990: Postgres shutting down automatically

From
syspegasus@gmail.com
Date:
The following bug has been logged on the website:

Bug reference:      13990
Logged by:          Talita
Email address:      syspegasus@gmail.com
PostgreSQL version: 9.4.5
Operating system:   Windows 7
Description:

Hi, I'm having problem with the postgres service.. randomly stop to
working.. And to work again I have to wait a time, or restart the
computer(and sometimes don't work too).. I'm using Windows 7.

In the log appears:
2016-02-25 08:54:52 BRT WARNING:  worker took too long to start; canceled

I tried to unistall and install again, but the problem persist. I don't know
more what to do..

Please help me!

Re: BUG #13990: Postgres shutting down automatically

From
Michael Paquier
Date:
On Thu, Feb 25, 2016 at 9:10 PM,  <syspegasus@gmail.com> wrote:
> The following bug has been logged on the website:
>
> Bug reference:      13990
> Logged by:          Talita
> Email address:      syspegasus@gmail.com
> PostgreSQL version: 9.4.5
> Operating system:   Windows 7
> Description:
>
> Hi, I'm having problem with the postgres service.. randomly stop to
> working.. And to work again I have to wait a time, or restart the
> computer(and sometimes don't work too).. I'm using Windows 7.
>
> In the log appears:
> 2016-02-25 08:54:52 BRT WARNING:  worker took too long to start; canceled
>
> I tried to unistall and install again, but the problem persist. I don't know
> more what to do..

There is no bug here, the error message you are seeing is a sign that
this node is CPU-starved and slow to start up an autovacuum process:
this prevents a worker to start should another one be in starting
state or failed to start.
--
Michael