Postgres Pro
Downloads
Home   >   mailing lists

Re: PG Encryption / pg_read_file - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: PG Encryption / pg_read_file
Date
Msg-id CAGDYbUOjq0bT3EZ1oVH7wm94SHHV1U-_Wx1TYnDDKA0EqTmjKA@mail.gmail.com
Whole thread Raw
In response to PG Encryption / pg_read_file  ("Anjul Tyagi" <anjul@ibosstech-us.com>)
List pgsql-admin
Tree view
Hi Anjul,

I think you can use additional contrib module file_fdw to access the files.

Go through this below link.

https://www.postgresql.org/docs/current/file-fdw.html



On Tue, Dec 11, 2018 at 3:06 PM Anjul Tyagi <anjul@ibosstech-us.com> wrote:
Hi Admin,

we are working on the PG Encryption using pgCrypto. We are planing to use the PGP public and private key for encryption. However to secure the key we are not using the keys directly in the SQL Query. We are planning to use the pg_read_file function, for that. However we have noticed only super user can call that function. 

Can you please suggest is there any alternative for pg_read_file function to call non super user or any other alternative to secure the key. 

 
 
 

Regards,

Anjul TYAGI

 

ü Go Green


pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: Pg logical replication
Next
From: soumitra bhandary
Date:
Subject: Pg_restore failing due to data inconsistency in dump file