4
I am trying to generate a backup of my Postgresql database through pgAdmin 4, but every time I try to backup an error occurs:
I am configuring the Postgresql preferences as follows:
And when I set up the backup I’m doing this way:
If you have any suggestions as to what might be causing the error.
Details of the error that occurs:
5
Although it is not exactly the answer that solves my question, but this Database Backup method worked for me. Briefly, by means of pgAdmin 4, as much as I tried the Backup always gave error, so I searched and found a solution that met my need, via Command Prompt, follows solution found, in case someone needs to generate a backup independent of the method:
Step 1: When opening Command Prompt (CMD) execute the following command:
cd 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 necessary to perform the Backup;
Step 2: Immediately after executing the following command:
pg_dump.exe --host 127.0.0.1 --port 5432 --username postgres --format Custom --file C: Backup Backup_data.backup Database
And ready the backup of your Data Base will be ready in a few moments. At the end your command screen should look like this:
Browser other questions tagged postgresql backup
You are not signed in. Login or sign up in order to post.
I edited the question with the detailed error information @Bacco
– R.Santos
It was much better. As for the error, I needed to see if it is saved some log that you can access on the server, the message doesn’t really help much. Let’s see if someone with practice in this tool can give some hint.
– Bacco
@Bacco thanks for the help anyway
– R.Santos
The most important thing here was your willingness to improve the post. This makes it much easier for those who help (and consequently increases the chance of a solution).
– Bacco