X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5BDA752DE8 for ; Tue, 26 Jul 2005 07:06:51 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63391-07 for ; Tue, 26 Jul 2005 10:06:46 +0000 (GMT) Received: from web52708.mail.yahoo.com (web52708.mail.yahoo.com [206.190.48.231]) by svr1.postgresql.org (Postfix) with SMTP id 9F53852B80 for ; Tue, 26 Jul 2005 07:06:44 -0300 (ADT) Received: (qmail 91265 invoked by uid 60001); 26 Jul 2005 10:06:42 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=qQc4Cc+G4+3F4FRHyx4hEYSNzj8u36J6keu65XgX8qX8s9/foOfO2FfnQooroKKy2NJWmz1QPTfE8TPIs0CBKKBIPZR8pRodjjQH6/pWnaBEO8cK8BnkzKUa+oP3GGyD5LgMwB/chRZh9xc47H4MEwvyJ+D6RRv/kp/yIefP0cs= ; Message-ID: <20050726100642.91263.qmail@web52708.mail.yahoo.com> Received: from [201.8.15.57] by web52708.mail.yahoo.com via HTTP; Tue, 26 Jul 2005 07:06:42 ART Date: Tue, 26 Jul 2005 07:06:42 -0300 (ART) From: Halley Pacheco de Oliveira Subject: PostgreSQL 8.0.3 Documentation - Chapter 23. Monitoring Database Activity To: pgsql-docs@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.477 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200507/23 X-Sequence-Number: 3149 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/