public inbox for [email protected]  

help / color / mirror / Atom feed

From: Halley Pacheco de Oliveira <[email protected]>
To: [email protected]
Subject: PostgreSQL 8.0.3 Documentation - Chapter 23. Monitoring Database Activity
Date: Tue, 26 Jul 2005 07:06:42 -0300 (ART)
Message-ID: <[email protected]> (raw)

In PostgreSQL 8.0.3 Documentation - Chapter 23. Monitoring Database Activity - 23.1. Standard Unix
Tools is written:

The user, database, and connection source host items remain the same for the life of the client
connection, but the activity indicator changes.

But look at that:

psql -U sistemas -h 192.168.0.1 template1

ps aux | grep ^postgres

postgres  3908  0.0  0.3 19948 2000 ?        S    05:45   0:00 /usr/bin/postmaster -p 5432 -D
/var/lib/pgsql/data
postgres  3968  0.0  0.3 10748 1792 ?        S    05:45   0:00 postgres: stats buffer process
postgres  3969  0.0  0.3  9756 1848 ?        S    05:45   0:00 postgres: stats collector process
postgres  8223  0.0  0.5 20348 2608 ?        S    06:42   0:00 postgres: sistemas template1
192.168.0.1 idle

template1=# \c teste

ps aux | grep ^postgres

postgres  3908  0.0  0.3 19948 2000 ?        S    05:45   0:00 /usr/bin/postmaster -p 5432 -D
/var/lib/pgsql/data
postgres  3968  0.0  0.3 10748 1792 ?        S    05:45   0:00 postgres: stats buffer process
postgres  3969  0.0  0.3  9756 1848 ?        S    05:45   0:00 postgres: stats collector process
postgres  8244  0.0  0.5 20348 2608 ?        S    06:43   0:00 postgres: sistemas teste
192.168.0.1 idle

So the database name didn't remain the same, neither the process id. Connecting to another
database creates a brand new connection using other server process as it seems to be. I think it
should be written in this paragraph. I couldn't imagine that, for me the process was still the
same.

Regards,
Halley

__________________________________________________
Converse com seus amigos em tempo real com o Yahoo! Messenger 
http://br.download.yahoo.com/messenger/ 

view thread (11+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: PostgreSQL 8.0.3 Documentation - Chapter 23. Monitoring Database Activity
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox