sarlav kumar wrote:

> Hi All,
>  
> I was trying to drop the schema created by slony.
> When I issue the query
>  
> drop schema schemaname cascade;
>  
> I get a list of messages and then it hangs after the following:
>  
>  
> ....
> NOTICE:  drop cascades to sequence _ikobo_test.sl_log_status
> NOTICE:  drop cascades to sequence _ikobo_test.sl_rowid_seq
>  
> Can someone help me troubleshoot this problem?


Have you taken the slons down?

Have a look in pg_stat_activity to see what's accessing the database.  
My guess is that the slony schema _ikobo_test is still being used by 
something.

Brad.