C:\Program Files\PostgreSQL\9.1\data>pg_ctl reload -D . pg_ctl: could not send reload signal (PID: 3396): Operation not permitted In Windows there is a menu option "Reload Configuration" that worked better, as shown below:

2020年4月17日 · I have PostgreSQL 11.5 installed on Windows 10. It was installed with the EnterpriseDB installer, which is the only one which exists these days.

2017年3月10日 · PostgreSQL won't run as Administrator for security reasons and the installer generally sets it up with a "postgres" user account in PostgreSQL 9.1 and older 1. On Windows you can't start a service as a user without saving the password of the user in the registry, so that's what the installer does.

2018年8月9日 · Before you go any further: make a copy of your Postgres data directory. Then (re)install Postgres 9.5. After that you should stop the Windows service, empty the contents of the live data directory and copy from your backed up data directory (don't move from your backup -- starting Postgres against it will probably change the contents).

On Windows, simply stopping the postgresql service, then running postgresql-9.3.1-1-windows-x64.exe on top of the existing 9.3.0 works. No uninstall necessary. Of course, a backup is recommended. Clear, explicit documentation for the update procedure on Windows is absent.

2018年9月26日 · In Windows, the installer used wasn't provided by PostgreSQL, but instead by one of their third party providers. Usually these third parties bundle by default the -contrib modules that would be packaged and installed independently on Linux distros.

Since you are running postgresql in Windows, it is possible that you may not be allowed to edit postgresql.conf while the service is up. If that is the case: shutdown the postgres service; edit postgresql.conf; start the postgres service; Give it a Try !!!

2019年1月25日 · Apparently, this account was related to WDAGUtilityAccount (Windows Defender Application Guard) and was named postgres. Which is commonly active on the Enterprise edition of Windows 10. This was added to my system during an update. Since I'm running the Home edition. I'm not sure why Microsoft, created the WDAGUtilityAccount on my …

2014年11月19日 · For PostgreSQL 9.2 and above there is no postgres system user (by default). It runs as NETWORK SERVICE. Create d:\tablespaces and give the NETWORK SERVICE (SERVICE RÉSEAU in french) "Full control" over it. That should do the trick.

I am installing PostgreSQL 9.2.4-1-windows.exe on Windows 7 64 with Service Pack 1. I get the following, ...