Re: Start service

So, there were two issues.
Even though admin is in the admin group and had Full Control under
effective permissions, somehow that wasn't enough.
I noticed that I can run the v14 service, but it had Admin explicitly
listed with full control on Data.
Once I added that, I started getting error messages when run from CLI and
could fix the issue in pg_hba.conf.
Now the service starts.

Thanks,
Brad.

On Fri, Sep 22, 2023 at 2:43 PM <postgresql439848(at)heinz-it(dot)de> wrote:

> Am 22.09.23 um 20:40 schrieb Brad White:
> > I'm trying to start a v15 service on a Windows 2012 R2 server where it
> > hasn't been used for a while.
> > The service is set to run as pgUser.
> > pgUser owns the Postgres directory, including the data dir.
> >
> > The command the service is using is
> > ' "C:\Program Files\PostgreSQL\15\bin\pg_ctl.exe" runservice -N
> > "postgresql-x64-15" -D "C:\Program Files\PostgreSQL\15\data" -w'
> >
> > First off, it's interesting that "runservice" isn't listed as an option
> for
> > pg_ctl.
> >
> > Windows Event Viewer shows it starting up, handing off logging to pg_log,
> > then timing out.
> > Waiting for server startup...
> > 2023-09-22 12:31:15.173 CDT [5000] LOG: redirecting log output to
> > logging collector process
> > 2023-09-22 12:31:15.173 CDT [5000] HINT: Future log output will
> > appear in directory "pg_log".
> > Timed out waiting for server startup
> >
> > It does create a log file in pg_log, but it is empty.
> >
> > If I sub 'start' for 'runservice' and try to start it from CLI, I get
> > C:\Users\administrator>"C:\Program
> Files\PostgreSQL\15\bin\pg_ctl.exe"
> > start
> > -N "postgresql-x64-15" -D "C:\Program Files\PostgreSQL\15\data" -w
> > waiting for server to start....2023-09-22 12:48:05.438 CDT [4796]
> > FATAL: could
> > not create lock file "postmaster.pid": Permission denied
> > stopped waiting
> > pg_ctl: could not start server
> > Examine the log output.
> >
> > And again, I get an empty log file in pg_log.
> > Is there somewhere else I should check?
> >
> > I get the same results if I pass username and password with -U and -P
> >
> > I'm running as administrator, so not sure how I get permission denied
> > Checking EffectiveAccess shows that admin and pgUser have full control,
> so
> > I assume this message is a red herring, standing in for the real issue.
> >
> > Without an actual error message to fix, I'm not sure how to proceed.
> >
> > Thanks,
> > Brad.
> >
> if you want to run postgresql server then you could use "pg_ctl start ..."
> but to run it as a windows service you first need to register it as a
> service. so look at pg_ctl register in the options.
>
>
>