PG Encryption / pg_read_file

Поиск
Список
Период
Сортировка
От Anjul Tyagi
Тема PG Encryption / pg_read_file
Дата
Msg-id em84ff63fe-2cbc-410c-b2ca-1ec921176746@iboss01081
обсуждение исходный текст
Ответы Re: PG Encryption / pg_read_file  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
Список pgsql-admin
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 по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: pgbackrest periodic WAL backups?
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Oracle FDW and Postgres yum repository (CentOS 7)