postgre@seznam.cz wrote:
> Hello,
> I want to ask if there is something like nomount state or close database state
> in which I can acces postgresql to drop database or to do some other stuff.
>
> Because when there are some connections, drop database is not
> possible. Or is this done some other way?
>
> Lukas Houf
>
Short answer-- no.
Longer answer-- there's really no need for the Oracle-esque nomount
state in Pg. If you're doing media recovery, it's very much all or
nothing, cluster-wide. You are not going to do media recovery for a set
of tablespaces, for example. If you'd like to drop a database, you can
cut off connections (say, via pg_hba.conf or whatever floats your boat)
and drop it with a single command. It's not such a big deal as it is in
Oracle.
If this doesn't answer your question, could you say more about what your
issue is?
Regards,
Paul