Vick Khera wrote: > On Sat, Aug 22, 2009 at 6:55 PM, Greg Sabino Mullane<greg@xxxxxxxxxxxx> wrote: > > A server crash is a pretty rare event in the Postgres world, so I > > would not spend too many cycles on this... > > I had one the other day caused by server resource issues: I ran out of > file descriptors when I had a very large surge in activity. Pg > rightfully panicked and disconnected all my clients. PG is not supposed to crash when it runs out of file descriptors. In fact there's a whole abstraction layer to ensure this does not happen. What you saw was either misconfiguration or a bug somewhere (for example maybe you have untrusted functions that try to open files?) -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general