What is the value of "max_files_per_process" in your
Postgres databases?
Thanks,
Thomas
It is on the default value, maybe 1000?
root@ct-front:/etc/postgresql/9.2/main# grep max_files_per_process *
postgresql.conf:#max_files_per_process = 1000 # min 25
2013/9/23 Attila Heidrich <attila.heidrich(a)gmail.com>
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.
Altogether Postgres (only the one storing the RHQ database) can only run
for a few days, than the number of open files and the open connections
raise really high, and finally I should restart it.
Usually I restart RHQ as well, I generally have no time to play with "what
to restart".
The log is practically endless, I can quote, but I think I should know
something to look for in it.
Regards,
Attila