Re: Postgres startup processes on linux? - Mailing list pgsql-general

From Steve Crawford
Subject Re: Postgres startup processes on linux?
Date
Msg-id 49D125A9.5070707@pinpointresearch.com
Whole thread Raw
In response to Postgres startup processes on linux?  ("Eshelman, James" <james.eshelman@hp.com>)
List 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


pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Installing PLPython - Version Problem
Next
From: SHARMILA JOTHIRAJAH
Date:
Subject: Read a CLOB data from an Oracle table and INSERT it into a BYTEA column in Postgres using jdbc?