Hi All, I am using postgresql in Debian Linux 3.0 (unstable) with : java version "1.3.0" Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.0) Classic VM (build 1.3.0, J2RE 1.3.0 IBM build cx130-20010925 (JIT enabled: jitc))
When a user session closed (after 30 min) turbine doesn't close opened postgres connection: [EMAIL PROTECTED]:~$ ps aux | grep post postgres 32474 0.0 0.4 16068 2180 ? S Mar15 0:00 /usr/lib/postgresql/bin/postmaster postgres 32475 0.0 0.4 17060 2160 ? S Mar15 0:00 postgres: stats buffer process postgres 32478 0.0 0.4 16116 2208 ? S Mar15 0:00 postgres: stats collector process postgres 32486 0.0 0.9 16932 4928 ? S Mar15 0:00 postgres: postgres vili 127.0.0.1 idle postgres 32507 0.0 0.8 16908 4380 ? S Mar15 0:00 postgres: postgres vili 127.0.0.1 idle postgres 32555 0.0 0.9 16968 4648 ? S Mar15 0:00 postgres: postgres vili 127.0.0.1 idle postgres 32576 0.0 0.7 16808 3992 ? S Mar15 0:00 postgres: postgres vili 127.0.0.1 idle postgres 32666 0.0 0.9 16940 4764 ? S Mar15 0:00 postgres: postgres vili 127.0.0.1 idle postgres 708 0.0 0.8 16816 4188 ? S Mar15 0:00 postgres: postgres vili 127.0.0.1 idle postgres 709 0.0 0.9 16932 4640 ? S Mar15 0:00 postgres: postgres vili 127.0.0.1 idle postgres 710 0.0 0.8 16908 4308 ? S Mar15 0:00 postgres: postgres vili 127.0.0.1 idle postgres 2052 0.0 0.8 16840 4256 ? S Mar16 0:00 postgres: postgres vili 127.0.0.1 idle postgres 5925 0.0 0.9 16940 4804 ? S Mar18 0:00 postgres: postgres vili 127.0.0.1 idle postgres 5926 0.0 0.8 16908 4364 ? S Mar18 0:00 postgres: postgres vili 127.0.0.1 idle postgres 6162 0.0 0.9 16932 4700 ? S Mar18 0:00 postgres: postgres vili 127.0.0.1 idle postgres 6163 0.0 0.7 16816 4084 ? S Mar18 0:00 postgres: postgres vili 127.0.0.1 idle postgres 6269 0.0 0.8 16816 4188 ? S Mar18 0:00 postgres: postgres vili 127.0.0.1 idle postgres 6604 0.0 0.8 16816 4184 ? S Mar18 0:00 postgres: postgres vili 127.0.0.1 idle postgres 6605 0.0 0.8 16932 4596 ? S Mar18 0:00 postgres: postgres vili 127.0.0.1 idle ther are _very_ old connections in idle status. What do I have to do to close unecessary connections? Are there any special porperties in TR.properties or Torque.properties? -- thx, ---------------------------------------------------- Zoltan Zidarics programmer PTE University Pecs, Hungary icq: 43288694 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
