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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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°
From | Date | Subject | |
---|---|---|---|
Next Message | Douglas McNaught | 2007-10-31 15:11:58 | Re: configure password |
Previous Message | Craig White | 2007-10-31 15:01:41 | getting list of tables from command line |