connection problems
connection problems
От:
Rainer Leo <leo@workfile.de>
Дата:
Hello guys, I have trouble with our postgresql installation on a windows 10 machine. The application which is working with postgres spontanously looses connection to the db-server (which runs on the same machine). The next moment the connection is up again. The only interessting entry in the log is "verwende veraltete Statistiken anstatt aktueller, weil der Statistiksammelprozess nicht antwortet" which - I think - means "using older statitics, because the statistic collector does not answer" Does this have anything to do with the connection losses? Regards, Rainer Leo workfile Datenbankservice Bocksberg 20c D-22395 Hamburg Fon: 040.60 44 90 41 Fax: 040.34 92 61 08 www.workfile.de
Re: connection problems
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Rainer Leo writes: > I have trouble with our postgresql installation > on a windows 10 machine. The application which is > working with postgres spontanously looses connection > to the db-server (which runs on the same machine). > The next moment the connection is up again. > The only interessting entry in the log is > "verwende veraltete Statistiken anstatt aktueller, weil der > Statistiksammelprozess nicht antwortet" > which - I think - means > "using older statitics, because the statistic collector does > not answer" > Does this have anything to do with the connection losses? Not directly, but both behaviors could be triggered by transient loss of local TCP connectivity. I have no idea what would cause that, but hey, it's Windows :-(. Maybe something is trying to reset your network connections? regards, tom lane