Postgres Pro
Downloads
Home   >   mailing lists

Re: Start service - Mailing list pgsql-general

From Brad White
Subject Re: Start service
Date
Msg-id CAA_1=908fwML_biPRWGJsdARBmq8ezVVcmproCs3u0iudiosBg@mail.gmail.com
Whole thread Raw
In response to Start service  (Brad White <b55white@gmail.com>)
Responses Re: Start service
List pgsql-general
Tree view
Good guess, but no. I should have mentioned that I checked that.

There is, though, a postmaster.opts file that wasn't there earlier. It contains
      C:/Program Files/PostgreSQL/15/bin/postgres.exe  "-D"  "C:\Program Files\PostgreSQL\15\data"
Note the lack of quotes around the exe path.

On Fri, Sep 22, 2023 at 1:48 PM Nick Ivanov <nick.ivanov@enterprisedb.com> wrote:
I'd check if there is already "postmaster.pid" in C:\Program Files\PostgreSQL\15\data, left over from a previous abend.

On Fri, Sep 22, 2023 at 2:40 PM Brad White <b55white@gmail.com> wrote:
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.
...
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

--
Nick Ivanov 
Solution Architect   

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to fork pg_dump or psql w/o leaking secrets?
Next
From: postgresql439848@heinz-it.de
Date:
Subject: Re: debugger from superuser only.... why?