POSTGRESQL 9.51 (using Password) Backup Job stalls


#9

Hello,

Thank you for the log. Please give us some time to check them.

Sorry for the inconvenience.


#10

Hello,

Thank you for your log we have checked it. It seems the issue is on pg_dump level. SQLBackupAndFTP creates backups of PostgreSQL Server databases via pg_dump tool.

Could you please try to perform a backup manually via pg_dump tool?

Sorry for the inconvenience.


#11

Thats the thing - while your soft is not working properly, i have to backing up my database throught my script with pg_dump. And it’s work!

@echo Backup database %PG_PATH%%PG_FILENAME%
@echo off
SET 7_BIN=“C:\Program files\7-Zip\7z.exe”
SET PG_BIN=“C:\Program Files\PostgreSQL\10.5-24.1C\bin\pg_dump.exe”
SET PG_HOST=localhost
SET PG_PORT=5432
SET PG_DATABASE1=01_docflow
SET PG_DATABASE2=01_wh
SET PG_USER=postgres
SET PGPASSWORD=*
SET PG_PATH=C:\Program Files\PostgreSQL\10.5-24.1C\bin
SET FECHAYHORA=%date:/=%-%time:-0,8%
SET FECHAYHORA=%FECHAYHORA::=-%
SET FECHAYHORA=%FECHAYHORA: =0%
Set Tdate=%date:~6,4%%date:~3,2%%date:~0,2%
SET PG_FILENAME1=%PG_DATABASE1%%Tdate%.sql
SET PG_FILENAME2=%PG_DATABASE2%
%Tdate%.sql
SET PG_FILENAME1z=%PG_DATABASE1%%Tdate%
SET PG_FILENAME2z=%PG_DATABASE2%
%Tdate%

%PG_BIN% -h %PG_HOST% -p %PG_PORT% -U %PG_USER% %PG_DATABASE1% > C:_Backup%PG_FILENAME1%
%PG_BIN% -h %PG_HOST% -p %PG_PORT% -U %PG_USER% %PG_DATABASE2% > C:_Backup%PG_FILENAME2%

“C:\Program files\7-Zip\7z.exe” a -tzip -mx8 -r0 C:_Backup%PG_FILENAME1z% C:_Backup%PG_FILENAME1%
“C:\Program files\7-Zip\7z.exe” a -tzip -mx8 -r0 C:_Backup%PG_FILENAME2z% C:_Backup%PG_FILENAME2%
erase /Q C:_Backup%PG_FILENAME1%
erase /Q C:_Backup%PG_FILENAME2%

@echo Backup Taken Complete %PG_PATH%%PG_FILENAME%


#12

Hello,

Thank you for the details. To investigate this case we need more information. Could you please enable your advanced log with the “Trace” level, reproduce the issue, then open the advanced log

and find the following substring:

SqlBak.Job.PostgreSql.Helper.PgDumpHelper|Dump. Command:

There will be arguments that we pass to pg_dump. Could you please use them and manually try to run those arguments via pg_dump to reproduce the issue.

Sorry for the inconvenience.


#13

I apologize for the delay in responding.
Link to advanced trace log - https://1drv.ms/u/s!Ats40EEpdjy7xx-t7keHyu96lcA9?e=b8hZIy

Target string - “C:\Program Files (x86)\SQLBackupAndFTP\DBMS\PostgreSql\pg_dump.exe”; Arguments: “–host=localhost --port=5432 --username=“postgres” --dbname=“01_docflow” --clean --file=C:\Windows\TEMP\СИСТЕМА\Pranas.NET\SQLBackupAndFTP\backup\01_docflow201908060847.sql --oids --no-privileges --if-exists --lock-wait-timeout=30000”

I was able to do backup successfully with this string. See screenshot in attachement.


#14

Hello,

Thank you for the details.

We have checked the details you send. Sorry, but the error message you get is generated by pg_dump and cannot be resolved from our side. We recommend you to check this issue on the web, there are many recommendations on how to resolve it.

Sorry for the inconvenience.


#15

Hello
Sorry, but there is no error at pg_dump process. Some warnings, but no errors. And process is end successfully - SQL dump generated ok.
But in postgresql this job was freeze\failed.


#16

Thank you for the details.

Yes, indeed, there are no error messages on a screenshot, but SQLbackupAndFTP reports that pg_sump.exe return a non-zero exit code which indicates an error. Could you please run the echo %ERRORLEVEL% command just after you run a backup manually, it will display the exit code pg_dump


#17

Thanks for the answer.
See scrrenshot in attachement.
Exit code is 0.


#18

Thank you for the details. We have added another change to the Alpha edition, could you please install it and check http://sqlbackupandftp.com/download/alpha ?

If you still have this issue with the Alpha edition, then please send us the Advanced log with the “Trace” level using the instructions above.

Sorry for the inconvenience.


#19

Still freeze :frowning:
ok, sent. 2223c655-ecfb-4b17-9412-43474384ec07


#20

Hello,

Thank you for the log, please give us some time to check the issue.

Sorry for the inconvenience.


#21

Hello,

We have tried to check your logs, but haven’t found them. Could you please send them again?

Sorry for the inconvenience.


#22

Hello, ok sent.
And you can download it here - https://infos256-my.sharepoint.com/:u:/g/personal/a_andrianov_infos_su/EVNqgvWrOvxJhhGpBWCBc9UB1A4pI-iLlBV3AkomEminIg?e=xigKvH


#23

Hello,

Thank you for the details. Please give us some time to check the issue.

Sorry for the delay and for the inconvenience.


#24

Hello!
Any update?



#25

Hello,

Sorry for the delay, but we are still working on the issue.

We are really sorry about the delay and all the inconvenience.


#26

Hello,

Sorry, but we still cannot reproduce the issue and cannot resolve it.

For further investigations and reproducing the issue, could you please export your database without any data and send it to us?

You can export a database manually via pg_dump:

pg_dump --host=<servername> --port=5432 --username="<login>" --dbname="01_docflow" --clean --file=<path_to_dump>.sql --oids --schema-only --no-privileges --if-exists --lock-wait-timeout=30000

Please let us know if you have any further questions.

Sorry for the inconvenience.


#27

hi!
ok, you can download it here - https://infos256-my.sharepoint.com/:u:/g/personal/a_andrianov_infos_su/EbfwnE3t40FCgkblquYrWIcB-Ew8nUwiFe5eXt1C7MqRcw?e=goldJc

If you want, i can create a test enviroment, reproduce this issue at my server and give you access via TeamViewer. Pls let me now, if it can help.


#28

Hi,

Thank you for the details. Please give us some time to check the issue.

Thank you for your willingness to provide us with a test environment, we’ll let you know if there will be a need in it.

Sorry for the inconvenience.