Backing up and Restoring the Vaultwarden SQL DB

Postgresql databases

Configure database connections in pgAdmin​

run the tcdbinfo.sh  script to see the connection details for both the old and the new database, and set them up in pgAdmin.

Create database Backup​

In pgAdmin, right click vaultwarden->Databases->vaultwarden and click Backup.... Give the file a name (e.g. vaultwarden.sql) and click Backup.

Restore database backup​

In pgAdmin, right click testwarden->Databases->vaultwarden and click Restore.... Select the sql file (vaultwarden.sql).

On the 2nd tab page, select the first 3 options (Pre-data, Data and Post-data). On the last tab, select Clean before restore. Now click Restore.

​