[GENERAL] Re: [GENERAL] close database, nomount state

2008-05-05 Thread postgre
paul rivers <[EMAIL PROTECTED]> 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

Re: [GENERAL] close database, nomount state

2008-04-29 Thread paul rivers
[EMAIL PROTECTED] 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? Luka

Re: [GENERAL] close database, nomount state

2008-04-28 Thread Vivek Khera
On Apr 28, 2008, at 6:50 PM, [EMAIL PROTECTED] wrote: 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. change the permissions on the DB so nobody can log in. you really should find

[GENERAL] close database, nomount state

2008-04-28 Thread postgre
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 -- Sent via pgsql