Re: Updated Cygwin Package: postgresql-7.4.2-1

"Jason Tishler" <jason(at)tishler(dot)net> wrote in message
news:20040611151956(dot)GA1960(at)tishler(dot)net(dot)(dot)(dot)
> New News:
> === ====
> I have updated the version of PostgreSQL to 7.4.2-1. The tarballs should
> be available on a Cygwin mirror near you shortly.
>
> The following are notable changes since the previous release:
>
> o build against cygserver instead of cygipc
> o upgrade to PostgreSQL 7.4.2
>

I was able to get both cygserver and postmaster to install as services under
XP Pro, but only cygserver will successfully run as a service.

postmaster fails to run as a service, either from the command line or the
control panel services applet. C:\cygwin\bin is in the system path.

Here is the error when run from a bash shell prompt:

$ cygrunsrv -S postmaster
cygrunsrv: Error starting a service: QueryServiceStatus: Win32 error 1062:
The service has not been started.

The Windows event viewer lists the following errors:

postmaster : PID 3388 : starting service `r' failed: redirect_fd: open (1,
/var/log/postmaster.log): 13, Permission denied.

postmaster : PID 2716 : starting service `postmaster' failed: execv: 1,
Operation not permitted.

postmaster seems to load normally from a command line with pg_ctl.

I tried installing it as a service to be run by the postgres user (with
privileges to run as a service) per the README, and then by my logon when
that failed.

Thanks,

David P. Lurie