I add some comments.
If I try to test the connection from SqlBackupAndFTP it fails with the same error.
Attached is a screenshot.
From our own applications and with pgAdmin we connect without problems.
Regards.
Could you please go to your connection settings, press the info button, copy the command, and run it using the Command Prompt to check if the connection can be established?
The procedure entry point GetSystemTimePreciseAsFileTime could not be located in the dynamic link library Kernel32.dll
With Path to PostgreSQL bin folder empty the test path used is
C:\Program Files (x86)\SQLBackupAndFTP\DBMS\PostgreSql\psql.exe and the connection test fails.
If I change that path to the real path of PostgreSQL C:\Program Files\PostgreSQL{version}\bin\psql.exe the connection test works.
The server where SqlAndFtpBackup is installed belongs to a customer, we only handle database related stuff and have not installed/uninstalled anything. But it could be that the server administrator did and that has affected it, what could we check?
Thank you very much.
We are sorry, but it appears that the only way to successfully establish a connection to your PostgreSQL database is by setting a path to your bin folder.
If you have any other questions, please let us know.
After using the SQLBackup program for over a year, I have a user who just started having the same problem as described in this post (error -1073741511 when executing “Run Now”). I believer this is being caused by their inability to connect to the databases since the “Test connection” fails.
So on the connect screen (under Advanced Settings) I had them fill in the “Path to PostgreSQL bin folder” with “C:\Program Files\PostgreSQL\9.5\bin” (9.5 is their Postgres version#). However the test connection still fails. So setting a path to the “bin” folder is not the solution in this case
I noticed on their connect screen the Server name is “Localhost” but when we actually open the Postgres app “localhost” must be used or else the connection to Postgres fails. Could that be the problem? The SQLbackup server connect screen does not allow anything to be entered except for “Localhost” so is there a way I can change the server name to “localhost” to see if that is the problem?
