Re: can't start postmaster as service - Mailing list pgsql-cygwin

From Andy Lowe
Subject Re: can't start postmaster as service
Date
Msg-id 000601c2e403$14bf2060$c201a8c0@andy
Whole thread Raw
In response to Re: can't start postmaster as service  (Jason Tishler <jason@tishler.net>)
Responses Re: can't start postmaster as service  (Jason Tishler <jason@tishler.net>)
List pgsql-cygwin
>The above looks fine -- the name is just "pgdata" instead of the more
conventional "data".
I had an old test database living in the data directory, and figured I
would use a clean directory.

>> I'm able to start postmaster from the command line as the postgres
>> user.  The service just fails to start, giving error 1062.  As you
>> noted below, this is not good.  Is there a known cause for this error

>> and (hopefully) a solution?
>
>Do you see anything interesting in /var/log/postmaster.log?  In the NT
>Event Log?
Yeah, there were a couple of interesting things in the event log.  The
short version is that it looks like I made a typeo when I installed the
service, so uninstalling and reinstalling it worked.

I had previously been running 7.2.1 from my normal user account.  When I
installed 7.3.2, it looks like permissions on the log file didn't get
set to allow the postgres user to have access to it.  That's probably
just one of those things that people aren't supposed to do, but if
someone does do it, the postmaster log won't end up having anything in
it from the newer installation.  Of course, the only time postgres has
problems is when people like me do things we're not supposed to, so it's
probably not a big deal :)

Thanks for the help.

Andy



pgsql-cygwin by date:

Previous
From: Jason Tishler
Date:
Subject: Re: can't start postmaster as service
Next
From: Jason Tishler
Date:
Subject: Re: can't start postmaster as service