Thread: BUG #17747: Registry entry "Base Directory" is not populated if you only install Command-line tools

The following bug has been logged on the website:

Bug reference:      17747
Logged by:          Jeff Laing
Email address:      jeff.laing@synchronoss.com
PostgreSQL version: 15.1
Operating system:   Windows
Description:

Our environment launches psql.exe via an intermediary application which
locates it by scanning the registry.

When a full installation of PostgreSQL is present, the
HKLM\SOFTWARE\PostgreSQL\Installations\postgresql-x64-14\Base Directory
value can be retrieved and the full path to psql.exe determined.

If a command-line-tools-only installation was used, this registry value is
not populated.


To be clear, we scan ALL registry keys under HKLM\SOFTWARE\PostgreSQL\Installations\ and launch the psql.exe that is located in the HIGHEST version.

 

I’m not reporting that installing 15.1 does not populate the 14 keys.

 

The perils of cut/pasting from a live RegEdit session…

 

From: PG Bug reporting form <noreply@postgresql.org>
Sent: Thursday, 12 January 2023 10:37 AM
To: pgsql-bugs@lists.postgresql.org
Cc: Jeff Laing <Jeff.Laing@synchronoss.com>
Subject: BUG #17747: Registry entry "Base Directory" is not populated if you only install Command-line tools

 

 

The following bug has been logged on the website:

 

Bug reference:      17747

Logged by:          Jeff Laing

Email address:      jeff.laing@synchronoss.com

PostgreSQL version: 15.1

Operating system:   Windows

Description:        

 

Our environment launches psql.exe via an intermediary application which

locates it by scanning the registry.

 

When a full installation of PostgreSQL is present, the

HKLM\SOFTWARE\PostgreSQL\Installations\postgresql-x64-14\Base Directory

value can be retrieved and the full path to psql.exe determined.

 

If a command-line-tools-only installation was used, this registry value is

not populated.

 

Hi,

On Wed, Jan 11, 2023 at 11:37:25PM +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Our environment launches psql.exe via an intermediary application which
> locates it by scanning the registry.
>
> When a full installation of PostgreSQL is present, the
> HKLM\SOFTWARE\PostgreSQL\Installations\postgresql-x64-14\Base Directory
> value can be retrieved and the full path to psql.exe determined.
>
> If a command-line-tools-only installation was used, this registry value is
> not populated.

Installers are handled outside of the project.  I believe this is EDB
installer, so this is something you will have to address directly with them (or
with the company that produces the installer you're using).