Re: active connections
От | Andreas Kretschmer |
---|---|
Тема | Re: active connections |
Дата | |
Msg-id | 20071031150715.GA1816@KanotixBox обсуждение исходный текст |
Ответ на | Re: active connections (João Paulo Zavanela <joao_zava@globo.com>) |
Список | pgsql-general |
João Paulo Zavanela <joao_zava@globo.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°
В списке pgsql-general по дате отправления: