PostgreSQL 8.0.3 Documentation - Chapter 23. Monitoring Database Activity

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/