Re: Postgres startup processes on linux?

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