Re: [HACKERS] keeping track of connections - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] keeping track of connections
Date
Msg-id 199806031243.IAA05701@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] keeping track of connections  (Brett McCormick <brett@work.chicken.org>)
List pgsql-hackers
>
> On Wed, 3 June 1998, at 00:11:01, Bruce Momjian wrote:
>
> > Good question.  Postmaster does not have access to the system tables, so
> > it can't access them.  You could add a debug option to show it in the
> > server logs, or add it to the -d2 debug option that already shows SQL
> > statements.
>
> How about something like this: a pool of shared memory where this
> information is stored, and then a view which calls a set of functions
> to return the information from the shared memory?
>
> Apache does something similar.
>
>

Yes, that would work.  Are you looking for something to show current
backend status.  What type of info would be in there?

--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

pgsql-hackers by date:

Previous
From: "Jose' Soares Da Silva"
Date:
Subject: Re: [HACKERS] dump/reload
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] keeping track of connections