Re: win32 pgsql not installable

Magnus Hagander wrote:
> > > >I know I'm going to go on some people's nerves, but it's necessary.
> > > >
> > > >With the current "run-as-non-admin" restriction the
> > windows installer
> > > >doesn't work, and it will probably be ridiculously
> > difficult to make
> > > >it work unless this restriction is redesigned.
> > >
> > > Not commenting on the other parts, but *huh*? The windows installer
> > > works just fine. It does require that you manually set up a
> > non-admin
> > > account, but it certainly *works*...
> >
> > And you have to tell the system that user can start a service.
>
> Yes and no.
> The *service account* needs permissions to "Log On as a Service". It
> specifically does *NOT* need permission to start/stop services, or any
> other admin privileges.

Right, under Administrative Tools, Local Security, User Rights
Assignment, I added 'postgres' to "Log On as a Service".

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073