All of us may faced the error called "Permission denied" while restoring the .sql files in Windows. This is because the logged in user of PostgreSQL is not having the enough permission to read/execute the file we mentioned.
To bypass this use the following syntax to restore with out any issue.
$ bin> psql -d sampledb -U dbuser -f c:\Temp\backup.sql
Still you faced the same error then, give 'Full control' permission to that backup file by right clicking that and add everyone user group into permission list for that.
To bypass this use the following syntax to restore with out any issue.
$ bin> psql -d sampledb -U dbuser -f c:\Temp\backup.sql
Still you faced the same error then, give 'Full control' permission to that backup file by right clicking that and add everyone user group into permission list for that.
No comments:
Post a Comment