Re: Help: Postgresql on Microsoft cluster (MSCS)

2010/1/25 Craig Ringer <craig(at)postnewspapers(dot)com(dot)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 the same 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/