Message-ID: <054ffbb250c1ea1713b0e9e91d038a4a9071fc94.camel@cybertec.at>
Subject: Re: Postgres service not starting on windows after install if not
 installed into standard locations
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Thomas Schweikle <tschweikle@bfs.de>, 
 "pgsql-general@lists.postgresql.org"
	 <pgsql-general@lists.postgresql.org>
Date: Mon, 18 Nov 2024 19:43:36 +0100
In-Reply-To: <cc79844c-a0fc-4c7d-a89f-556cfed6fe78@bfs.de>
References: <cc79844c-a0fc-4c7d-a89f-556cfed6fe78@bfs.de>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.52.4 (3.52.4-2.fc40) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/054ffbb250c1ea1713b0e9e91d038a4a9071fc94.camel%40cybertec.at>
Precedence: bulk

On Mon, 2024-11-18 at 17:22 +0000, Thomas Schweikle wrote:
> Had installed PostgreSQL 16.5 on Windows 10:
>=20
> Install directory: "C:\PRGS\pgSQL\16"
> DB-Directory:      "C:\DB\pgSQL\16\data"
>=20
> Environment variable "PGDATA" is set to "C:\DB\pgSQL\16\data".
>=20
> Initialized the database. Then started postgres services using:
>=20
> c:\PRGS\pgSQL\16\bin\pg_ctl.exe start
>=20
> Worked nice. Server starts, the serves as expected. But: if I try to=20
> start the service by "net start pgSQL" I am reported that "pg_ctl.exe"=
=20
> could not find "postgres.exe".
>=20
> What I've tried:
> - added environment variable "PGPATH" pointing to "C:\PRGS\pgSQL\16\bin"
>    -> did not help.
>=20
> - added "C:\PRGS\pgSQL\16\bin" to path. -> did not help either, even=20
> after rebooting. I've added it to system path.
>=20
> Are paths somewhere within some configuration file or registry entry?=20
> And set to standard install locations?

How exactly is the Windows service defined?
Perhaps you need to use an absolute path for the executable.

Yours,
Laurenz Albe