Thread: PostgreSQL and 2000 Service...

PostgreSQL and 2000 Service...

From
"Nick McCalip"
Date:
I have installed the latest Cygwin and it's PostgreSQL have gotten the database running just fine and have "ipc-daemon" and "postmaster" both running as services.   I can start postmaster as a service from the SERVICES console and it runs just fine as well.   However, even though I have the service set to startup automatically, fails to do so.   Once the computer finishes starting I can go and start the service manually, but of course, this will not suffice for production use.   I have reviewed the event logs to see if it might shed some light on why the service failed to start and found the following entry for the ipc-daemon (which did start):
 
Event Type: Information
Event Source: ipc-daemon
Event Category: None
Event ID: 0
Date:  10/25/2001
Time:  12:50:07 PM
User:  NT AUTHORITY\SYSTEM
Computer: FRANKENSTEIN
Description:
The description for Event ID ( 0 ) in Source ( ipc-daemon ) 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: ipc-daemon : Win32 Process Id = 0x284 : Cygwin Process Id = 0x284 : (ipc-daemon) 'ipc-daemon' service started.
 
 
When I start the service manually I get the following in the EventLog for the postmaster:
 
Event Type: Information
Event Source: postmaster
Event Category: None
Event ID: 0
Date:  10/25/2001
Time:  12:54:23 PM
User:  NT AUTHORITY\SYSTEM
Computer: FRANKENSTEIN
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 = 0x5D0 : Cygwin Process Id = 0x5D0 : `postmaster' service started.
I am pressuming something in how the ipc-daemon started prevented the postmaster from starting automatically.  I set the reccomonded environment variables (instead of the registry entries) for the ipc-daemon, so I am not sure what the problem is here.  
 
Has anyone else run across this before?  As I stated earlier, once I start the service manually I am able to run everything just fine.
 
Thanks for any help,
Nick McCalip
 

Re: PostgreSQL and 2000 Service...

From
"Nick McCalip"
Date:
In addition....
 
I forgot to mention that I have added the dependency paramater on LanmanWorkstation.  Currently my service command lines are as follows:
 
ipc-daemon --install-as-service
 
cygrunsrv -I postmaster -p /bin/postmaster -a "-D /home/Administrator/rr_data -i" -y ipc-daemon -y LanmanWorkstation -y tcpip -s INT -d "Rehab Data" -o
 
As I said previously, I can start it manually and with exception to the log message below it seems to work fine.   just can't get it to run at startup.
 
Thanks again,
Nick McCalip
 
 
>I have installed the latest Cygwin and it's PostgreSQL have gotten the database running just fine and have >"ipc->daemon" and "postmaster" both running as services.   I can start postmaster as a service from the >SERVICES console and it runs just fine as well.   However, even though I have the service set to startup >automatically, fails to do so.   Once the computer finishes starting I can go and start the service manually, but >of course, this will not suffice for production use.   I have reviewed the event logs to see if it might shed some >light on why the service failed to start and found the following entry for the ipc-daemon (which did start):
>
>Event Type: Information
>Event Source: ipc-daemon
>Event Category: None
>Event ID: 0
>Date:  10/25/2001
>Time:  12:50:07 PM
>User:  NT AUTHORITY\SYSTEM
>Computer: FRANKENSTEIN
>Description:
>The description for Event ID ( 0 ) in Source ( ipc-daemon ) 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: ipc-daemon : Win32 Process Id = 0x284 : Cygwin Process Id = >0x284 : (ipc-daemon) 'ipc-daemon' service started.
>
>
>When I start the service manually I get the following in the EventLog for the postmaster:
>
>Event Type: Information
>Event Source: postmaster
>Event Category: None
>Event ID: 0
>Date:  10/25/2001
>Time:  12:54:23 PM
>User:  NT AUTHORITY\SYSTEM
>Computer: FRANKENSTEIN
>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 = 0x5D0 : Cygwin Process Id = >0x5D0 : `postmaster' service started.
>I am pressuming something in how the ipc-daemon started prevented the postmaster from starting >automatically.  I set the reccomonded environment variables (instead of the registry entries) for the ipc->daemon, so I am not sure what the problem is here.  
>
>Has anyone else run across this before?  As I stated earlier, once I start the service manually I am able to run >everything just fine.
>
>Thanks for any help,
>Nick McCalip