Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] Error Encrypting data folder - Mailing list pgsql-admin

From Luis Marin
Subject Re: [ADMIN] Error Encrypting data folder
Date
Msg-id CAEp6HQUdDT6onhvcBNwixL-=dc_Sx9b1vY9Kxquhb5bwCz4eaw@mail.gmail.com
Whole thread Raw
In response to [ADMIN] Error Encrypting data folder  (Juan Albarran <juan.carlos.albarran@gmail.com>)
List pgsql-admin
Tree view
Juan Albarran,

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


En resumen verificar:

Los permisos que estas usando en el usuario de la aplicacion

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


Solo una idea

Saludos


2016-12-23 18:02 GMT-04:00 Juan Albarran <juan.carlos.albarran@gmail.com>:
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

pgsql-admin by date:

Previous
From: Vivekanand Joshi
Date:
Subject: [ADMIN] Not able to login to remote server through failover script.
Next
From: Luis Marin
Date:
Subject: Re: [ADMIN] Lock a viewe