On 7/18/20 5:46 AM, Amit Kapila wrote: > >> I don't have an especially easy way to experiment on Windows; I can push >> experiments to the CI service and wait a bit to see what they do, but >> I figured I'd ask here first. >> > I have tried and 'pg_ctl stuff seems to be working for a privileged > account. See below: > postgres.exe -D ..\..\Data > Execution of PostgreSQL by a user with administrative permissions is > not permitted. > The server must be started under an unprivileged user ID to prevent > possible system security compromises. See the documentation for > more information on how to properly start the server. > > pg_ctl.exe start -D ..\..\Data > waiting for server to start....2020-07-18 14:53:46.120 IST [8468] LOG: > starting PostgreSQL 14devel, compiled by Visual C++ build 1915, > 64-bit > 2020-07-18 14:53:46.136 IST [8468] LOG: listening on IPv6 address > "::1", port 5432 > 2020-07-18 14:53:46.136 IST [8468] LOG: listening on IPv4 address > "127.0.0.1", port 5432 > 2020-07-18 14:53:46.214 IST [7512] LOG: database system was shut down > at 2020-07-18 14:53:22 IST > 2020-07-18 14:53:46.245 IST [8468] LOG: database system is ready to > accept connections > done > server started > > I have run above two commands from an account with administrative > privilege and 'pg_ctl start' is working. I have further tried a few > operations after connecting with the client and everything is working > fine. >
This has been true for a long time, and since commit ce5d3424d6 we've been able to run all the regression and TAP tests safely under an administrative account. cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
