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

From Thomas Schweikle
Subject Re: Postgres service not starting on windows after install if not installed into standard locations
Date
Msg-id cd6cb898-8428-4bf8-a6da-094c62aec139@bfs.de
Whole thread Raw
In response to Re: Postgres service not starting on windows after install if not installed into standard locations  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Am Mo., 18.Nov..2024 um 18:48:56 schrieb Adrian Klaver:
> On 11/18/24 09:22, Thomas Schweikle wrote:
>> Hi!
>>
>> Had installed PostgreSQL 16.5 on Windows 10:
> 
> Using what installer?

postgresql-16.5-1-windows-x64.exe as found on 
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads


>> 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

pgsql-general by date:

Previous
From: Lucía Rotger
Date:
Subject: Re: Fwd: Error when opening pgAdmin
Next
From: Sreejith P
Date:
Subject: Suddenly all queries moved to seq scan