Re: [GENERAL] force drop of database others are accessing

2004-01-24 Thread Lee Harr
So that means somehow I need to kick off another script with elevated priveleges to take care of it ... I would rather not have to do that, but I do not see another way. If you are creating a database from scratch why not create a brand new database and drop the old one at some later point in time

Re: [GENERAL] force drop of database others are accessing

2004-01-24 Thread Kris Jurka
On Sat, 24 Jan 2004, Lee Harr wrote: > >>Every once in a while my automated script fails because > >>some other system which should have disconnected > >>failed to unhook. The old data and old connection are > >>not important to me. The new run needs to go through. > > > >You can look for people

Re: [GENERAL] force drop of database others are accessing

2004-01-24 Thread Lee Harr
Every once in a while my automated script fails because some other system which should have disconnected failed to unhook. The old data and old connection are not important to me. The new run needs to go through. You can look for people connected and kick them out with kill -2 on their pid. The tr