Re: Help: Postgresql on Microsoft cluster (MSCS) - Mailing list pgsql-general

From Craig Ringer
Subject Re: Help: Postgresql on Microsoft cluster (MSCS)
Date
Msg-id 4B5D743D.7090108@postnewspapers.com.au
Whole thread Raw
In response to Help: Postgresql on Microsoft cluster (MSCS)  (Steeles <steeles@gmail.com>)
Responses Re: Help: Postgresql on Microsoft cluster (MSCS)  (Magnus Hagander <magnus@hagander.net>)
List pgsql-general
On 25/01/2010 12:21 PM, Steeles wrote:
> As title, please help.
> I want to setup Postgresql HA by MSCS in VMWARE platform. (win server
> 2003, PG 8.3 on 32 bit)
> MSCS has been setup, the problem can't start postgresql service.
> PGDATA is on the shared disk.

Are you trying to share a PostgreSQL data directory between more than
one postmaster? It doesn't matter if they're on the same machine, or on
different machines via shared storage, you *can't* *do* *that*.

Look into replication options - see the postgresql wiki.

> I tried generic service, and application, either one won't bring up
> postgresql database engine service.

Error message?

Contents of Windows error log (see event viewer) ?

PostgreSQL error log entries (in `pg_log' under data directory) ?

--
Craig Ringer

pgsql-general by date:

Previous
From: Herouth Maoz
Date:
Subject: Re: Questions about connection clean-up and "invalid page header"
Next
From: Craig Ringer
Date:
Subject: Re: Updates: all or partial records