Feedback-ID: i76984098:Fastmail
Message-ID: <ba1b33e1-3018-435d-a803-a5470fc54876@aklaver.com>
Date: Wed, 20 Nov 2024 09:15:42 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Postgres service not starting on windows after install if not
 installed into standard locations
To: Thomas Schweikle <tschweikle@bfs.de>,
 "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <cc79844c-a0fc-4c7d-a89f-556cfed6fe78@bfs.de>
 <054ffbb250c1ea1713b0e9e91d038a4a9071fc94.camel@cybertec.at>
 <44c72245-7cb5-47bd-a6b5-e15d0b2a487e@bfs.de>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <44c72245-7cb5-47bd-a6b5-e15d0b2a487e@bfs.de>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/ba1b33e1-3018-435d-a803-a5470fc54876%40aklaver.com>
Precedence: bulk

On 11/20/24 05:26, Thomas Schweikle wrote:
> Am Mo., 18.Nov..2024 um 19:43:36 schrieb Laurenz Albe:
>> On Mon, 2024-11-18 at 17:22 +0000, Thomas Schweikle wrote:
>>> Had installed PostgreSQL 16.5 on Windows 10:

>> How exactly is the Windows service defined?
>> Perhaps you need to use an absolute path for the executable.
> 
> Servicename: postgresql-x64-16
> Name:        postgresql-x64-16-PostgreSQL Server 16
> Comment:     Provides relational database storage
> Path:        "C:\PRGS\pgSQL\16\bin\pg_ctl.exe"
>                runservice -N "postgresql-x64-16"
>                -D "C:\DB\pgSQL\16\data" -w
> Type:        Automatic
> Account:     Networkservice
> Password:    set
> Dependencies:RPC, DCOM-Service, RPC-Endpoint


Did you change settings during the install?

Here on my Windows machine I get:

C:\Program Files\PostgreSQL\bin

> 
> Errors found within system logs:
> pg_ctl: could not find program 'postgres.exe'
> 
> Seems, since "C:\PRGS\pgSQL\16\bin" is in system path, it does not
> search there at all:
> 
> # dir "C:\PRGS\pgSQL\16\bin"
> [...]
> Mi, 13.Nov.2024  13:24           123.392 pg_ctl.exe
> [...]
> Mi, 13.Nov.2024  13:24         8.659.968 postgres.exe
> 
> Any way to tell a service in Windows to use a path?
> Any registry key to assign a path to?
> 
> # sc qc "postgresql-x64-16"
> [SC] QueryServiceConfig ERFOLG
> 
> SERVICE_NAME: postgresql-x64-16
>           TYPE               : 10  WIN32_OWN_PROCESS
>           START_TYPE         : 2   AUTO_START
>           ERROR_CONTROL      : 1   NORMAL
>           BINARY_PATH_NAME   : "C:\PRGS\pgSQL\16\bin\pg_ctl.exe"
> runservice -N "postgresql-x64-16" -D "C:\DB\pgSQL\16\data" -w
>           LOAD_ORDER_GROUP   :
>           TAG                : 0
>           DISPLAY_NAME       : postgresql-x64-16 - PostgreSQL Server 16
>           DEPENDENCIES       : RPCSS
>           SERVICE_START_NAME : NT AUTHORITY\NetworkService
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com