| From: | Brad White <b55white(at)gmail(dot)com> |
|---|---|
| To: | |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Start service |
| Date: | 2023-09-22 18:56:44 |
| Message-ID: | CAA_1=908fwML_biPRWGJsdARBmq8ezVVcmproCs3u0iudiosBg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)ivanov(at)enterprisedb(dot)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(at)gmail(dot)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
> www.enterprisedb.com
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | postgresql439848 | 2023-09-22 19:05:04 | Re: debugger from superuser only.... why? |
| Previous Message | Tom Lane | 2023-09-22 18:56:11 | Re: How to fork pg_dump or psql w/o leaking secrets? |