Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
Ealham opened this issue Aug 22, 2019 · 1 comment
Open

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

Ealham opened this issue Aug 22, 2019 · 1 comment

Comments

@Ealham
Copy link

Ealham commented Aug 22, 2019

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
Copy link

wojtulab commented Aug 17, 2020

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;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants