Skip to content
Advertisement

pg_restore: [directory archiver] could not open input file. Error while trying to restore DB

Error when trying to restore a backup file(.nb3).

I did a database backups in Navicat, one backup for each schema. They are .nb3 files. I tried to restore my DB on a local server using pgAdmin. I got an error like this after choosing backup file : enter image description here

How do I restore the database on a local server?

Advertisement

Answer

NB3 NaviCat backup files can be restored using the NaviCat software.

  1. Add the database connection in NaviCat
  2. Double click on the connection and go to Backup
  3. Right-click on the empty backup window and select “Restore from…” from the menu
  4. Select your nb3 file
User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement