Re: Taking database offline

From: Oli Sennhauser <oli(dot)sennhauser(at)bluewin(dot)ch>
To: ow <oneway_111(at)yahoo(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Taking database offline
Date: 2003-11-13 08:12:52
Message-ID: 3FB33D04.5050600@bluewin.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)sennhauser(at)bluewin(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message dojie pornea 2003-11-13 13:39:23 can't connect to PostgreSQL Database using pgAdminII
Previous Message ow 2003-11-13 07:10:09 Logging: statements and users