Re: Start service - Mailing list pgsql-general

From Brad White
Subject Re: Start service
Date
Msg-id CAA_1=93rAt9rt4HfBhi14zw=R8x+5HJU1hYaSDiXBidRBA-Gpw@mail.gmail.com
Whole thread Raw
In response to Re: Start service  (postgresql439848@heinz-it.de)
List pgsql-general
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@heinz-it.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.


pgsql-general by date:

Previous
From:
Date:
Subject: StackBuilder unexpected restart
Next
From: Dominique Devienne
Date:
Subject: Re: How to fork pg_dump or psql w/o leaking secrets?