Hi Roger,
Saw your query on the forum, no need to go off.
One guess. On the Services window, the "Log On As" for your "postmaster" service should read ".\postgres". If it doesn't, that's your problem. Remove the service and try creating it again.
One other guess. Log on as "postgres" and see if initdb created files in /usr/share/postgresql/data (you have to log in as postgres - you won't see them from your Owner account).
If that doesn't cover it, my apologies. Something weird in your postgres account setup, maybe? Sorry, I'm barely more than a newbie myself.
-----Original Message-----
From: Roger Ackroyd [mailto:roger@ackroyd.freeserve.co.uk]
Sent: Tuesday, July 15, 2003 11:11 AM
To: srubin@thoughtprocess.com
Subject: Windows XP (Home) Install tutorial
Hi Seth
Sorry to trouble you off forum. I am hoping that you as an XP Home user may be able to help.
I have followed the tutorial as per your amendments to Jason Tishler's original on subject.
I can create the database from the postgres user account at step [8] with an OK result. (Everthing else I did from the Owner account)
When I attempt to start postmaster at step [9]
net start postmaster fails with
FATAL: File /usr/share/postgresql/data/PG_VERSION is missing. This is not a valid data directory.
(I presume that from Owner account I cannot 'see' contents of .../data once I have granted ownership to postgres account at step 6.
Jason thinks it is an issue with XP home but is unable to help further (no platform available).
As I am new(ish) to both cygwin and postgresql, I am not really sure what to look for or try next. I was hoping you might a) Know what is the cause or b) What commands I might use to check the environment and hopefully pinpoint the issue.
Am aware it is a long ongoing issue but have failed to find anything else to try other than what I have done up to press.
Any ideas will be most appreciated.
Sincerely
Roger
