Restore Postgres on new PC // restore err


#1

HI,

I’ve create Postgres backup job on my server. Backup i going good no fault and err. Now i want to make restore postgres on other PC (clean machine). So install sqlbackupand ftp. During restore i have an err.

14.08.2019 10:12 Job execution error: ERR: row pg_stat_activity.pid does not existLINE 1: select pg_terminate_backend(pg_stat_activity.pid) from pg_st… ^ Computer name: “BFRDC01”

pls help


#2

Hello Krystian_Nagorski,

To investigate this case we need more details. Could you please install the “Alpha” edition http://sqlbackupandftp.com/download/alpha and enable the advanced log with “Trace” level. Then reproduce the issue and send logs to our dev team. Here are more details on how to do it https://sqlbackupandftp.com/blog/how-to-send-log-to-developers

Note! With the “Trace” level, a log can contain your passwords. Before sending a log to dev team please open it using any text editor and remove the information you prefer to keep in secret. You can find them by clicking the “Open folder” link at the “Advanced Log” window (“Tools” > “Advanced Log…”).

Please let us know if the logs will be sent, also please provide us with your application id (“Help” > “About”).

Sorry for the inconvenience.


#3

Hi, thx for your replay.

I have send log do dev from alpha ver.
my app id:
3f72028c-2b66-42ce-b100-11f39fa0169e


#4

Hello Krystian_Nagorski,

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

Sorry for the inconvenience.


#5

Dear Krystian,

We were able to reproduce the issue and fixed it. Could you please test the Alpha edition http://sqlbackupandftp.com/download/alpha and check if it works?

Sorry for the inconvenience.


#6

Hi,

It’s nice to tell that alpha version restore postgres OK.

I’m happy that you solved it


#7

Hi Krystian_Nagorski,

That’s great! Please feel free to contact us on any issues or concerns.