[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] Error Encrypting data folder
From:       Luis Marin <luismarinaray () gmail ! com>
Date:       2016-12-26 19:02:47
Message-ID: CAEp6HQUdDT6onhvcBNwixL-=dc_Sx9b1vY9Kxquhb5bwCz4eaw () mail ! gmail ! com
[Download RAW message or body]

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@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
>

[Attachment #3 (text/html)]

<div dir="ltr">Juan Albarran,<div><br></div><div>Aqui ya hubo un intento parecido a \
lo que queres hacer, con una version anterior de \
PostgreSQL:</div><div><br></div><div><a \
href="https://www.postgresql.org/message-id/AANLkTi%3DO3if-WsSK%2BNS2uuFbLq1zCEiZWnaE2 \
MuhDmEx%40mail.gmail.com">https://www.postgresql.org/message-id/AANLkTi%3DO3if-WsSK%2BNS2uuFbLq1zCEiZWnaE2MuhDmEx%40mail.gmail.com</a><br></div><div><br></div><div>En \
resumen verificar:</div><div><br></div><div>Los permisos que estas usando en el \
usuario de la aplicacion</div><div><br></div><div>Enlaces que te pueden ser de \
utilidad, dale un vistazo:<br></div><div><br></div><div><a \
href="http://www.ibm.com/developerworks/opensource/library/os-postgresecurity/">http:/ \
/www.ibm.com/developerworks/opensource/library/os-postgresecurity/</a><br></div><div><br></div><div>Solo \
una idea</div><div><br></div><div>Saludos</div><div><br></div></div><div \
class="gmail_extra"><br><div class="gmail_quote">2016-12-23 18:02 GMT-04:00 Juan \
Albarran <span dir="ltr">&lt;<a href="mailto:juan.carlos.albarran@gmail.com" \
target="_blank">juan.carlos.albarran@gmail.com</a>&gt;</span>:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr"><div>Hi,</div><div><br></div><div>I have some \
troubles trying to encrypt postgresql data folder \
(PostgreSQL\9.6\data\base).</div><div><br></div><div>My current environment \
is:</div><div>* Windows 10</div><div>* Postgresql \
9.6</div><div><br></div><div>I&#39;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:</div><div><br></div><div>&lt;log \
timestamp=&quot;13/12/2016 20:21:15.853&quot; level=&quot;ERROR&quot; \
username=&quot;SYSTEM&quot; location-code=&quot;&quot;&gt;&lt;message&gt;<wbr>FATAL: \
42501: could not open file &quot;base/12401/PG_VERSION&quot;: Permission \
denied&lt;/message&gt;&lt;exception&gt;<wbr>Npgsql.NpgsqlException:</div><div>could \
not open file &quot;base/12401/PG_VERSION&quot;: Permission \
denied</div><div>Severity: FATAL</div><div>Code: \
42501</div><div>&gt;</div><div><br></div><div>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.<br></div><div><br></div><div>Best \
regards,</div><span class="HOEnZb"><font color="#888888"><div><br></div>-- <br><div \
class="m_-2101291068053329901gmail_signature"><div dir="ltr"><div>Juan Carlos \
Albarrán Mijares<br>Ingeniero en Informática<br></div></div></div> \
</font></span></div> </blockquote></div><br></div>



[prev in list] [next in list] [prev in thread] [next in thread]