Re: FW: max_connections and shared_buffers

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Anoo Sivadasan Pillai" <aspillai(at)in(dot)rm(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: FW: max_connections and shared_buffers
Date: 2007-09-03 07:28:11
Message-ID: dcc563d10709030028s3ec40330lc6beb2256c7279a6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

On 9/3/07, Anoo Sivadasan Pillai <aspillai(at)in(dot)rm(dot)com> wrote:
> Hi Scott,
> We will be putting connection pooling, But as of now we have to find
> some cure before implementing pooling.
>
> Memory - 2GB
> Postgres - PostgreSQL 8.2.4
> OS - Windows 2003 server installation: ( Service
> Pack 2 )
>
> I am not sure how to get the number of connections while this happens.
> How this can be taken?

Not sure with Windows. I'm strictly a unix type of guy. I'm guessing
that Windows is detecting too many connections / out of memory and
shutting down the service.

Is there anything in the system logs that might give you a hint of why
pgsql is being shut down by the OS?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2007-09-03 13:42:21 Re: FW: max_connections and shared_buffers
Previous Message Anoo Sivadasan Pillai 2007-09-03 07:04:10 Re: FW: max_connections and shared_buffers

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2007-09-03 07:50:47 Re: [HACKERS] \dF wrt text search
Previous Message Trevor Talbot 2007-09-03 07:26:09 Re: tsearch filenames unlikes special symbols and numbers