Error Encrypting data folder

From: Juan Albarran <juan(dot)carlos(dot)albarran(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Error Encrypting data folder
Date: 2016-12-23 22:02:29
Message-ID: CADuqov7aWhwwY4xM0FHdpLyxrJAkxeYoNdYU=QL+QV=h7jh38g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I have some troubles trying to encrypt postgresql data folder
(PostgreSQL\9.6\data\base).

My current environment is:
* Windows 10
* Postgresql 9.6

I'm trying to encrypt data folder using EFS (Encryption File System)
provided by Windows 10. When I encrypt the folder my application throws the
following error:

<log timestamp="13/12/2016 20:21:15.853" level="ERROR" username="SYSTEM"
location-code=""><message>FATAL: 42501: could not open file
"base/12401/PG_VERSION": Permission
denied</message><exception>Npgsql.NpgsqlException:
could not open file "base/12401/PG_VERSION": Permission denied
Severity: FATAL
Code: 42501
>

If I revert the encryption on data folder the application work fine. If
exists some way to encrypt the directory either using EFS or other option
would be awesome know it.

Best regards,

--
Juan Carlos Albarrán Mijares
Ingeniero en Informática

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Vivekanand Joshi 2016-12-25 06:43:31 Not able to login to remote server through failover script.
Previous Message neos 2016-12-21 05:00:37 Too long startup time after crash.