Re: Help: Postgresql on Microsoft cluster (MSCS)

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