Skip site navigation (1) Skip section navigation (2)

Re: active connections

From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: active connections
Date: 2007-10-31 15:07:15
Message-ID: 20071031150715.GA1816@KanotixBox (view raw or flat)
Thread:
Lists: pgsql-general
João Paulo Zavanela <joao_zava(at)globo(dot)com> schrieb:

> I don't understand, where I do it?

A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing in e-mail?

Please no top-posting, it's hard to read.

> >
> >
> >ps aux | grep postgres

You mean this? Okay, type it on the command-line on the db-server.
I assume it's a *NIX-like machine, no Windoze.


> >I would like to know how many active connections exist.
> >Is necessary show the number ip of client.

the more db-like solution, as i said, ask the system-view
pg_stat_activity


Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."    (unknow)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

In response to

pgsql-general by date

Next:From: Douglas McNaughtDate: 2007-10-31 15:11:58
Subject: Re: configure password
Previous:From: Craig WhiteDate: 2007-10-31 15:01:41
Subject: getting list of tables from command line

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group