> 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@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