Обсуждение: Run postmaster as a NT service with invoker 1.53

Поиск
Список
Период
Сортировка

Run postmaster as a NT service with invoker 1.53

От
"Éric Prévost-Dansereau"
Дата:
Hi,
 
I'm trying to run Postgresql 7.0.2 on a NT 4 server. I can start postmaster and ipc-deamon with no problem from commandline or bash.
 
Now, I want to run these software as services with invoker 1.53. ipc-deamon work well, but I have problems with postmaster.
 
First, I modify the system PATH and add PGLIB and PGDATA in system environnement. Using my postgresql user, i can start postmaster from cmd without any problems. But when i start it as a service, i get the following error:
 
Error 203: The system could not find the environment option that was entered.
 
My registry for pgsql service is like that:
 
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\pgsql]
"Type"=dword:00000010
"Start"=dword:00000003
"ErrorControl"=dword:00000001
"ImagePath"="c:\\winnt\\system32\\invoker.exe"
"DisplayName"="pgsql"
"ObjectName"="postgresql"
 
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\pgsql\Parameters]
"Application"="d:\\cygwin\\usr\\ocal\\pgsql\\bin\\postmaster"
"AppParameters"="-i"
 
 
Have an idea?
 
Thank you.
 
 
Eric Prevost
 
 

Re: Run postmaster as a NT service with invoker 1.53

От
Jason Tishler
Дата:
Eric,

On Sat, Dec 02, 2000 at 02:58:06PM -0500, Xric PrXvost-Dansereau wrote:
>    Now, I want to run these software as services with invoker 1.53.
>    ipc-deamon work well, but I have problems with postmaster.

Try searching the archives, there have been recent posts demonstrating
various approaches to running postmaster as a service.  May be one of
these will work well enough for you.

>    [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\pgsql\Parameters]
>    "Application"="d:\\cygwin\\usr\\ocal\\pgsql\\bin\\postmaster"
                                     ^
                                     +-- Is this a typo (i.e., missing an "l")?
>    "AppParameters"="-i"
>
>    Have an idea?

By default, postmaster is a symlink to postgres.exe.  So unless you did
something to workaround this, NT will not be able to start postmaster since
it does not grok symlinks.  The simplest solution to this issue is to
delete the symlink and copy postgres.exe to postmaster.exe.

Jason

--
Jason Tishler
Director, Software Engineering       Phone: +1 (732) 264-8770 x235
Dot Hill Systems Corporation         Fax:   +1 (732) 264-8798
82 Bethany Road, Suite 7             Email: Jason.Tishler@dothill.com
Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com