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

Freeing Connections

From: Andrew Hill <list(at)fornax(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Freeing Connections
Date: 2001-10-18 01:12:53
Message-ID: 3BCE2C95.6020002@fornax.net (view raw or flat)
Thread:
Lists: pgsql-admin
Hi,

Sorry if this has been covered before, but I haven't been able to find 
any information about it.

I'm running PostgreSQL 7.0.3 with the following command:

   postmaster -i -D/var/pgsql/data -N 32 -B 64

Normally, 32 connections is heaps for what I need. However, I often get 
connections that seem to be doing nothing. For example:

[bash]
  \_ postmaster -i -D/var/pgsql/data -N 32 -B 64
  \_ [postmaster]
  \_ /var/pgsql/bin/postgres 202.174.32.67 postgres anb idle
  \_ /var/pgsql/bin/postgres 202.174.32.68 postgres anb idle
  \_ [postmaster]
  \_ /var/pgsql/bin/postgres 203.34.190.137 postgres bmf idle
  \_ [postmaster]
  \_ [postmaster]
  \_ [postmaster]
  \_ [postmaster]
  \_ /var/pgsql/bin/postgres 202.174.32.8 radius bmf idle
  \_ /var/pgsql/bin/postgres 203.34.190.137 postgres bmf idle
  \_ /var/pgsql/bin/postgres 202.174.32.66 postgres bmf idle
  \_ /var/pgsql/bin/postgres 203.34.190.137 postgres bmf idle
  \_ /var/pgsql/bin/postgres 203.34.190.137 postgres bmf idle
  \_ /var/pgsql/bin/postgres localhost postgres bmf idle
  \_ /var/pgsql/bin/postgres 202.174.32.66 postgres bmf idle
  \_ logger -p local5.notice

The "idle" connections are from boxes that are using PHP's pg_pconnect 
to connect to the database, so that's no problem. However, it the 
[postmaster] entries that worry me - over time, these just increase in 
number until I start getting connections refused.

Can anyone please help me with what these are, and how to stop them 
accumulating?

TIA!

-- 
Andrew Hill
"RAID - Don't believe the hype." -- 2001-09-22


Responses

pgsql-admin by date

Next:From: Mr OCPDate: 2001-10-18 06:35:01
Subject: Please help - tks
Previous:From: Russ McBrideDate: 2001-10-18 00:36:54
Subject: PgAccess on OS X--was "tcl wish--simple configure problem"

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