Forum OpenACS Development: postgres: nsadmin openacs [local] idle

Collapse
1: postgres: nsadmin openacs [local] idle
Posted by Ahmed Moustafa on 05/10/01 05:06 PM
I got the following when I did ps -ef: 

root      2313  2000  0 09:48 ?        00:00:00 supervise openacs
root      2314  2313  0 09:48 ?        00:00:00 sh ./run
nsadmin   2315  2314  0 09:48 ?        00:00:04
/usr/local/aolserver/bin/nsd -i -t /home/nsadmin/openacs.tcl -u nsadmin
nsadmin   2318  2315  0 09:48 ?        00:00:00
/usr/local/aolserver/bin/nsd -i -t /home/nsadmin/openacs.tcl -u nsadmin
nsadmin   2319  2318  0 09:48 ?        00:00:00
/usr/local/aolserver/bin/nsd -i -t /home/nsadmin/openacs.tcl -u nsadmin
nsadmin   2320  2318  0 09:48 ?        00:00:00
/usr/local/aolserver/bin/nsd -i -t /home/nsadmin/openacs.tcl -u nsadmin
postgres  2321  1012  0 09:48 ?        00:00:00 postgres: nsadmin
openacs [local] idle
postgres  2322  1012  0 09:48 ?        00:00:00 postgres: nsadmin
openacs [local] idle
postgres  2323  1012  0 09:48 ?        00:00:00 postgres: nsadmin
openacs [local] idle
nsadmin   2324  2318  0 09:48 ?        00:00:00
/usr/local/aolserver/bin/nsd -i -t /home/nsadmin/openacs.tcl -u nsadmin
nsadmin   2325  2318  0 09:48 ?        00:00:00
/usr/local/aolserver/bin/nsd -i -t /home/nsadmin/openacs.tcl -u nsadmin
What does the idle mean, please?
Collapse
2: Response to postgres: nsadmin openacs [local] idle (response to 1)
Posted by Ben Adida on 06/01/01 06:21 PM
The idle means that these are open connections to PostgreSQL which are
not processing SQL statements. Because AOLserver keeps a pool of
connections open to the database, you will see this when your server
isn't very active. After an hour of being idle (typically, although
this is configurable), the connection will be closed, only to be
reopened the next time it is needed.

Thus, what you're seeing is totally normal.