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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
