Monitoring DB activity PosgreSQL 7.3.2

From: Andre Truter <andre(dot)truter(at)intekom(dot)co(dot)za>
To: pgsql-general(at)postgresql(dot)org
Subject: Monitoring DB activity PosgreSQL 7.3.2
Date: 2003-07-28 10:36:29
Message-ID: 1059388589.30839.32.camel@tux.atio.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have PostgreSQL 7.3.2 server running.
I could normally view the sessions by doing
'ps auxww | grep ^postgres' like the documentation states.

But, recently it is not showing me expected output anymore.

THis is what I get:
postgres 1661 0.0 0.0 9132 176 ? S Jul18 0:00
[postmaster]
postgres 1665 0.0 0.0 10124 56 ? S Jul18 0:00
[postmaster]
postgres 1666 0.0 0.0 9204 236 ? S Jul18 0:00
[postmaster]
postgres 1848 0.0 0.0 9944 0 ? SW Jul27 0:00
[postmaster]
postgres 4082 0.0 0.0 9844 0 ? SW Jul27 0:00
[postmaster]
postgres 4083 0.0 0.0 10512 0 ? SW Jul27 0:00
[postmaster]
postgres 4084 0.0 0.0 10604 0 ? SW Jul27 0:00
[postmaster]
postgres 5089 0.0 0.0 9908 4 ? S Jul27 0:00
[postmaster]
postgres 5963 0.0 0.0 9908 0 ? SW Jul27 0:00
[postmaster]
postgres 5984 0.0 0.0 9844 0 ? SW Jul27 0:00
[postmaster]
postgres 18014 0.0 0.8 11316 4348 ? S 09:28 0:01
[postmaster]
postgres 18431 0.0 0.8 11168 4544 ? S 10:02 0:00
[postmaster]

Is there a different way of seeing the user sessions?

I thought that my documentation was out of date, so I tried the
PostgreSQL site, but that seems to be out of order.
http://www.postgresql.org/ gives me the Apache test page.

--
Andre Truter
Software Engineer
Registered Linux user #185282
ICQ #40935899 AIM: trusoftzaf
http://www.trusoft.za.net

<------------------------------------------------->
< The box said: Requires Windows 95 or better... >
< So I installed Linux >
<------------------------------------------------->

Disclaimer and Confidentiality Warning

This message is intended for the addressee only. If you are not the intended recipient of this message, you are notified that any distribution, use of or copying of this communication is strictly prohibited. If you have received the communication in error, please notify the sender immediately. The views and opinions expressed in this message are those of the individual sender of this message and do not necessarily represent the views and opinions of ATIO. Consequently, ATIO does not accept responsibility for such views and opinions and this message should not be read as representing the views and opinions of ATIO without subsequent written confirmation. Each page attached hereto must also be read in conjunction with this disclaimer.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Thomas 2003-07-28 11:28:33 Re: Where's the postgresql website atm?
Previous Message Arjen van der Meijden 2003-07-28 10:15:02 Where's the postgresql website atm?