Vista - immer mehr postgres.exe im Taskmanager

Hallo,

Ich nutze die Version ‘postgresql-8.4.4-1-windows.exe’ von PostgreSQL
Windows Vista 32Bit Home Premium SP2
Intel Core 2Duo CPU 2.00GHZ
mit 4GM RAM.

PostgreSQL wird bei mir genutzt um Fertigungsdaten in eine Datenbank zu schreiben.
Dabei fällt mir immer wieder auf, dass ich mich irgendwann, nach einigen Stunden Arbeit mit der Datenbank, nicht mehr über PGAdmin III auf meinen lokalen Server verbinden kann. --> Ein Blick in den Taskmanager verrt mir immer, dass es über 100 laufende PRozesse ‘postgres.exe’ gibt.
Jedes mal kommt max_connections ans Limit…

Gestern habe ich mal einen Test gemacht und möchte euch die Ergebnisse hier mitteilen:

Ich habe ein (AutoIt-)Tool geschrieben, welches mir eine Prozess-Liste mit PIDs von einem Bestimmten Prozess erstellt.
AutoIt-Code:

HotKeySet("{ESC}","ende")

Func ende()
    Exit
EndFunc

Global $pid
Global $string
Global $i = 1

While 1
    $string = ""
    $pid = ProcessList ("postgres.exe")
    For $i = 1 To $pid[0][0]
        $string = $string & $pid[$i][1] & ","
    Next
    $string = StringTrimRight($string, 1)
    FileWriteLine(@ScriptDir & "\pid.txt", @YEAR & "-" & @MON & "-" & @MDAY & " " & @HOUR & ":" & @MIN & ":" & @SEC & ": " & $string )
    Sleep(120000)
WEnd

Dieses Tool Schreibt alle 2 Minuten eine Zeile mit allen PIDs vom Prozess “postgres.exe” in eine Textdatei.

So sah das Textfile gestern während der Arbeit aus:

2010-07-06 16:07:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620
2010-07-06 16:09:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596
2010-07-06 16:11:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316
2010-07-06 16:13:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396
2010-07-06 16:15:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396
2010-07-06 16:17:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396
2010-07-06 16:19:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680
2010-07-06 16:21:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680
2010-07-06 16:23:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680
2010-07-06 16:25:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680
2010-07-06 16:27:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680
2010-07-06 16:29:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424
2010-07-06 16:31:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424
2010-07-06 16:33:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424
2010-07-06 16:35:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424
2010-07-06 16:37:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424
2010-07-06 16:39:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224
2010-07-06 16:41:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224
2010-07-06 16:43:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224
2010-07-06 16:45:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224
2010-07-06 16:47:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224
2010-07-06 16:49:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856
2010-07-06 16:51:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856
2010-07-06 16:53:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856
2010-07-06 16:55:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856
2010-07-06 16:57:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964
2010-07-06 16:59:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964
2010-07-06 17:01:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964
2010-07-06 17:03:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964
2010-07-06 17:05:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964
2010-07-06 17:07:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964
2010-07-06 17:09:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964
2010-07-06 17:11:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964
2010-07-06 17:13:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964
2010-07-06 17:15:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964
2010-07-06 17:17:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964
2010-07-06 17:19:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640
2010-07-06 17:21:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684
2010-07-06 17:23:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684
2010-07-06 17:25:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684
2010-07-06 17:27:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684
2010-07-06 17:29:46:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684
2010-07-06 17:31:47:  3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684

2010-07-06 17:33:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588
2010-07-06 17:35:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588
2010-07-06 17:37:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588
2010-07-06 17:39:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588
2010-07-06 17:41:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588
2010-07-06 17:43:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324
2010-07-06 17:45:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324
2010-07-06 17:47:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868
2010-07-06 17:49:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868
2010-07-06 17:51:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868
2010-07-06 17:53:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868
2010-07-06 17:55:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868
2010-07-06 17:57:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868
2010-07-06 17:59:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868
2010-07-06 18:01:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684
2010-07-06 18:03:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684
2010-07-06 18:05:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684
2010-07-06 18:07:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684,4820,5848
2010-07-06 18:09:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684,4820,5848
2010-07-06 18:11:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684,4820,5848
2010-07-06 18:13:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684,4820,5848
2010-07-06 18:15:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684,4820,5848
2010-07-06 18:17:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684,4820,5848
2010-07-06 18:19:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684,4820,5848
2010-07-06 18:21:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684,4820,5848,5416,5676
2010-07-06 18:23:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684,4820,5848,5416,5676
2010-07-06 18:25:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684,4820,5848,5416,5676
2010-07-06 18:27:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684,4820,5848,5416,5676
2010-07-06 18:29:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920,4824
2010-07-06 18:31:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920
2010-07-06 18:33:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920,4672
2010-07-06 18:35:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920,4672
2010-07-06 18:37:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920,4672,4944
2010-07-06 18:39:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920,4672,4944
2010-07-06 18:41:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920,4672,4944
2010-07-06 18:43:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920,4672,4944
2010-07-06 18:45:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920,4672,4944
2010-07-06 18:47:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920,4672,4944
2010-07-06 19:54:52: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920,4672,4944,5620,1432
2010-07-06 19:56:52: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920,4672,4944,5620
2010-07-06 19:58:52: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920,4672,4944,5620
2010-07-06 20:00:52: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044,5744,1068,5540,1632,560,4480,5564,384,600,5940,4568,4620,4596,4316,5396,4680,424,5224,4856,5964,4640,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920,4672,4944,5620
2010-07-06 20:02:52:

Abends dann habe ich mein Laptop neu gestartet, dann habe ich keinen Zugriff auf keine Datenbank gemacht und habe mein Tool wieder einige Stunden laufen lassen:

2010-07-06 20:23:01: 3196,3380,3616,3624,3632,3640
     2010-07-06 20:25:01: 3196,3380,3616,3624,3632,3640
     2010-07-06 20:27:01: 3196,3380,3616,3624,3632,3640
     2010-07-06 20:29:01: 3196,3380,3616,3624,3632,3640
     2010-07-06 20:31:01: 3196,3380,3616,3624,3632,3640
     2010-07-06 20:33:01: 3196,3380,3616,3624,3632,3640
     2010-07-06 20:38:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 20:40:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 20:42:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 20:44:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 20:46:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 20:48:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 20:50:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 20:52:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 20:54:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 20:56:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 20:58:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:00:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:02:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:04:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:06:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:08:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:10:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:12:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:14:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:16:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:18:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:20:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:22:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:24:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:26:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:28:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:30:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:32:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:34:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:36:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:38:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:40:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:42:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:44:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:46:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:48:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:50:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:52:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:54:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:56:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 21:58:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:00:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:02:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:04:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:06:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:08:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:10:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:12:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:14:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:16:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:18:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:20:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:22:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:24:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:26:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:28:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:30:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:32:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:34:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:36:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:38:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:40:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:42:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:44:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:46:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:48:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:50:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:52:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:54:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:56:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 22:58:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 23:00:53: 3196,3380,3616,3624,3632,3640
     2010-07-06 23:02:54: 3196,3380,3616,3624,3632,3640
     2010-07-06 23:04:54: 3196,3380,3616,3624,3632,3640
     2010-07-06 23:06:54: 3196,3380,3616,3624,3632,3640
     2010-07-06 23:08:54: 3196,3380,3616,3624,3632,3640
     2010-07-06 23:10:54: 3196,3380,3616,3624,3632,3640
     2010-07-06 23:12:54: 3196,3380,3616,3624,3632,3640

Man sieht also: Wenn man postgreSQL nicht benutzt, kommt der Fehler auch nicht…

Nun habe ich noch getestet, ob es an der Software liegt, die die Fertigungsdaten in die Datenbank schreibt. Das habe ich getestet, indem ich nicht unser Fertigungsprogramm, sondern nur einmal PGAdmin III gestartet habe und folgendes gemacht habe:

PG Admin III:
(Zugriff auf leere Datenbank: select * from t_value)
(Zugriff auf Datenbank mit wenigen Datensätzen: select * from t_value)
(Zugriff auf leere Datenbank: select * from t_value)

nachdem ich mit PGAdmin III auf 3 der Datenbanken zugegriffen habe:

2010-07-06 23:14:54:  3196,3380,3616,3624,3632,3640,1652,2172,2524,3152,5892
      2010-07-06 23:16:54: 3196,3380,3616,3624,3632,3640
      2010-07-06 23:18:54: 3196,3380,3616,3624,3632,3640
      2010-07-06 23:20:54: 3196,3380,3616,3624,3632,3640
      2010-07-06 23:22:54: 3196,3380,3616,3624,3632,3640
      2010-07-06 23:24:54: 3196,3380,3616,3624,3632,3640
      2010-07-06 23:26:54: 3196,3380,3616,3624,3632,3640,5316
      2010-07-06 23:28:54: 3196,3380,3616,3624,3632,3640,5316,4448
      2010-07-06 23:30:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816
      2010-07-06 23:32:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044
      2010-07-06 23:34:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280
      2010-07-06 23:36:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280
      2010-07-06 23:38:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280
      2010-07-06 23:40:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408
      2010-07-06 23:42:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408
      2010-07-06 23:44:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628
      2010-07-06 23:46:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628
      2010-07-06 23:48:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628
      2010-07-06 23:50:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628
      2010-07-06 23:54:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628
      2010-07-06 23:56:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628
      2010-07-06 23:58:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628
      2010-07-07 00:00:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628
      2010-07-07 00:02:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628
      2010-07-07 00:04:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956
      2010-07-07 00:06:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956
      2010-07-07 00:08:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092
      2010-07-07 00:10:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092
      2010-07-07 00:12:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092
      2010-07-07 00:14:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092
      2010-07-07 00:16:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092
      2010-07-07 00:18:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,4688
      2010-07-07 00:20:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092
      2010-07-07 00:22:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092
      2010-07-07 00:24:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092
      2010-07-07 00:26:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092
      2010-07-07 00:28:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092
      2010-07-07 00:30:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092
      2010-07-07 00:32:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092
      2010-07-07 00:34:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092
      2010-07-07 00:36:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092
      2010-07-07 00:38:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092
      2010-07-07 00:40:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092
      2010-07-07 00:42:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092
      2010-07-07 00:44:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092
      2010-07-07 00:46:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292
      2010-07-07 00:48:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292
      2010-07-07 00:50:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748
      2010-07-07 00:52:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748
      2010-07-07 00:54:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748
      2010-07-07 00:56:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748
      2010-07-07 00:58:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748
      2010-07-07 01:00:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748
      2010-07-07 01:02:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748
      2010-07-07 01:04:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788
      2010-07-07 01:06:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788
      2010-07-07 01:08:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788
      2010-07-07 01:10:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788
      2010-07-07 01:12:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788
      2010-07-07 01:14:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788
      2010-07-07 01:16:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160
      2010-07-07 01:18:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160
      2010-07-07 01:20:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160
      2010-07-07 01:22:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160
      2010-07-07 01:24:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776
      2010-07-07 01:26:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776
      2010-07-07 01:28:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776
      2010-07-07 01:30:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776
      2010-07-07 01:32:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776
      2010-07-07 01:34:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776
      2010-07-07 01:36:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,4744
      2010-07-07 01:38:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776
      2010-07-07 01:40:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016
      2010-07-07 01:42:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016
      2010-07-07 01:44:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016
      2010-07-07 01:46:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016
      2010-07-07 01:48:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016
      2010-07-07 01:50:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016
      2010-07-07 01:52:54:  3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016

2010-07-07 01:54:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308
2010-07-07 01:56:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040
2010-07-07 01:58:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660
2010-07-07 02:00:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660
2010-07-07 02:02:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740
2010-07-07 02:04:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740
2010-07-07 02:06:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740
2010-07-07 02:08:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740
2010-07-07 02:10:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740
2010-07-07 02:12:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252
2010-07-07 02:14:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252
2010-07-07 02:16:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252
2010-07-07 02:18:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252
2010-07-07 02:20:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252
2010-07-07 02:22:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976
2010-07-07 02:24:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520
2010-07-07 02:26:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520
2010-07-07 02:28:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648
2010-07-07 02:30:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000
2010-07-07 02:32:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000
2010-07-07 02:34:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000,4628
2010-07-07 02:36:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000,4628
2010-07-07 02:38:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000,4628,4924
2010-07-07 02:40:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000,4628,4924
2010-07-07 02:42:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000,4628,4924,4692
2010-07-07 02:44:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000,4628,4924,4692
2010-07-07 02:46:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000,4628,4924,4692,3176
2010-07-07 02:48:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000,4628,4924,4692,3176
2010-07-07 02:50:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000,4628,4924,4692,3176,2968,4188
2010-07-07 02:52:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000,4628,4924,4692,3176,2968,4188,3104,5916
2010-07-07 02:54:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000,4628,4924,4692,3176,2968,4188,3104,5916,5172,2644,4848
2010-07-07 02:56:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000,4628,4924,4692,3176,2968,4188,3104,5916,5172,2644,1992
2010-07-07 02:58:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000,4628,4924,4692,3176,2968,4188,3104,5916,5172,2644,1992
2010-07-07 03:00:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000,4628,4924,4692,3176,2968,4188,3104,5916,5172,2644,1992
2010-07-07 03:02:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000,4628,4924,4692,3176,2968,4188,3104,5916,5172,2644,1992
2010-07-07 03:04:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000,4628,4924,4692,3176,2968,4188,3104,5916,5172,2644,1992
2010-07-07 03:06:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000,4628,4924,4692,3176,2968,4188,3104,5916,5172,2644,1992,316
2010-07-07 03:08:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000,4628,4924,4692,3176,2968,4188,3104,5916,5172,2644,1992,316
2010-07-07 03:10:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000,4628,4924,4692,3176,2968,4188,3104,5916,5172,2644,1992,316,1724,4112
2010-07-07 03:12:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000,4628,4924,4692,3176,2968,4188,3104,5916,5172,2644,1992,316,1724,4112,1796
2010-07-07 03:14:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000,4628,4924,4692,3176,2968,4188,3104,5916,5172,2644,1992,316,1724,4112,1796
2010-07-07 03:16:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000,4628,4924,4692,3176,2968,4188,3104,5916,5172,2644,1992,316,1724,4112,1796,2796
2010-07-07 08:51:20: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000,4628,4924,4692,3176,2968,4188,3104,5916,5172,2644,1992,316,1724,4112,1796,2796,6012
2010-07-07 08:53:20: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044,5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5776,5016,4308,5040,4660,740,3252,5976,4124,4520,2648,5000,4628,4924,4692,3176,2968,4188,3104,5916,5172,2644,1992,316,1724,4112,1796,2796,6012[/CODE]So das wars von meiner Seite aus.
Können noch andere Vista-Nutzer dieses verhalten bestätigen?
Liegt es speziell an meinem Laptop, oder hat PostgreSQL noch einen Vista-Bug?

Was kann ich da machen (außer das Betriebssystem zu wechseln)?

Also, zuerst einmal sollte deine Anwendung niemals als Superuser auf die Datenbank zugreifen!
Dann hättest du nämlich als Superuser immer noch 2 Verbindungen zur Verfügung, selbst wenn normale Accounts alle vorhandenen Verbindungen blockieren.
Wenn deine Anwendung jedoch als Superuser arbeitet, werden die Reserveverbindungen logischerweise auch für diesen Nutzer verwendet.

So, zum eigentlichen Problem: ob du uns hier seitenweise PIDs hinschreibst oder Ausschnitte aus der Bibel postest - das kommt auf das gleiche heraus. Die PIDs sind nur auf deinem Rechner gültig, damit kann hier niemand etwas anfangen.

Du hast aber selbst schon erkannt, dass das Problem nicht auftritt, wenn du nur pgAdminIII verwendest und die Anwendung ausgeschaltet ist. Demzufolge muss das Problem bei deiner Anwendung liegen. Tust du irgendwo Datenbankverbindungen öffnen, aber nicht richtig schließen?

Was siehst du, wenn du folgendes aufrufst:

SELECT waiting, current_query FROM pg_stat_activity

Danke für die Antwort ads.

Ich habe versucht zu sagen, dass es AUCH passiert, wenn ich NUR PGAdmin III nutze.
Wenn ich sicher wäre, dass es nur an unserer Applikation liegt, wüsste ich, das das hier nichts zu suchen hat.

Aber die postgres.exe fangen auch an, sich anzuhäufen, wenn ich über PGAdmin III ein paar Selects ausführe.

Die Abfrage

SELECT waiting, current_query FROM pg_stat_activity

bringt dieses Ergebnis:

f;""
f;“SELECT waiting, current_query FROM pg_stat_activity”

sagt das was aus?

Jede postgres.exe bedeutet eine Verbindung zu Deiner Datenbank.
Für mich klingt das so, als würde Deine Anwendung Verbindungen aufbauen aber nie wieder sauber schliessen.

Aber die postgres.exe fangen auch an, sich anzuhäufen, wenn ich über PGAdmin III ein paar Selects ausführe.

In dem gleichen Umfang wie es Deine Anwendung macht?
Ich glaube pgAdmin öffnet eine Verbindung für jede Datenbank die Du in der Baumansicht anklickst (so dass das rote Kreuz verschwindet) und für jedes SQL/Query Fenster welches du aufmachst.

Ja.
Ich versuche es nochmal genauer zu beschreiben:

Laptopneustart: 5x postgres.exe
Wenn ich nun PGAdmin III öffne, ein Paar Selects auf verschiedene Datenbanken ausführe, sind es 9x poistgres.exe
Dann klicke ich am Ende mit Rechter Maustaste auf den localhost-Server und klicke “Verbindung schließen” -> PGAdmin III beenden -> 5x postgres.exe
Wenn ich jetzt nichts mache (mit Datenbanken [nichtmal indirekt!]) und meinen Laptop einfach im Leerlauf lasse, kann ich beobachten, dass sich innerhalb der nächsten 1 bis 10 Minuten ein weiteres postgres.exe geöffnet hat. -> 6x postgres.exe
Ab jetzt kommt im Minutentakt(alle 1- 10 Minuten) 1 neues postgres.exe (bis sie irgendwann alle connections voll sind, nehme ich an).

Ein identisches Verhalten kann ich bei unserer Applikation beobachten.
Beim beenden unserer Applikation “gehen 1 bis 2 postgres.exe weg”, die sich danach dann im Leerlauf aber wieder aufbauen/häufen/mehr werden.


MfG

Das klingt doch schwer danach, als ob da noch irgendein oder Hintergrundprogramm (Dienst, Service) startet, das sich mit Deiner Datenbank verbindet.

Du musst nun aber est mal herausfinden, was diese Prozesse machen.
Noch einmal der Hinweis von ads,

SELECT waiting, current_query FROM pg_stat_activity;

auszuführen. Kannst du direkt im pgAdmin3 in der SQL-Konsole machen. Das was du zurückgepostet hast, kann nicht die Ausgabe sein… Das wären nur zwei DB-Verbindungen.
Wenn wir sehen, was die Prozesse tun, kann man evtl. erkennen, wo sie herkommen (vacuum, etc)…

Ok, ich führe diese Abfrage nochmal auf jedem meiner Installierten Server aus:

Servername // Server-IP

Ergebnis der Abfrage

ich_selbst // 192.168.3.19:5432

f;""
f;""
f;“SELECT waiting, current_query FROM pg_stat_activity;”

PostgreSQL 8.4 // localhost:5432

f;""
f;""
f;""
f;“SELECT waiting, current_query FROM pg_stat_activity;”

mein_Chef // 192.168.3.16:5432

f;""
f;“SELECT waiting, current_query FROM pg_stat_activity;”
f;""

Das wars, mehr steht da echt nicht.

habe gerade und zum Zeitpunkt der Ausführung der Abfragen 71x den postgres.exe-Prozess offen.



Ja, danke, guter Tipp!
Ich nehme an, dass man das mit der Abfrage herausbekommt, nur scheint das bei mir nicht zu funktionieren :frowning:
Kann ich auch irgendwie herausfinden, WER die postgres.exe gestartet hat?

PS: Ich habe die Benutzerkontensteuerung auch schon ausgeschaltet (für mein Konto, ich habe kein postgres-Benutzerkonto weil ich es als Dienst laufen habe).
MfG

Dann hat irgendein Programm (oder mehrere?) 65 Verbindungen zu Postgres aufgemacht.
Hast Du mal mit netstat (oder TcpView) nachgesehen wo diese Verbindungen herkommen?

Laufen auf dem Datenbankserver (dein Windowsserver) noch andere PostgreSQL-Server, nicht auf Port 5432? Ggf. alte Installationen?

Ok, ich führe diese Abfrage nochmal auf jedem meiner Installierten Server aus:

Was heißt das? Wieviele Server hast du? Oder meinst du Clients?

Ich habe bei Computerverwaltung -> Dienste nur einmal

Dienstname: postgresql-8.4
Anzeigename: postgresql-8.4 - PostgreSQL Server 8.4
Pfad zur EXE: C:/Program Files/PostgreSQL/8.4/bin/pg_ctl.exe runservice -N “postgresql-8.4” -D “C:/Program Files/PostgreSQL/8.4/data” -w
Starttyp: Automatisch
Status: Gestartet

da ist kein weiteres postgres zu finden.

Ich habe 3 Server “registriert”
2mal mich selbst (einmal mit meiner eigenen IP und einmal mit localhost) - das habe ich mal gemacht um Performancetestes zu machen (ich habe mir eingebildet, dass localhost langsamer als eine IP ist)
und einmal den Server, der auf meinem Chef sein PC läuft.

Ich habe auch nicht gesagt, dass ein anderes Postgres die Verbindung aufbaut, sondern irgendein anderes Programm (oder Dienst)

Hast Du mal mit netstat oder TcpView nachgesehen woher die Verbindungen kommen?

netstat.jpg
das ist mein netstat.
über das tcpview weiß ich nichts.
ich google es mal!

ich wüsste nicht wer oder was noch eine verbindung aufbauen könnte/sollte.

ok, ich habe jetzt tcpview.

in tcpview ist die postgres.exe (komischwerweise) nur 5x vorhanden…

Demnach bauen die anderen postgres.exe keine Verbindung auf … aber was tun sie dann… :-/

Weiß vielleicht jemand wie ich das (relativ einfach) herausfinden kann?

EDIT: hier sind die 5 postgres.exe aus TCPView:

postgres.exe:3196 TCP 1337-MACHINE:5432 1337-MACHINE:0 LISTENING
postgres.exe:3196 TCP 1337-MACHINE:5432 1337-MACHINE:0 LISTENING
postgres.exe:3196 TCPV6 1337-machine:5432 1337-machine:0 LISTENING
postgres.exe:3196 TCPV6 [0:0:0:0:0:0:0:1]:5432 1337-machine:0 LISTENING
postgres.exe:3196 UDPV6 [0:0:0:0:0:0:0:1]:64053 :

hier nochmal mein Taskmgr:
taskmgr.jpg

Warum ist denn in diesem netstat nicht eine einzige Verbindung auf Port 5432 zu finden? Z. B. soetwas in der Art:

  
TCP    127.0.0.1:50223        malpighi:[B]5432[/B]          HERGESTELLT
TCP    127.0.0.1:50224        malpighi:[B]5432[/B]          HERGESTELLT

Ist das wirklich das netstat des Servers?