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

Re: Postgres startup processes on linux?

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: "Eshelman, James" <james(dot)eshelman(at)hp(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres startup processes on linux?
Date: 2009-03-30 20:03:53
Message-ID: 49D125A9.5070707@pinpointresearch.com (view raw or flat)
Thread:
Lists: pgsql-general
Eshelman, James wrote:
>
> We’re running PG 8.1 on CentOS 5.0. When postgres starts the following 
> processes apparently required by the DB itself get created:
>
> postgres 23784 1 0 13:55 ? 00:00:00 /usr/bin/postmaster -p 5432 -D 
> /var/lib/pgsql/data
>
> postgres 23786 23784 0 13:55 ? 00:00:00 postgres: logger process
>
> postgres 23788 23784 0 13:55 ? 00:00:00 postgres: writer process
>
> postgres 23789 23784 0 13:55 ? 00:00:01 postgres: stats buffer process
>
> postgres 23790 23789 0 13:55 ? 00:00:00 postgres: stats collector process
>
> postgres 23802 23784 3 13:55 ? 00:00:58 postgres: airwave airwave 
> [local] idle
>
> postgres 23803 23784 0 13:55 ? 00:00:12 postgres: airwave airwave 
> [local] idle
>
> I understand what the first five are for. What are 23802 and 23803? ...
>
Do a bit of sleuthing. It appears you have two connections (user 
"airwave", db "airwave") and the connections are local.

Try "select * from pg_stat_activity" (though they are both showing local 
in "ps"). Also look for the connecting process (say, "lsof -U | grep 
5432") and track down the source.

Do you possibly have a connection pool that starts up along with the db?

Cheers,
Steve


In response to

pgsql-general by date

Next:From: SHARMILA JOTHIRAJAHDate: 2009-03-30 20:10:44
Subject: Read a CLOB data from an Oracle table and INSERT it into a BYTEA column in Postgres using jdbc?
Previous:From: Craig RingerDate: 2009-03-30 20:00:52
Subject: Re: Installing PLPython - Version Problem

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