Re: close database, nomount state

[paul rivers <privers(at)berkeley(dot)edu>]

postgre(at)seznam(dot)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