Olivier PRENANT <ohp(at)pyrenet(dot)fr> writes:
> pyrenet=# VACUUM ANALYZE ;
> FATAL 2: could not open transaction-commit log directory (/usr/local/pgsql/data/pg_clog): Too many open files
Hmm. Do you have any idea what sysconf(_SC_OPEN_MAX) returns on your
platform? You could try reducing the max_files_per_process parameter.
regards, tom lane