Re: [ADMIN] Freeing Connections

2001-11-13 Thread Andrew Hill
Apologies for replying to my own post, and resurrecting something from ages ago, but I though that people may be interested in what had happened. You may recall that I was seeing a number of processes like this on my linux PostgreSQL server: [bash] \_ postmaster -i -D/var/pgsql/data -N 32 -B

Re: [ADMIN] Freeing Connections

2001-10-22 Thread Andrew Hill
Ross J. Reedstrom wrote: > ISTR some vesion of PHP with exactly that bug. Should be in the mailing > list archives. Well, I wasn't able to find anything that matched the problem I seem to be having exactly, but restarting the Apache/PHP servers that are connecting to the database does make the

Re: [ADMIN] Freeing Connections

2001-10-19 Thread Lenny Mastrototaro
On Thu, Oct 18, 2001 at 01:55:33PM -0400, Tom Lane wrote: > Andrew Hill <[EMAIL PROTECTED]> writes: > > 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

Re: [ADMIN] Freeing Connections

2001-10-18 Thread Andrew Hill
Ross J. Reedstrom wrote: > Andrew doesn't mention his platform, but if it's linux, It is... > those could just > be swapped out processes: since the execution state gets swapped, the > kernel only has minimal info about the process, including the original > name. I'm guessing that his PHP setu

Re: [ADMIN] Freeing Connections

2001-10-18 Thread Ross J. Reedstrom
On Thu, Oct 18, 2001 at 01:55:33PM -0400, Tom Lane wrote: > Andrew Hill <[EMAIL PROTECTED]> writes: > > 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

Re: [ADMIN] Freeing Connections

2001-10-18 Thread Tom Lane
Andrew Hill <[EMAIL PROTECTED]> writes: > 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

[ADMIN] Freeing Connections

2001-10-17 Thread Andrew Hill
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 tha