Grouper Users - Open Discussion List

[Keith Hazelton <>]

I don't have any non-exited gsh sessions that I know of. Here's a partial 
list from ps aux  --k

----------
...
postgres 16947  0.0  0.1  53512  3428 ?        S     2012  10:18 
/usr/bin/postgres -D /var/lib/pgsql/data
postgres 16948  0.0  0.0  17608   616 ?        Ss    2012   7:20 postgres: 
logger process                
postgres 16950  0.0  1.6  53756 34392 ?        Ss    2012  41:17 postgres: 
writer process                
postgres 16951  0.0  0.0  53512   632 ?        Ss    2012  33:15 postgres: 
wal writer process            
postgres 16952  0.0  0.0  53772   876 ?        Ss    2012   9:45 postgres: 
autovacuum launcher process   
postgres 16953  0.0  0.0  17676   632 ?        Ss    2012  10:33 postgres: 
stats collector process       
root     18058  0.0  0.0      0     0 ?        S    08:18   0:00 [kworker/2:2]
root     18150  0.0  0.1  11616  3388 ?        S    08:33   0:00 sshd: 
khazelton [priv]
500      18153  0.0  0.0  11616  1580 ?        R    08:33   0:00 sshd: 
khazelton@pts/1
500      18154  0.0  0.0   5168  1628 pts/1    Ss   08:33   0:00 -bash
root     18177  0.0  0.1   8444  2160 pts/1    S    08:33   0:00 sudo bash
root     18179  0.0  0.0   5300  1724 pts/1    S    08:33   0:00 bash
root     18300  0.0  0.0      0     0 ?        S    Jan13   0:00 [kworker/3:0]
root     19091  0.0  0.0      0     0 ?        S    11:30   0:00 [kworker/1:2]
apache   19526  0.0  1.0  70608 21612 ?        Sl   13:30   0:00 
/usr/sbin/httpd
root     19563  0.0  0.0      0     0 ?        S    13:40   0:00 [kworker/0:0]
postgres 19956  0.0  0.4  54900  8832 ?        Ss   15:00   0:01 postgres: 
grouper grouperdb 127.0.0.1(39033) idle
root     20338  0.0  0.0   4928  1052 pts/1    R+   16:29   0:00 ps aux
...
----------
_____________
On Jan 25, 2013, at 10:20:29, Chris Hyzer wrote:

> Tomcat(s), loader, gsh is all I can think of...
> 
> Thanks,
> Chris
> 
> -----Original Message-----
> From: 
> 
>  
> [mailto:]
>  On Behalf Of Keith Hazelton
> Sent: Friday, January 25, 2013 11:13 AM
> To: 
> 
> Subject: [grouper-users] Question re recurring connections to the grouperdb
> 
> I've been cloning instances of Grouper from one host to another with 
> success.
> 
> One task is to drop the Grouper database (grouperdb in Postgres), then 
> re-create and reload it.
> 
> The Grouper Tomcat instance is shut down. Grouper Loader is not running.
> 
> When I drop the connections in preparation to drop the database, new 
> connections keep being spontaneously made.
> 
> ----------
> postgres=# psql
> select pg_terminate_backend(procpid) from pg_stat_activity where datname = 
> 'grouperdb';
> ----------------------
> t
> t
> (2 rows)
> 
> - I have to repeat the above select statement sometimes twice or more until 
> following drop command succeeds 
> 
> postgres=# drop database grouperdb;
> DROP DATABASE
> ----------
> 
> I'm not sure what process is generating new connections. The 3CPO 
> connection manager? Is there a way to stop whatever it is?
> 
>        Thanks in advance,   --Keith
>