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