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/ ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
