Re: [HACKERS] keeping track of connections

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: brett(at)work(dot)chicken(dot)org (Brett McCormick)
Cc: pgsql-hackers(at)hub(dot)org
Subject: Re: [HACKERS] keeping track of connections
Date: 1998-06-03 12:43:18
Message-ID: 199806031243.IAA05701@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)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)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-06-03 12:58:46 Re: [HACKERS] keeping track of connections
Previous Message Jose' Soares Da Silva 1998-06-03 11:33:28 Re: [HACKERS] dump/reload