Re: Official Windows Installer and Documentation

From: Thomas Kellerer <shammat(at)gmx(dot)net>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Official Windows Installer and Documentation
Date: 2022-07-27 21:36:11
Message-ID: 45a30ef6-11ab-c2b7-5b79-507b32aeb954@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

David G. Johnston schrieb am 27.07.2022 um 21:21:
> And then there is the issue of file ownership.
>
> Assuming we want better documentation for this specific issue for
> back-patching what would that look like?
>
> Going forward should our installer be creating the postgres user for
> consistency with other platforms or not?

Didn't the installer used to do that in earlier releases and that
was removed when Postgres was able to "drop privileges" when the
service is started?

I remember a lot of problems around the specific Postgres service
account when that still was the case.

As far as I can tell, most of the problems of the Windows installer
stem from the fact that it tries to use icacls to set privileges
on the data directory. This seems to fail quite frequently,
causing the infamous "Problem running post-install step" error.

The fact that the installer still defaults to using "c:\Program Files"
for the location of the data directoy might be related to that.
(but then I don't know enough of the internals of the installer
and Windows)

Just my 0.02€

Thomas

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2022-07-27 21:50:46 Re: collect_corrupt_items_vacuum.patch
Previous Message David Rowley 2022-07-27 21:35:10 Re: [PoC] Reducing planning time when tables have many partitions