Grouper Users - Open Discussion List

[Gagné Sébastien <>]

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