From: | Halley Pacheco de Oliveira <halleypo(at)yahoo(dot)com(dot)br> |
---|---|
To: | pgsql-docs(at)postgresql(dot)org |
Subject: | PostgreSQL 8.0.3 Documentation - Chapter 23. Monitoring Database Activity |
Date: | 2005-07-26 10:06:42 |
Message-ID: | 20050726100642.91263.qmail@web52708.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2005-07-26 10:33:43 | Re: PostgreSQL 8.0.3 Documentation - Chapter 23. Monitoring Database Activity |
Previous Message | Bruce Momjian | 2005-07-22 05:13:22 | Re: ROW SHARE/SELECT ... FOR UPDATE + foreign keys |