Re: Windows XP (Home) Install tutorial - Mailing list pgsql-cygwin

From Seth Rubin
Subject Re: Windows XP (Home) Install tutorial
Date
Msg-id CNELLBDHOKALJPHOOBBEEEGEDGAA.srubin@thoughtprocess.com
Whole thread Raw
In response to Re: Windows XP (Home) Install tutorial  ("Vincent Hikida" <vhikida@inreach.com>)
List pgsql-cygwin
My modified README follows is at the end of this message:
 
 
(ignore footnote #14 about user-switching; Jason says that's no longer an issue)
 
-- Seth Rubin
   ThoughtProcess Technology LLC
 
-----Original Message-----
From: pgsql-cygwin-owner@postgresql.org [mailto:pgsql-cygwin-owner@postgresql.org]On Behalf Of Vincent Hikida
Sent: Tuesday, July 15, 2003 12:55 PM
To: Seth Rubin; pgsql-cygwin@postgresql.org
Subject: Re: [CYGWIN] Windows XP (Home) Install tutorial

I am an XP Home user and a newbie. I have installed postgres but for reference what was the url of the tutorial. I'll think over Roger's problem but of course  I can't promise anything.
 
Vincent Hikida,
Member of Technical Staff - Urbana Software, Inc.
"A Personalized Learning Experience"
 
----- Original Message -----
Sent: Tuesday, July 15, 2003 9:02 AM
Subject: Re: [CYGWIN] Windows XP (Home) Install tutorial

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

pgsql-cygwin by date:

Previous
From: "Vincent Hikida"
Date:
Subject: Re: Windows XP (Home) Install tutorial
Next
From: "Roger Ackroyd"
Date:
Subject: Re: Problems running PostgreSQL on Windows XP