Re: BUG #5683: Service path incorrectly configured

On 29/09/2010 6:16 PM, donovansc(at)yahoo(dot)com wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5683
> Logged by:
> Email address: donovansc(at)yahoo(dot)com
> PostgreSQL version: 9.0.0
> Operating system: Windows7 x64
> Description: Service path incorrectly configured
> Details:
>
> The windows service for starting the database has an incorrectly configured
> execution path.
>
> By default, it is:
> C:/Program Files/PostgreSQL/9.0/bin/pg_ctl.exe runservice -N
> "postgresql-x64-9.0" -D "C:/Program Files/PostgreSQL/9.0/data" -w
>
> However, / is not valid for Windows. It should be:

How odd. Windows is usually perfectly happy with "/" as a command
separator. About the only time it usually objects is when executables
try to treat "/" as a command-line switch, something that's up to each
executable individually.

Here, I can run "Start->Run", paste in "C:/Program
Files/PostgreSQL/9.0/bin/" and Explorer opens the correct directory. I
can invoke the edb stackbuilder with:

"C:/Program Files/PostgreSQL/9.0/bin/stackbuilder.exe"

from start->run or via cmd.exe. No problems. (Some executables can't be
run unless you "cd" to their directory first, because they need the
local directory in the library search path, which is why I didn't use
psql as an example).

> C:\Program Files\PostgreSQL\9.0\bin\pg_ctl.exe runservice -N
> "postgresql-x64-9.0" -D "C:\Program Files\PostgreSQL\9.0\data" -w
>
> After altering this value in the registry at:
> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\postgresql-x64-9.0
> I am now able to start/stop the service normally.

So all you did was reverse the slashes?

Weird. My image path on win7 32bit is:

C:/Program Files/PostgreSQL/9.0/bin/pg_ctl.exe runservice -N
"postgresql-9.0" -D "C:/Program Files/PostgreSQL/9.0/data" -w

and it launches quite happily.

It'd be really helpful if you could provide the contents of the Windows
error log from when you attempted to start the service before making the
change. You can get to the Event Viewer in the Start menu on Win7.

--
Craig Ringer

Tech-related writing at http://soapyfrogs.blogspot.com/