Re: [GENERAL] active connections

2007-10-31 Thread Andreas Kretschmer 
João Paulo Zavanela <[EMAIL PROTECTED]> 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°

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly

Re: [GENERAL] active connections

2007-10-31 Thread João Paulo Zavanela 
I don't understand, where I do it?


>-- Mensagem Original --
>From: "Martin Gainty" <[EMAIL PROTECTED]>
>To: João Paulo Zavanela <[EMAIL PROTECTED]>
>Subject: Re: [GENERAL] active connections
>Date: Mon, 30 Oct 2000 16:51:30 -0500
>
>
>ps aux | grep postgres
>
>M--
>- Original Message -
>From: "João Paulo Zavanela" <[EMAIL PROTECTED]>
>To: 
>Sent: Tuesday, October 30, 2007 12:51 PM
>Subject: [GENERAL] active connections
>
>
>Hi,
>
>I would like to know how many active connections exist.
>Is necessary show the number ip of client.
>
>Please, somebody knows?
>
>Thanks!
>
>
>
>---(end of broadcast)---
>TIP 3: Have you checked our extensive FAQ?
>
>   http://www.postgresql.org/docs/faq
>



---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] active connections

2007-10-30 Thread A. Kretschmer 
am  Tue, dem 30.10.2007, um 14:51:33 -0300 mailte João Paulo Zavanela folgendes:
> Hi,
> 
> I would like to know how many active connections exist.
> Is necessary show the number ip of client.

ask pg_stat_activity

(select * from pg_stat_activity;)

Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

[GENERAL] active connections

2007-10-30 Thread João Paulo Zavanela 
Hi,

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

Please, somebody knows?

Thanks!



---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq