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
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
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
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
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
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
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