Re: Postgres service not starting on windows after install if not installed into standard locations - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Postgres service not starting on windows after install if not installed into standard locations
Date
Msg-id 054ffbb250c1ea1713b0e9e91d038a4a9071fc94.camel@cybertec.at
Whole thread Raw
In response to Postgres service not starting on windows after install if not installed into standard locations  (Thomas Schweikle <tschweikle@bfs.de>)
Responses Re: Postgres service not starting on windows after install if not installed into standard locations
List pgsql-general
On Mon, 2024-11-18 at 17:22 +0000, Thomas Schweikle wrote:
> Had installed PostgreSQL 16.5 on Windows 10:
>
> Install directory: "C:\PRGS\pgSQL\16"
> DB-Directory:      "C:\DB\pgSQL\16\data"
>
> Environment variable "PGDATA" is set to "C:\DB\pgSQL\16\data".
>
> Initialized the database. Then started postgres services using:
>
> c:\PRGS\pgSQL\16\bin\pg_ctl.exe start
>
> Worked nice. Server starts, the serves as expected. But: if I try to
> start the service by "net start pgSQL" I am reported that "pg_ctl.exe"
> could not find "postgres.exe".
>
> What I've tried:
> - added environment variable "PGPATH" pointing to "C:\PRGS\pgSQL\16\bin"
>    -> did not help.
>
> - added "C:\PRGS\pgSQL\16\bin" to path. -> did not help either, even
> after rebooting. I've added it to system path.
>
> Are paths somewhere within some configuration file or registry entry?
> 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



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Postgres service not starting on windows after install if not installed into standard locations
Next
From: Laurenz Albe
Date:
Subject: Re: work_mem RAM Accounting in PostgreSQL