Re: My Postgresql is inaccessible in Windows 8.1

On 08/03/2016 04:40 AM, Edson F. Lidorio wrote:
> Good Morning,
>
> Constantly my Postgresql is inaccessible, recording the following
> message in the log.
> I'm using Windows 8.1 and PostgreSQL 9.5
>
>
> 2016-08-02 17:05:59 BRT FATAL: the database system is starting up
> 2016-08-02 17:05:59 BRT LOG: database system was not properly shut
> down; automatic recovery in progress
> 2016-08-02 17:05:59 BRT LOG: invalid record length at 0/42C0148
> 2016-08-02 17:05:59 BRT LOG: redo is not required
> 2016-08-02 17:05:59 BRT LOG: MultiXact member wraparound protections
> are now enabled
> 2016-08-02 17:05:59 BRT LOG: database system is ready to accept
> connections
> 2016-08-02 17:06:00 BRT LOG: autovacuum launcher started
>
> 2016-08-03 08:18:44 BRT WARNING: worker took too long to start; canceled
> 2016-08-03 08:19:44 BRT WARNING: worker took too long to start; canceled
> 2016-08-03 08:20:44 BRT WARNING: worker took too long to start; canceled
> 2016-08-03 08:21:44 BRT WARNING: worker took too long to start; canceled
> 2016-08-03 08:22:44 BRT WARNING: worker took too long to start; canceled
> 2016-08-03 08:23:44 BRT WARNING: worker took too long to start; canceled
> 2016-08-03 08:24:44 BRT WARNING: worker took too long to start; canceled
> 2016-08-03 08:26:44 BRT WARNING: worker took too long to start; canceled
> 2016-08-03 08:28:44 BRT WARNING: worker took too long to start; canceled
> 2016-08-03 08:30:44 BRT WARNING: worker took too long to start; canceled
> 2016-08-03 08:31:45 BRT WARNING: worker took too long to start; canceled
>
>
> What can be wrong?

There is some sort of resource constraint preventing Postgres from
handling all its requests.

So:

Do you have any additional extensions/modules installed in Postgres?

What are the hardware specifications for the machine, memory, CPU,
storage,etc?

What is the work load on the Postgres server?

What does the system show for load during this time?

What do the system logs show?

>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com