Re: Re: BUG #5065: pg_ctl start fails as administrator, with "could not locate matching postgres executable" - Mailing list pgsql-bugs

From Jesse Morris
Subject Re: Re: BUG #5065: pg_ctl start fails as administrator, with "could not locate matching postgres executable"
Date
Msg-id FEFD432EA8DD2D45B110ACE93F8200FF0535E110@sf-ex-1.migcoverity.net
Whole thread Raw
In response to Re: Re: BUG #5065: pg_ctl start fails as administrator, with "could not locate matching postgres executable"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
I've seen it happen on a wide range of win2k3 servers.  From a fresh
image with nothing but VMWare tools under Add/Remove Programs, to a
heavily used shared dev server with MSVC, Cygwin, and tons of other
stuff.  Some of our beta testers have also seen the issue.  In fact I
can't really think of any win2k3 machine where it *had* worked.  I
suspect the main reason reports of this failure are relatively rare is
that most people use the one-click installer which sets it up to run as
a non-administrator service account.  (That's superior in many ways, but
it is not always an option for me.)

It looks like something that happens with Win2k3 only; XP had the user
instead of Administrators in the DACL, and Vista appears to have the
Session.  I guess that's the only place that "AddUserToDacl" was even
necessary in the first place?  I dunno.

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Tuesday, October 20, 2009 9:45 AM
> To: Dave Page
> Cc: Andrew Dunstan; Jesse Morris; pgsql-bugs@postgresql.org; Magnus
> Hagander
> Subject: Re: [BUGS] Re: BUG #5065: pg_ctl start fails as
administrator,
> with "could not locate matching postgres executable"
>=20
> Dave Page <dpage@pgadmin.org> writes:
> > On Tue, Oct 20, 2009 at 3:48 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> >> Do we have any idea why?
>=20
> > Honestly? No. I have a vague hand-wavy idea about there being
> > something preventing us properly modifying the token of an existing
> > process in some configurations, but nothing even remotely
jello-like,
> > let alone concrete.
>=20
> After re-reading the thread I am struck by Jesse's comment that the
> current coding never worked at all for him.  It seems like that must
> indicate an environment difference or installed-software difference
> compared to the setups where it does work.  (Antivirus maybe?)
>=20
> Seems like it would be worth the trouble to identify exactly what the
> critical difference is.
>=20
>             regards, tom lane

pgsql-bugs by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: BUG #5127: AbstractJdbc2Connection#doRollback should throws Exception if connection is closed
Next
From: ""
Date:
Subject: BUG #5128: Returning nested composite types in plpython