Re: postmaster -i & establishes three connections why?

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Jeff Lu <jklcom(at)mindspring(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org, psql-cygwin(at)postgresql(dot)org
Subject: Re: postmaster -i & establishes three connections why?
Date: 2003-02-14 21:31:41
Message-ID: 1045258301.15174.867.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

<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(at)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message STashlitsky 2003-02-14 21:33:09 convert from an integer to a date
Previous Message Tom Lane 2003-02-14 21:08:42 Re: Timezone conversion