Re: Postgres service not starting on windows after install if not installed into standard locations

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(dot)klaver(at)aklaver(dot)com