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 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
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 message
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 Fi
I created the pid file by hand and 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 -U
TMA\pgUse
r -P ***
pg_ctl: another server might be running; trying to start server
anyway
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,
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
