Questions on PostgreSQL 13.4 Installer for Windows

From: Joel Rabinovitch <Joel(dot)Rabinovitch(at)tecsys(dot)com>
To: "'pgsql-general(at)lists(dot)postgresql(dot)org'" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Questions on PostgreSQL 13.4 Installer for Windows
Date: 2023-05-23 16:35:38
Message-ID: YT2PR01MB880575933F95C758938EFF18E5409@YT2PR01MB8805.CANPRD01.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2023-05-23 17:19:29 Re: 15 pg_upgrade with -j
Previous Message Alan Hodgson 2023-05-23 15:02:20 Re: Trying to understand a failed upgrade in AWS RDS