Hosting Provided By

Re: [GENERAL] active connections

From: Andreas Kretschmer <akretschmer(at)spamfence.net>
Date: Wed Oct 31 2007 - 11:07:15 EDT

João Paulo Zavanela <joao_zava@globo.com> schrieb:

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

Because it messes up the order in which people normally read text.
Why is top-posting such a bad thing?
Top-posting.
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°

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly

Received on Wed Oct 31 13:00:13 2007

Do you need help?

This message: [ Message body ]
Next message: Douglas McNaught: "Re: [GENERAL] configure password"
Previous message: Scott Marlowe: "Re: [GENERAL] configure password"
In reply to: João Paulo Zavanela: "Re: [GENERAL] active connections"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Mon Jun 16 2008 - 19:09:03 EDT