I'm trying to generate a backup of my PostgreSQL database through pgAdmin 4, however whenever I try to backup an error occurs:
I'msettingthePostgreSQLpreferencesasfollows:
AndwhenIsetupthebackupI'mdoingitthisway:
Ifyouhaveanysuggestionsastowhatmightbecausingtheerror.
Detailsoftheerrorthatoccurs:
Although it is not exactly the answer that solves my question, but this method of Database Backup has worked for me. In summary, through pgAdmin 4, however I tried Backup always gave error, so I researched and found a solution that met my need, via Command Prompt, follows the solution found, if someone needs to generate a backup independent of the method:
Step 1: When opening the Command Prompt (CMD) run the following command:
C: \ Program Files \ PostgreSQL \ 9.6 \ bin
Note: I needed to be in this directory to be able to execute the command pg_dump.exe needed to perform Backup;
Step 2: Right after executing the following command:
pg_dump.exe --host 127.0.0.1 --port 5432 --username postgres --format Custom --file C: \ Backup \ Backup_dates.backup DatabaseData
And the backup of your Data Base is ready in a moment. At the end your screen should look like this:
