Re: [GENERAL] close database, nomount state

paul rivers <privers(at)berkeley(dot)edu> wrote:

> 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
>

Thanks for your response,
that was exactly what I wanted to know. I was thinking about
pg_hba.conf but I was hoping there is some more elegant way
to do that :-)

Regards,
Lukas Houf