Re: "Too many open files in system" error - Mailing list pgsql-admin

From Emanuel Calvo Franco
Subject Re: "Too many open files in system" error
Date
Msg-id f205bb120908121014k49b45eadh266be5ca9a5646fa@mail.gmail.com
Whole thread Raw
In response to "Too many open files in system" error  (Jonatan Evald Buus <jonatan.buus@cellpointmobile.com>)
Responses Re: "Too many open files in system" error  (jinson abraham <abraham.jinson@gmail.com>)
List pgsql-admin
2009/8/12 Jonatan Evald Buus <jonatan.buus@cellpointmobile.com>:
> Greetings,
> We're seeing numerous "LOG:  out of file descriptors: Too many open files in
> system; release and retry" entries as well as quite a few "LOG:  could not
> open temporary statistics file "global/pgstat.tmp": Too many open files in
> system"
> Much more alarming however, we're seeing errors such as:
> FATAL:  could not open file "global/pg_database": Too many open files in
> system
> ERROR:  could not open relation 1663/2219053/2601: Too many open files in
> system
>
> kern.maxfiles is currently set to 12328 and "sysctl -a | grep
> kern.openfiles" showed over 10.000 open files prior to a reboot.
> After the reboot kern.openfiles quickly increased from less than 200 to over

Did you request about kern.maxfiles?


--
              Emanuel Calvo Franco
             Database consultant at:
                    www.siu.edu.ar
        www.emanuelcalvofranco.com.ar

pgsql-admin by date:

Previous
From: Jonatan Evald Buus
Date:
Subject: "Too many open files in system" error
Next
From: jinson abraham
Date:
Subject: Re: "Too many open files in system" error