Thread: 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

2010/1/25 Craig Ringer <craig@postnewspapers.com.au>:
> 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
thesame machine, or on different machines via shared storage, you *can't* *do* *that*. 

MSCS shared disk clusters make sure oinly one node has the disk mapped
at the same time, so that's not the problem.


>> 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) ?

That's where you need to go, yes.

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/