Postgres Pro
Downloads
Home   >   mailing lists

PG Encryption / pg_read_file - Mailing list pgsql-admin

From Anjul Tyagi
Subject PG Encryption / pg_read_file
Date
Msg-id em84ff63fe-2cbc-410c-b2ca-1ec921176746@iboss01081
Whole thread Raw
Responses Re: PG Encryption / pg_read_file  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
List pgsql-admin
Tree view
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: Ron
Date:
Subject: Re: pgbackrest periodic WAL backups?
Next
From: Thomas Kellerer
Date:
Subject: Oracle FDW and Postgres yum repository (CentOS 7)