Thread: Postgresql as service on domain controller
Hi,
I have tried to search thoroughly in the postgres archives to no avail for this.
I am running a Windows 2000 Domain controller. I want to install cygwin-postgres on the machine. I can install cygwin fine, cygipc fine and even postgres as a non-service fine.
But the instructions for installing postgres as a service are for non-domain controllers. E.g. cmd /c lusrmgr.msc. I have tried to create a domain user using the domain controller users utility. I have given permission for postgres to run a service.
But I keep getting various errors. E.g. Event Type: Error
Event Source: postmaster
Event Category: None
Event ID: 0
Date: 11/11/2003
Time: 11:50:07 AM
User: S-1-5-21-4255403601-721488846-2906522990-1135
Computer: SERVER
Description:
The description for Event ID ( 0 ) in Source ( postmaster ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: postmaster : Win32 Process Id = 0x1124 : Cygwin Process Id = 0x1124 : starting service `postmaster' failed: execv: 1, Operation not permitted.
I have successfully installed postgresql as a service on a non-domain controller, but really need to get it working on this domain controller.
Amit Kelkar
Senior Consultant
postmodern
02 9553 1749
Suite 206, 9 Crofts Avenue
Hurstville 2220
*******************Confidentiality and Privilege Notice*******************
This email is intended only to be read or used by the addressee.
It is confidential and may contain legally privileged information.
If you are not the addressee indicated in this message (or
responsible for delivery of the message to such person), you
may not copy or deliver this message to anyone, and you should
destroy this message and kindly notify the sender by reply email.
Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you.
postmodern
ABN 19 489 506 908
Attachment
Amit,
On Mon, Nov 17, 2003 at 05:58:27PM +1100, Amit Kelkar wrote:
> `postmaster' failed: execv: 1, Operation not permitted.
The above usually means postmaster (i.e., postgres.exe) is not
executable. Does the following from the README help?
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/*
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
Amit, Please keep your replies on-list. On Sat, Nov 22, 2003 at 09:56:18AM +1100, Amit Kelkar wrote: > I have tried that... its doesn't work. What I did try though is change > permissions from Windows 2000. That changed the error to execv: 255, > error: 255 > > Do you have any idea what this might mean? Sorry, no. 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