X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP
	id F1B9A47624A; Fri, 14 Feb 2003 16:49:13 -0500 (EST)
Received: from localhost.localdomain (unknown [65.217.53.66])
	by postgresql.org (Postfix) with ESMTP
	id DBC4F4764EF; Fri, 14 Feb 2003 16:31:43 -0500 (EST)
Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100])
	by localhost.localdomain (8.12.5/8.12.5) with ESMTP id h1ELvT6P019166;
	Fri, 14 Feb 2003 16:57:30 -0500
Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55])
	by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id h1EMVfp12624;
	Fri, 14 Feb 2003 17:31:41 -0500
Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP
	(Microsoft Exchange Internet Mail Service Version 5.5.2653.13)
	id CWVL1KSL; Fri, 14 Feb 2003 16:31:38 -0500
Subject: Re: postmaster -i & establishes three connections why?
From: Robert Treat <xzilla@users.sourceforge.net>
To: Jeff Lu <jklcom@mindspring.com>
Cc: pgsql-sql@postgresql.org, psql-cygwin@postgresql.org
In-Reply-To: <000b01c2d3b3$acfdb4f0$1501a8c0@DemoServer>
References: <000b01c2d3b3$acfdb4f0$1501a8c0@DemoServer>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-Mailer: Ximian Evolution 1.0.8 
Date: 14 Feb 2003 16:31:41 -0500
Message-Id: <1045258301.15174.867.camel@camel>
Mime-Version: 1.0
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/350
X-Sequence-Number: 11748

<note: no need to send emails to the -owner address)

On Thu, 2003-02-13 at 18:00, Jeff Lu wrote:
> Hi,
>  
> I've just upgraded my cygwin to 1.3.20-1 and postgresql to 7.3.2
>  
> And I found that when run
>  
> postmaster -i &
>  
> There are three connections being established and why is that?
>  
> Administrator@DemoServer ~
> $ LOG:  database system was shut down at 2003-02-13 17:33:26 EST
> LOG:  checkpoint record is at 0/841330
> LOG:  redo record is at 0/841330; undo record is at 0/0; shutdown TRUE
> LOG:  next transaction id: 484; next oid: 16976
> LOG:  database system is ready
> $ ps -l
>       PID    PPID    PGID     WINPID  TTY  UID    STIME COMMAND
>      2292       1    2292       2292  con  500 17:43:20 /usr/bin/bash
>      2320    2292    2292       2324  con  500 17:43:22
> /usr/local/bin/ipc-daemo
> n
>      2092    2292    2292       2404  con  500 17:43:22
> /c/progra~1/apache~1/apa
> che/cgi-bin/printspool
>      2312    2292    2292       2452  con  500 17:43:24
> /usr/bin/postgres
>      2048    2312    2292       2048  con  500 17:43:28
> /usr/bin/postgres
>      1884    2048    2292       1884  con  500 17:43:28
> /usr/bin/postgres
>      2504    2292    2504       1960  con  500 17:43:36 /usr/bin
> 

Are you sure those are connections. On server start you should get three
process going, the main postmaster, the stats collector, and the stats
buffer

Robert Treat