Re: Problem with initdb failing

Jason,

I changed the group ownership of the files to "Administrators". Is this what
you meant by run mkgroup? Or, do I need to do anything else?

I also set the modes of the files as suggested (I had tried this previously
too) -- /tmp /usr/bin /usr/log.

I searched all over for a postmaster.log file and can not find one (I have
not been able to get to the step that I start the postmaster yet, so this
might explain not having the log, but I don't know if the "install" command
should have been logged..) The only .log files I found were from the cygwin
install ....

I still get the following when I tried to start ipc-daemon2 and postmaster:

paul_sand(at)mverify3 /var/log
$ cygrunsrv -S ipc-daemon2
cygrunsrv: Error starting a service: QueryServiceStatus: Win32 error 1062:
The service has not been started.

paul_sand(at)mverify3 /var/log
$ cygrunsrv -Q ipc-daemon2
Service ipc-daemon2 exists
Type : Own Process
Current State : Stopped
Controls Accepted :

paul_sand(at)mverify3 /var/log
$ cygrunsrv -Q postmaster
Service postmaster exists
Type : Own Process
Current State : Stopped
Controls Accepted :

paul_sand(at)mverify3 /var/log
$ cygrunsrv -S postmaster
cygrunsrv: Error starting a service: StartService: Win32 error 1068:
The dependency service or group failed to start.

It seems that if I can get ipc-daemon to run postmaster will probably work

paul_sand(at)mverify3 /var/log
$

Regards,

Paul

-----Original Message-----
From: Jason Tishler [mailto:jason(at)tishler(dot)net]
Sent: Friday, October 31, 2003 12:02 PM
To: Paul R. Sand
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: [CYGWIN] Problem with initdb failing

Paul,

On Fri, Oct 31, 2003 at 11:06:52AM -0600, Paul R. Sand wrote:
> Yes, this solves the problem. I am up and running with the basic
> installation.

Good.

> $ ls -l /usr/AMATE/
> total 0
> drwx------+ 6 paul_san mkgroup- 0 Oct 31 10:27 data
^^^^^^^^
> [snip]

BTW, the mkgroup- above implies that you need to run mkgroup.

>
> paul_sand(at)mverify3 ~
> $ cygrunsrv -S ipc-daemon2
> cygrunsrv: Error starting a service: QueryServiceStatus: Win32 error
1062:
> The service has not been started.

What does /var/log/postmaster.log indicate? Ditto for the NT
(Application) Event Log.

Does the following from the README apply?

4. Cygwin PostgreSQL can fail to start or not function properly if
certain files and directories have incorrect permissions. The
following usually solves these kinds of problems:

$ chmod a+rwx /tmp
$ chmod a+rx /usr/bin /usr/bin/*
$ chmod a+rw /var/log # could adversely affect other daemons

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6