Grouper Users - Open Discussion List

[Keith Hazelton <>]

Probably postgres, yes. (see my just-previous email).  It's only a minor 
inconvenience, so I'm going to let it go. Thanks Chris & Gagné.

        --Keith
_____________
On Jan 25, 2013, at 10:23:27, Gagné Sébastien wrote:

> Could it be database monitoring tools ? Or something Postgres is doing ?
> 
> -----Message d'origine-----
> De : 
> 
>  
> [mailto:]
>  De la part de Chris Hyzer
> Envoyé : 25 janvier 2013 11:20
> À : Keith Hazelton; 
> 
> Objet : RE: [grouper-users] Question re recurring connections to the 
> grouperdb
> 
> 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
>