Skip site navigation (1) Skip section navigation (2)

Re: force drop of database others are accessing

From: "Lee Harr" <missive(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: force drop of database others are accessing
Date: 2004-01-24 07:46:30
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
>>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 trick is to start your own script (which probably
>isn't "failing" exactly, but blocking, right?), and then (since
>you've locked the relevant objects that way, such that nobody else
>can get in) use the shell to kill -2 other connections.  Evil and
>possibly dangerous, but you said you didn't care about the old data.

Yea, grepping through the output from ps and killing the other
backend process was my first thought.  The only problem is
that the user that owns the database (and runs the automatic
report script) is not necessarily the one that is causing the
problem. 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.

The new MSN 8: smart spam protection and 2 months FREE*


pgsql-general by date

Next:From: Kris JurkaDate: 2004-01-24 07:52:05
Subject: Re: force drop of database others are accessing
Previous:From: Eric B.RidgeDate: 2004-01-24 07:44:12
Subject: Re: Touch row ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group