Skip site navigation (1) Skip section navigation (2)

PostgreSQL 8.0.3 Documentation - Chapter 23. Monitoring Database Activity

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 (view raw or flat)
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/ 

Responses

pgsql-docs by date

Next:From: Peter EisentrautDate: 2005-07-26 10:33:43
Subject: Re: PostgreSQL 8.0.3 Documentation - Chapter 23. Monitoring Database Activity
Previous:From: Bruce MomjianDate: 2005-07-22 05:13:22
Subject: Re: ROW SHARE/SELECT ... FOR UPDATE + foreign keys

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group