michelp / pgsodium

Modern cryptography for PostgreSQL using libsodium.
Other
555 stars 32 forks source link

ERROR: pgsodium_derive_helper: pgsodium_derive: no server secret key defined #91

Open AnujiVarghese opened 1 year ago

AnujiVarghese commented 1 year ago

Hi when i call select pgsodium.derive_key(1); getting an error ERROR: pgsodium_derive_helper: pgsodium_derive: no server secret key defined. I have added shared_preload_libraries = 'pgsodium'
and pgsodium.server_secret_key = '696fe962615267e8d65adad896ad12d996921fbbaf3fe8e56573bec1c941ca90' in postgresql.conf file How can i solve the issue? pgsodium.version-3.1.8

farhannkaskar commented 8 months ago

I am facing the same issue. Did you find any fix for this?