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

From: Thomas Schweikle <tschweikle(at)bfs(dot)de>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Postgres service not starting on windows after install if not installed into standard locations
Date: 2024-11-18 17:22:01
Message-ID: cc79844c-a0fc-4c7d-a89f-556cfed6fe78@bfs.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

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?

Any idea is welcome to solve this problem!

--
Thomas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2024-11-18 17:48:56 Re: Postgres service not starting on windows after install if not installed into standard locations
Previous Message Alexandru Lazarev 2024-11-18 16:11:15 Re: work_mem RAM Accounting in PostgreSQL