i use vault as single docker container with a postgres SQL database as storage and no consul. Everything works fine except if i want to backup and restore an SQL dump.
The problem is, that after i restore an SQL dump all my secrets are invaild for my different clients and i have no idea why. The only solution at the moment is, to remove the old secrets and get new ones with the token for the corresponding role.
Does anyone has expierence with SQL as vault storage and backup/restore ?
It doesn’t really matter if i dump a SQL file (not compressed postgres format) of the vault DB or the entire DB cluster, the problem occurs in both cases.