Re: Windows Service Stops Responding

I tried again and got the same error "Connection attempt timed out.". Log file is empty until I restart service, than I get the following. This is the complete logfile.

2019-03-12 13:41:41.246 EDT [5948] LOG: received fast shutdown request
2019-03-12 13:41:41.287 EDT [5948] LOG: aborting any active transactions
2019-03-12 13:41:41.295 EDT [5948] LOG: background worker "logical replication launcher" (PID 19912) exited with exit code 1
2019-03-12 13:41:41.336 EDT [17468] LOG: shutting down
2019-03-12 13:41:41.533 EDT [5948] LOG: database system is shut down

Then a new log is opened when service restarts.

Thanks,

Michael Cassell

> On March 12, 2019 at 12:40 PM Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it> wrote:
>
> Il 08/03/2019 14:28, mcassell(at)trimind(dot)com mailto:mcassell(at)trimind(dot)com ha scritto:
>
> > >
> > I have installed PostgreSQL on two different Windows 10 systems and am having the same problem. The server work great when I first connect to it but if I disconnect client and come back a few hours or a day later I am unable to connect to the service with a timeout error. I have used both pgAdmin and DBeaver as clients.
> >
> > If I do a restart on the window service everything works fine again until I disconnect the client for a extended period. Can't find anywhere else this issue is discussed.
> >
> > Have used both the latest 11.2 release and an older 10.x release and both operate the same. Is this a known issue? Is there a solution?
> >
> >
> >
> >
> > >
> Have you checked logs (Event viewer or the folder /data/pg_log)?
>
> Cheers
>
> Moreno.-
>