Extension Not Found

If pgcrypto functions aren't available:

-- Check which schema pgcrypto is installed in
SELECT n.nspname, e.extname
FROM pg_extension e
JOIN pg_namespace n ON e.extnamespace = n.oid
WHERE e.extname = 'pgcrypto';
 
-- Check your current search_path
SHOW search_path;
 
-- Add the schema to your search path if needed
SET search_path = "$user", public, extensions;


Permission issues

If you can’t create extensions, contact your database administrator. The administrator must have the required permissions for the database.


Private key format

Ensure the private PGP key is in the correct Privacy Enhanced Mail (PEM) format:

-----BEGIN PGP PRIVATE KEY BLOCK-----
Version: GnuPG v2
lQdGBF...
-----END PGP PRIVATE KEY BLOCK-----