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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
