michelp / pgsodium

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

How to dump and restore ? #109

Open vincentseldon opened 5 months ago

vincentseldon commented 5 months ago

Hello,

I have encrypt some data with with a per row key id

Making a dump of the db is working fine. The data are encrypted in the dump, that's what I want.

But when I try to restore the dump the encryption triggers are triggered again. And my restored data is now encrypted twice.

Is there a pgsodium approach to dump and restore db?

I also tried to disable-triggers during restore whitout success.