Attila,
Am 23.09.2013 um 10:52 schrieb Attila Heidrich:
Postgres database stopped again... I guess the problem was the
enormous number of open files...
We use 9.2, and we also use the postgres plugin - which still doesn't really support
9.2 as far as I know.
Can you please disable that plugin to see if this may cause the issue?
To what value did you set max connections in postgresql.conf
max_connections = 100
John found an issue recently where the baseline calculation did not close
connections, but this should not create insane amounts of connections,
as the appserver is supposed to limit them.
Sorry for the inconvenience.
If that happens again, can you do a ps auxw| and grep for processes like these:
postgres 6087 0,0 0,1 2487132 5312 ?? Ss 11:28am 0:00.08 postgres:
rhqadmin rhqdev 127.0.0.1(65248) idle
postgres 6081 0,0 0,1 2487132 4308 ?? Ss 11:28am 0:00.01 postgres:
rhqadmin rhqdev 127.0.0.1(65243) idle
That may help us diagnose what is going wrong.
Heiko
--
Reg. Adresse: Red Hat GmbH, Technopark II, Haus C,
Werner-von-Siemens-Ring 14, D-85630 Grasbrunn
Handelsregister: Amtsgericht München HRB 153243
Geschaeftsführer: Mark Hegarty, Charlie Peters, Michael Cunningham, Charles Cachera