search

nec-postgres / tdeforpg

PostgreSQL Transparent Data Encryption tool development
Other
88 stars 18 forks source link

EDT [5905] Error: function decrypt does not exist #11

Open Ealham opened 5 years ago

Ealham commented 5 years ago

I've followed the manual to install TDE Free Version 1.2. Successfully installed Postgres10.10, pgcrypto and tdeforpge.

But whenever I'm trying to activate TDE for my database, I get the following error:

EDT [5905] ERROR: function decrypt(bytea, bytea, text) does not exist EDT [5905] STATEMENT: ALTER FUNCTION decrypt ( bytea, bytea, text ) PARALLEL UNSAFE; ERROR: Could not activate transparent data encryption feature HINT : Please see error_20190822-055000.log for detail

Here's the content of my logfile:

psql:../sys/testdb.cipher.inst:751: ERROR: function decrypt(bytea, bytea, text) does not exist error occured at 2019-08-22-05:50:14 parameters: user:postgres db:testdb port:5432 menu:1

I am running CentOS 7 in VM. Can anyone tell me what went wrong?

wojtulab commented 4 years ago

the same to me, do we have resolution for that?

ok, after a few tries... a resolution is create extension before setup on each db like: CREATE EXTENSION pgcrypto;