Re: [ADMIN] Server crash... trying to figure it out

2011-05-31 Thread Kevin Grittner
Wells Oliver wrote: > Do you have any recommendations on a pg connection pooler? If the software you're using includes a connection pool, that is often the best choice; if not (or it doesn't work well) both pgpool and pgbouncer have their followings. In my view the most important things are

Re: [ADMIN] Server crash... trying to figure it out

2011-05-31 Thread Wells Oliver
On May 31, 2011, at 11:31 AM, Kevin Grittner wrote: You're probably overcommitting memory and running afoul of the oom killer. You've got an actual 12MB, but you can easily allocate up to shared_buffers + (user_connections * work_mem), which is 18.5 GB. I would start by reducing shared_buggers

Re: [ADMIN] Server crash... trying to figure it out

2011-05-31 Thread Kevin Grittner
Wells Oliver wrote: > This has happened twice over the last couple of nights: > > 2011-05-30 02:08:27 PDT LOG: server process (PID 29979) was > terminated by signal 9: Killed > 2011-05-30 02:08:31 PDT FATAL: could not create shared memory > segment: Cannot allocate memory > To reduce the