How to dump and restore ?

[vincentseldon]

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.