On Mon, Feb 20, 2006 at 09:33:57PM +0200, Andrus wrote:
> I want to licence my application per-connection basic.
Ugh. A lot of people here aren't going to be interested in helping
with that.
> I can assume that Postgres 8.1 database or even a whole cluster is accessed
> only by my application o
> You could query pg_stat_activity or the underlying statistics
> collector functions.
>
> http://www.postgresql.org/docs/8.1/interactive/monitoring-stats.html
>
> Statistics collector reports lag behind actual activity but they
> might suffice for whatever you're doing. Why does your application
am 20.02.2006, um 19:39:55 +0200 mailte Andrus folgendes:
> When connectiong to database my application needs to determine how many
> connections is currently established to Postgres server.
select * from pg_stat_activity ;
> I can create temporary table at startup of each connection. But how t
On Mon, Feb 20, 2006 at 07:39:55PM +0200, Andrus wrote:
> When connectiong to database my application needs to determine how many
> connections is currently established to Postgres server.
You could query pg_stat_activity or the underlying statistics
collector functions.
http://www.postgresql.org
When connectiong to database my application needs to determine how many
connections is currently established to Postgres server.
Any idea which query I should use ?
I can create temporary table at startup of each connection. But how to count
the number of temporary tables created by all applicati
