Re: Taking database offline - Mailing list pgsql-admin

From Oli Sennhauser
Subject Re: Taking database offline
Date
Msg-id 3FB33D04.5050600@bluewin.ch
Whole thread Raw
In response to Re: Taking database offline  (ow <oneway_111@yahoo.com>)
Responses Re: Taking database offline  (ow <oneway_111@yahoo.com>)
List pgsql-admin
Hello

>Not really ... users (old or new) should not work with the db unless it's
>completely loaded. Restarting the server will affect activity in other dbs in
>that cluster which is not desirable :(  IMHO, there should be a way to do this
>without restarting the server.
>
>
What about having two database clusters on a server for separating HA
from "not so HA" databases? You can take down one db cluster. And people
can still work on the other one (DB Cluster does nothing has to do with
hardware or os cluster).

I know it is not so simple. I worked out a concept for this and need
some alpha-Testers?

Regards Oli

-------------------------------------------------------

Oli Sennhauser
Database-Engineer (Oracle & PostgreSQL)
Rebenweg 6
CH - 8610 Uster / Switzerland

Phone (+41) 1 940 24 82 or Mobile (+41) 79 450 49 14
e-Mail oli.sennhauser@bluewin.ch
Website http://mypage.bluewin.ch/shinguz/PostgreSQL/

Secure (signed/encrypted) e-Mail with a Free Personal SwissSign ID: http://www.swisssign.ch

Import the SwissSign Root Certificate: http://swisssign.net/cgi-bin/trust/import


Attachment

pgsql-admin by date:

Previous
From: ow
Date:
Subject: Logging: statements and users
Next
From: Christopher Browne
Date:
Subject: Re: Upgrading to Solaris 9