public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: Thomas Schweikle <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: Postgres service not starting on windows after install if not installed into standard locations
Date: Wed, 20 Nov 2024 09:15:42 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
<[email protected]>
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
[email protected]
view thread (3+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Postgres service not starting on windows after install if not installed into standard locations
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox