Skip site navigation (1) Skip section navigation (2)

Re: BUG #5683: Service path incorrectly configured

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: donovansc(at)yahoo(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5683: Service path incorrectly configured
Date: 2010-09-30 13:39:21
Message-ID: 4CA49309.3030409@postnewspapers.com.au (view raw or flat)
Thread:
Lists: pgsql-bugs
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/

In response to

Responses

pgsql-bugs by date

Next:From: Craig RingerDate: 2010-09-30 14:08:27
Subject: Re: [BUGS] Mapping Hibernate boolean to smallint(Postgresql)
Previous:From: Dave PageDate: 2010-09-30 08:07:06
Subject: Re: BUG #5685: Installer Error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group