<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Hi Michael,<br>
</div>
<div class="moz-cite-prefix"> please don't top-post.</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">Il 12/03/2019 18:43,
<a class="moz-txt-link-abbreviated" href="mailto:mcassell(at)trimind(dot)com">mcassell(at)trimind(dot)com</a> ha scritto:<br>
</div>
<blockquote type="cite"
cite="mid:628893445(dot)586586(dot)1552412633163(at)email(dot)ionos(dot)com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<meta charset="UTF-8">
<p style="font-family: verdana, geneva;">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.</p>
<p style="font-family: verdana, geneva;"><b>2019-03-12
13:41:41.246 EDT [5948] LOG: received fast shutdown request</b><br>
2019-03-12 13:41:41.287 EDT [5948] LOG: aborting any active
transactions<br>
2019-03-12 13:41:41.295 EDT [5948] LOG: background worker
"logical replication launcher" (PID 19912) exited with exit code
1<br>
2019-03-12 13:41:41.336 EDT [17468] LOG: shutting down<br>
2019-03-12 13:41:41.533 EDT [5948] LOG: database system is shut
down</p>
</blockquote>
<p>Since I've never heard of this strange behaviour among my
customers (we have some hundred postgres 10.x windows 7/8/10
installations), I'll try to guess and hope to find some
interesting element to investigate.<br>
</p>
<p>Some points:<br>
</p>
<p>1. When did you start the server? it's missing of the initial,
server startup, part... something stating at least that the system
is starting, even restarting from a not-proper shutdown and, at
last, "the database system is ready to accept connections". I
would say that the first part should be taken from yesterday's
file (or the file from the day before the one the file's
referencing), as if you started server yesterday (or back in the
past) and stopped today at 13.41 EDT. The log line I set in bold
states that "something" has requested the system to shut down
(Windows restart, service stop, even antivirus system (but that
has also eaten your bins, so it won't restart), something else),
but if you <b>just</b> started the server it can't be the first
line in log file.<br>
</p>
<p>2. From where are you connecting? From a remote (not localhost)
client or the server itself?<br>
</p>
<p>3. Did you alter config files? Default listening port is 5432,
but if you install more than one cluster you'll have to change
them.<br>
</p>
<p>3. Did you take a look at the Event Viewer? Is there any error?<br>
</p>
<p>4. Have you thought to reinstall?</p>
<p>Cheers</p>
<p>Moreno.-<br>
</p>
<p><br>
</p>
<br>
<blockquote type="cite"
cite="mid:628893445(dot)586586(dot)1552412633163(at)email(dot)ionos(dot)com">
<p style="font-family: verdana, geneva;">Then a new log is opened
when service restarts.<br>
</p>
</blockquote>
That's the intended behavior on windows<br>
<blockquote type="cite"
cite="mid:628893445(dot)586586(dot)1552412633163(at)email(dot)ionos(dot)com">
<p style="font-family: verdana, geneva;">Thanks, </p>
<div class="io-ox-signature">
<p><strong>Michael Cassell<br>
</strong><br>
<strong></strong><span style="font-size: 8pt;"></span></p>
</div>
<blockquote type="cite">On March 12, 2019 at 12:40 PM Moreno
Andreo <a class="moz-txt-link-rfc2396E" href="mailto:moreno(dot)andreo(at)evolu-s(dot)it"><moreno(dot)andreo(at)evolu-s(dot)it></a> wrote: <br>
<br>
<div class="ox-a50eb2e849-moz-cite-prefix">Il 08/03/2019 14:28,
<a class="ox-a50eb2e849-moz-txt-link-abbreviated"
href="mailto:mcassell(at)trimind(dot)com" moz-do-not-send="true">mcassell(at)trimind(dot)com</a>
ha scritto: <br>
</div>
<blockquote type="cite">
<p style="font-family: verdana, geneva;">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.</p>
<p style="font-family: verdana, geneva;">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. </p>
<p style="font-family: verdana, geneva;">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?</p>
<div class="ox-a50eb2e849-io-ox-signature">
<p> <br>
</p>
<br>
</div>
</blockquote>
<p>Have you checked logs (Event viewer or the folder
/data/pg_log)?</p>
<p>Cheers</p>
<p>Moreno.-<br>
</p>
</blockquote>
<p style="font-family: verdana,geneva;" class="default-style"><br>
</p>
</blockquote>
<p><br>
</p>
</body>
</html>