List Info

Thread: delete DB with connection destroy?




delete DB with connection destroy?
user name
2007-10-24 10:16:00
Hi,

Is there a possibility to delete a DB, when there are still connections to it? Something like force delete. Delete and if there are connections, kill them!

Regards,
Nikolay Cheltsov
Re: delete DB with connection destroy?
user name
2007-10-24 10:43:13
Nikolai Cheltsov a écrit :
> Hi,
>
> Is there a possibility to delete a DB, when there are
still 
> connections to it? Something like force delete. Delete
and if there 
> are connections, kill them!
>
> Regards,
> Nikolay Cheltsov
Hi,

Why don't you force the deconnexion stopping the database
with 'pg_ctl 
stop -D $PGDATA -m fast' and restart it in single-mode ?

Ced.

-- 

 Cedric BUSCHINI
    - CARAX -
  IT Department

Phone : + 33 1 4006 9864
fax   : + 33 1 4006 9865


---------------------------(end of
broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by
donating at

                http://www.pos
tgresql.org/about/donate

[1-2]

about | contact  Other archives ( Real Estate discussion Medical topics )