Re: Error Encrypting data folder

[Luis Marin <luismarinaray@xxxxxxxxx>]

Juan Albarran,

Aqui ya hubo un intento parecido a lo que queres hacer, con una version anterior de PostgreSQL:

https://www.postgresql.org/message-id/AANLkTi%3DO3if-WsSK%2BNS2uuFbLq1zCEiZWnaE2MuhDmEx%40mail.gmail.com

En resumen verificar:

Los permisos que estas usando en el usuario de la aplicacion

Enlaces que te pueden ser de utilidad, dale un vistazo:

http://www.ibm.com/developerworks/opensource/library/os-postgresecurity/

Solo una idea

Saludos

2016-12-23 18:02 GMT-04:00 Juan Albarran <juan.carlos.albarran@xxxxxxxxx>:

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