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

-----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"

 

www.UrbanaSoft.com

----- Original Message -----

From: Seth Rubin

To: pgsql-cygwin@postgresql.org

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