Db restore error

0
Hi,  We are trying to restore the databse from cloud.  Took a back up.. went to back ups and did create backup -> full snapshot. using 7zip extracted it.  Trying to restore this db into pgadmin.  Getting below error. 
asked
3 answers
3

This is caused by a mismatch in pg_restore and pg_dump versions on the local machine and in the cloud.

See https://stackoverflow.com/questions/60375989/pg-restore-tar-archiver-could-not-find-header-for-file-toc-dat-in-tar-archi

answered
2
  1. install PostgreSQL 13 (next to your existing v9.6) (or download just the binaries)
  2. Open PgAdmin, File, Preferences, Paths/Binary paths
  3. Change it to something like this: C:\Program Files\PostgreSQL\13\bin

 

Now try to restore again to your v9.6 server.

edit: first of all, you need postgreSQL 9.6

answered
0

 

thanks Marlon, i have the same configurations.. but it doesnt work… anything else i am missing ?

answered