Postgresql error running icacls

answered Sep 15, 2019 at 11:22

I tried installing Postgresql-9.5.19.1-windows-x64 version (downloaded from official page) on Windows 10 x64 and it gave me the same error. I tried executing it with administrator privileges, giving permissions to the temp folder, moving temp folder to another location but nothing worked…

The solution for me was using a different version of 9.5: PostgreSQL-9.5.2-1-windows-x64.

answered Sep 17, 2019 at 14:34

This error happened to me to on PostgreSQL version 11.2

I elaborated in a Stackoverflow post as answer to ‘Is the server running on host “localhost” (::1) and accepting TCP/IP connections on port 5432?’ a solution. I mentioned this question thread with answers as being the solution to this error.

But in short it is what you all are saying: reinstall.

But it can be the same or a different version in my experience.

My explanation:

The general thought/assumptions:

It looks like it is pgAdmin (probably version 4) or your admin rights or one of the files mentioned above (postgresql.conf and/or pg_hba.conf).

I had the same error and even a password error (for the correct password) after being a step further by some todo’s and fixes that helped other people in previous versions;

But none of them worked for postgresql version 12.3 and/or postgresql version 11.8

Solution versions:

The only thing that helped after two hours was:
As explained in this post: ‘PostgreSQL Install fail on Windows 10 (icalcs error/acces denied)’ on the superuser forum of StackExchange:

• Uninstall en reinstall postgresql. The official version provided by EDB through this link: postgresql.org/download; Or try a different version if you are sure this one doesn’t work for you. Therefor head to the ‘File Browser’of Postgresql: here
• After reinstall, start pgAdmin from the Start Menu (scroll for the folder and the correct related pgAdmin; an older version could still hang around in the shortcuts and won’t start).

Note: You can keep your data map so nothing is lost!

In my case e.g.: I removed the /data folder from the (Windows 10) [Drive]/Program Files/PostgreSQL/11 and as soon as I uninstalled version 11.2 and reinstalled (earlier removed 12) version 12: when I started pgAdmin4 my former servers ([nameA] and [PostgreSQL 11] and databases ánd the new server [PostgreSQL 12] were there! And the connection was reestablished

Tried:

Earlier tried solutions that did not work in my case:

• Question 37307346 «Is the server running on host localhost 1 and accepting tcp ip connections on port 5432?
• Question 40532399 Unable to connect to server for postgres
• Question 16904997 Connection refused pgerror postgresql and rails
• Question 60532791 Timeout expired pgadmin unable to connect to server note: This was after semi solution of netstat running postgres service (port was not used before that solution; here listed as 4th item, item above).

answered Jun 17, 2020 at 22:47

If you have issues with permissions either after installations or after reinstalling postgres you might find help here.

Make sure you install the correct version for the data folder you have, you can check the version in that data folder under file named PG_VERSION.

1. Install postgres with random data directory. If it doesn’t work with old data directory and you get errors about permissions or stuff like icacls then pick a fresh folder and proceed with this post.
2. Go to registry editor and then find something like
   HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicespostgresql-x64-11 <- version you installed
   change imagepath to reflect the data directory
   "C:Program FilesPostgreSQL11binpg_ctl.exe" runservice -N "postgresql-x64-11" -D "{DATA_DIRECTORY like d:/db}" -w
3. At this point the service might not even start, but check just in case it is magically working at this stage. It won’t log anything or throw any errors so don’t worry, if you do everything right it will work.
4. Right click the data folder then go to Properites -> Security tab -> Advanced button
5. Toggle the checkbox on the bottom «Replace all child object perm[..]»
6. Press Add, and select principal on top, then type in the big box NETWORK SERVICE
   To make sure it works try pressing check names, it should underscore it. Then press OK, set all permissions to it. Then OK, OK, OK. You should leave the file properties approving everything.

If steps 4-6 throw out permissions errors read step 7 /

1. Try running postgres. If for some reason you cant run postgres at this point. Then run command-line as an administrator, and type in icacls "{DATA_FOLDER}" /reset /T this will clear all the permissions that are there no matter what they are. Postgres install ought to be doing that but it’s bugged in some versions. As it was in mine.
2. Now you can try running postgres service.
3. At this point PG Admin didn’t really work but I managed to login using the psql.exe and I’ve dumped all the data. pg_dump -U {USERNAME} {DATABASE} > {FILENAME.EXT} Then I’ve uninstalled postgres, restarted PC, then installed the newest version and I’ve recovered the dump.

answered Dec 22, 2020 at 17:10

Had the same problem, but I’m not comfortable downloading installers from unknown sources.

After quite some struggling (including run as different user, install from a session opned with a domain administrator account), the only thing that worked for me was to enable the local administrator command (net user administrator /active:yes), providing a password for it (net user administrator *) and then running the installer.

Hope this helps.

answered Sep 10, 2019 at 13:47

answered Mar 19, 2020 at 5:50

answered Mar 27, 2020 at 18:02

We had the same Problem today while upgrading from 12.1 to 12.3.
Installer (EnterpriseDB) stopped with the error while icacls — call because of missing rights…
We even ran it as local administrator.

After stopping the setup the pg — service was removed and rights in pg-data / base — folder were missing.
We run takeown /F d:PgData12* /R /A and startet the setup again. Then it worked without other problems.

answered Jun 11, 2020 at 6:05

answered Jan 18, 2021 at 15:15

I suspect a problem with user rights.
I was able to activate the Administrator account and perform the installation.

1. cmd (Run as Administrator)

2. net user administrator active: yes

3. logout old Account and login Administrator

4. install PostgreSQL

answered Mar 14, 2021 at 9:23

answered Sep 15, 2019 at 11:22

I tried installing Postgresql-9.5.19.1-windows-x64 version (downloaded from official page) on Windows 10 x64 and it gave me the same error. I tried executing it with administrator privileges, giving permissions to the temp folder, moving temp folder to another location but nothing worked…

The solution for me was using a different version of 9.5: PostgreSQL-9.5.2-1-windows-x64.

answered Sep 17, 2019 at 14:34

This error happened to me to on PostgreSQL version 11.2

I elaborated in a Stackoverflow post as answer to ‘Is the server running on host “localhost” (::1) and accepting TCP/IP connections on port 5432?’ a solution. I mentioned this question thread with answers as being the solution to this error.

But in short it is what you all are saying: reinstall.

But it can be the same or a different version in my experience.

My explanation:

The general thought/assumptions:

It looks like it is pgAdmin (probably version 4) or your admin rights or one of the files mentioned above (postgresql.conf and/or pg_hba.conf).

I had the same error and even a password error (for the correct password) after being a step further by some todo’s and fixes that helped other people in previous versions;

But none of them worked for postgresql version 12.3 and/or postgresql version 11.8

Solution versions:

The only thing that helped after two hours was:
As explained in this post: ‘PostgreSQL Install fail on Windows 10 (icalcs error/acces denied)’ on the superuser forum of StackExchange:

• Uninstall en reinstall postgresql. The official version provided by EDB through this link: postgresql.org/download; Or try a different version if you are sure this one doesn’t work for you. Therefor head to the ‘File Browser’of Postgresql: here
• After reinstall, start pgAdmin from the Start Menu (scroll for the folder and the correct related pgAdmin; an older version could still hang around in the shortcuts and won’t start).

Note: You can keep your data map so nothing is lost!

In my case e.g.: I removed the /data folder from the (Windows 10) [Drive]/Program Files/PostgreSQL/11 and as soon as I uninstalled version 11.2 and reinstalled (earlier removed 12) version 12: when I started pgAdmin4 my former servers ([nameA] and [PostgreSQL 11] and databases ánd the new server [PostgreSQL 12] were there! And the connection was reestablished

Tried:

Earlier tried solutions that did not work in my case:

• Question 37307346 «Is the server running on host localhost 1 and accepting tcp ip connections on port 5432?
• Question 40532399 Unable to connect to server for postgres
• Question 16904997 Connection refused pgerror postgresql and rails
• Question 60532791 Timeout expired pgadmin unable to connect to server note: This was after semi solution of netstat running postgres service (port was not used before that solution; here listed as 4th item, item above).

answered Jun 17, 2020 at 22:47

If you have issues with permissions either after installations or after reinstalling postgres you might find help here.

Make sure you install the correct version for the data folder you have, you can check the version in that data folder under file named PG_VERSION.

1. Install postgres with random data directory. If it doesn’t work with old data directory and you get errors about permissions or stuff like icacls then pick a fresh folder and proceed with this post.
2. Go to registry editor and then find something like
   HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicespostgresql-x64-11 <- version you installed
   change imagepath to reflect the data directory
   "C:Program FilesPostgreSQL11binpg_ctl.exe" runservice -N "postgresql-x64-11" -D "{DATA_DIRECTORY like d:/db}" -w
3. At this point the service might not even start, but check just in case it is magically working at this stage. It won’t log anything or throw any errors so don’t worry, if you do everything right it will work.
4. Right click the data folder then go to Properites -> Security tab -> Advanced button
5. Toggle the checkbox on the bottom «Replace all child object perm[..]»
6. Press Add, and select principal on top, then type in the big box NETWORK SERVICE
   To make sure it works try pressing check names, it should underscore it. Then press OK, set all permissions to it. Then OK, OK, OK. You should leave the file properties approving everything.

If steps 4-6 throw out permissions errors read step 7 /

1. Try running postgres. If for some reason you cant run postgres at this point. Then run command-line as an administrator, and type in icacls "{DATA_FOLDER}" /reset /T this will clear all the permissions that are there no matter what they are. Postgres install ought to be doing that but it’s bugged in some versions. As it was in mine.
2. Now you can try running postgres service.
3. At this point PG Admin didn’t really work but I managed to login using the psql.exe and I’ve dumped all the data. pg_dump -U {USERNAME} {DATABASE} > {FILENAME.EXT} Then I’ve uninstalled postgres, restarted PC, then installed the newest version and I’ve recovered the dump.

answered Dec 22, 2020 at 17:10

Had the same problem, but I’m not comfortable downloading installers from unknown sources.

After quite some struggling (including run as different user, install from a session opned with a domain administrator account), the only thing that worked for me was to enable the local administrator command (net user administrator /active:yes), providing a password for it (net user administrator *) and then running the installer.

Hope this helps.

answered Sep 10, 2019 at 13:47

answered Mar 19, 2020 at 5:50

answered Mar 27, 2020 at 18:02

We had the same Problem today while upgrading from 12.1 to 12.3.
Installer (EnterpriseDB) stopped with the error while icacls — call because of missing rights…
We even ran it as local administrator.

After stopping the setup the pg — service was removed and rights in pg-data / base — folder were missing.
We run takeown /F d:PgData12* /R /A and startet the setup again. Then it worked without other problems.

answered Jun 11, 2020 at 6:05

answered Jan 18, 2021 at 15:15

I suspect a problem with user rights.
I was able to activate the Administrator account and perform the installation.

1. cmd (Run as Administrator)

2. net user administrator active: yes

3. logout old Account and login Administrator

4. install PostgreSQL

answered Mar 14, 2021 at 9:23