Re: high-availability on MS Windows cluster -- need insights

Good points. FYI, I read the 8.2.5 manual, then did some additional
searching, and reviewed Elmasri "Fundamentals of Database Systems, 3rd
ed (text from MS CompSci course on DBMS design). Then emailed an
analysis and the tradeoffs as best I understood them to the user and
requested additional info and requirements (no response so far --
holidays). Also Only then did I begin posting requests for help, in
preparation for getting those answers back from the user.

It is beginning to sound like I should have waited until we had the
prototype testbed up and running, and then post specific questions when
we ran into roadblocks. I was just hoping to leverage the experience
of others to avoid the roadblocks in the first place.

Sorry about the signature line. It is required here. However, I'll try
posting from home in the future.

> -----Original Message-----
> From: Andrew Sullivan [mailto:ajs(at)crankycanuck(dot)ca]
> Sent: Thursday, December 27, 2007 9:31 AM
> To: pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] high-availability on MS Windows cluster
> -- need insights
>
> On Thu, Dec 27, 2007 at 07:45:36AM -0800, George, Harry G wrote:
> > A user asked for help re high-availability on MS Windows.
> While I'm
>
> Well, the first thing to do is define what you mean by "high
> availability".
> There's a good discussion of this in the manual. The manual
> does not, however, go over all the options you might have; so
> once you've determined which problem(s) you're trying to
> solve, we might be able to help you :)
>
> > Notice: This communication may contain sensitive
> information. If you
>
> [&c.] Just to warn you, there are some people around here who
> are very sensitive tot hese sorts of automatic
> corporate-policy footers. If you can disable it for sending
> to the list, that'd be good. (If you can get your legal
> department to understand why it's bad to append such things
> in a public posting, even better.)
>
> A
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>