PG Encryption / pg_read_file

From: "Anjul Tyagi" <anjul(at)ibosstech-us(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: PG Encryption / pg_read_file
Date: 2018-12-11 09:36:24
Message-ID: em84ff63fe-2cbc-410c-b2ca-1ec921176746@iboss01081
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Thomas Kellerer 2018-12-11 14:13:14 Oracle FDW and Postgres yum repository (CentOS 7)
Previous Message Ron 2018-12-10 14:19:27 Re: pgbackrest periodic WAL backups?