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 . 

   

 ​