Production Data Import into SQL

0
Hello,   I am trying to take a backup from my production environment and make it available in a local PostgreSQL environment.    However when following the steps to do the “restore” of the backup it is not recognizing the db.backup file as a valid option to restore against.    I receive this error: ‘’….\db\pg_restore.exe' file not found. Please correct the Binary Path in the Preferences dialog’’   Can anyone confirm how to do this process and allow this path to be selected or configured?    Thank you
asked
1 answers
0

The case here is not that the file is not recognized, but rather that your setup for postgres is not completely  correct.

To fix this issue see https://dba.stackexchange.com/questions/291534/cannot-do-a-restore-using-pgadmin4-after-a-new-install-of-postgresql-pg-restor

answered