Thread: delete DB with connection destroy?

delete DB with connection destroy?

From
"Nikolai Cheltsov"
Date:
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?

From
Cedric BUSCHINI
Date:
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