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