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/