Re: [ADMIN] postgres connections in IDLE state..

2013-10-08 Thread jaime soler
El jue, 03-10-2013 a las 16:34 +, Rajagopalan, Jayashree escribió: Thanks. But what is the process id that is attached to the connection? You can look at pid field in the pg_stat_activity system view. Can I track down or debug/ get more information related to that process id? I'd use

Re: [ADMIN] Reg. Restore

2013-10-08 Thread Matheus de Oliveira
On Tue, Oct 8, 2013 at 2:43 AM, Venakata Ramana ramana@gmail.comwrote: Thanks for your reply. --- You should update to 9.1.9. Recently I updated to 9.1.5. I will do in near future. Recently??? 9.1.5 was released more then one year ago... =/ -- How are you doing this restore? Is it

Re: [ADMIN] Random server overload

2013-10-08 Thread Viktor Juhanson
Hello, It's me again.. Log_connection inspection didn't help to find the cause, the connections come from our app-servers as usual.. Btw we have the max pool size of web application 50 connections and since we have 4 instances of application running  it makes max 200. I don't really

Re: [ADMIN] Random server overload

2013-10-08 Thread Kevin Grittner
Viktor Juhanson sp...@planet.ee wrote: Btw we have the max pool size of web application 50 connections and since we have 4 instances of application running  it makes max 200. I don't really get how the database pool gets full when application can use 200 connections max and postrgesql