[GENERAL] 3 postgres processes

2008-09-09 Thread Markova, Nina
Hi,

After issuning initdb and starting the postgres server, I checked for processes 
running, expecting to see just one:
 
postgres  4926  4924   0 14:44:52 ?   0:00 
/usr/postgres/8.2/bin/postgres
postgres  4924 1   0 14:44:52 pts/1   0:00 
/usr/postgres/8.2/bin/postgres
postgres  4929  4850   0 14:44:56 pts/1   0:00 grep postgres
postgres  4928  4850   0 14:44:56 pts/1   0:00 ps -ef
postgres  4927  4924   0 14:44:52 ?   0:00 
/usr/postgres/8.2/bin/postgres


Only one of them is in postmaster.pid. What the other ones are for?

 more /pg_data/postmaster.pid 
4924
/pg_data
  543200131


Thanks,

-'\/\/\/`v^v^v^v^v^v^v
Nina Markova, 
Database Analyst/ Analyst de base de données
(613) 992-3753   facsimile  / télécopieur (613) 992-8836
[EMAIL PROTECTED]

Geological Survey of Canada / Commission géologique du Canada
Natural Resources Canada/ Ressources naturelles Canada
Government of Canada/ Gouvernement du Canada
-'\/\/\/`v^v^v^v^v^v^v

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] 3 postgres processes

2008-09-09 Thread Lennin Caro
--- On Tue, 9/9/08, Markova, Nina [EMAIL PROTECTED] wrote:

 From: Markova, Nina [EMAIL PROTECTED]
 Subject: [GENERAL] 3 postgres processes
 To: pgsql-general@postgresql.org
 Date: Tuesday, September 9, 2008, 2:50 PM
 Hi,
 
 After issuning initdb and starting the postgres server, I
 checked for processes running, expecting to see just one:
  
 postgres  4926  4924   0 14:44:52 ?   0:00
 /usr/postgres/8.2/bin/postgres
 postgres  4924 1   0 14:44:52 pts/1   0:00
 /usr/postgres/8.2/bin/postgres
 postgres  4929  4850   0 14:44:56 pts/1   0:00 grep
 postgres
 postgres  4928  4850   0 14:44:56 pts/1   0:00 ps -ef
 postgres  4927  4924   0 14:44:52 ?   0:00
 /usr/postgres/8.2/bin/postgres
 
 
 Only one of them is in postmaster.pid. What the other ones
 are for?
 
  more /pg_data/postmaster.pid 
 4924
 /pg_data
   543200131
 
 
 Thanks,
 

use ps auxw to see more details of the process

i think the processes are one of this

writer process
wal writer process
autovacuum launcher process   
stats collector process


  


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general