Questions on PostgreSQL 13.4 Installer for Windows - Mailing list pgsql-general

From Joel Rabinovitch
Subject Questions on PostgreSQL 13.4 Installer for Windows
Date
Msg-id YT2PR01MB880575933F95C758938EFF18E5409@YT2PR01MB8805.CANPRD01.PROD.OUTLOOK.COM
Whole thread Raw
List pgsql-general

Hi,

 

Our developers do their work using a local PostgreSQL database server and local schemas.

 

This is typically done by installing the Windows version of the PostgreSQL installer from EnterpriseDB. Currently, version 13.4 (64-bit) of the installer is being used.

 

Recently, our organization has installed BeyondTrust Privilege Management software on our developer’s PCs. The software forces the developer to authenticate when doing administrative tasks such as installing software and adjusting environment variables.

 

When a developer attempts to install the PostgreSQL 13.4 database server, the developer is authenticated and the software runs as an administrator.

 

The issue occurs when the installer initializes the database cluster. When it attempts to do this,  it requires that it be done as a non-administrator.

 

This causes the installation process to fail. We have a manual procedure to follow when this occurs, which involves manually initializing the database cluster as a non-administrator, installing the Windows service as an administrator and reinstalling some of the PostgreSQL components.

 

The process works, but it is quite cumbersome.

 

Has anyone had a similar issue when using the PostgreSQL installer for Windows when the BeyondTrust Privilege Management (or similar software) is installed on their PC. If so, what have you done to resolve this.


We have been in contact with the company that develops the BeyondTrust software, but they have not been able to help us correct the problem as of yet.

 

Thanks,

 

Joel

pgsql-general by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: Trying to understand a failed upgrade in AWS RDS
Next
From: "Peter J. Holzer"
Date:
Subject: Re: 15 pg_upgrade with -j