Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-adminpgsql-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


pgsql-hackers by date

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

pgsql-admin by date

Next:From: Tom LaneDate: 2007-09-03 13:42:21
Subject: Re: FW: max_connections and shared_buffers
Previous:From: Anoo Sivadasan PillaiDate: 2007-09-03 07:04:10
Subject: Re: FW: max_connections and shared_buffers

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group