We have two QNAP Nas running different PostgresSQL instances I created a Backup Job on one of the NAS and everything is working very well, but when I tried to create a similar backup job for the second NAS, I could not get SQLBackupAndFTP to connect to the database. When I press on Test Connection, the Error I get is 192.168.1.10 test failed. psql: FATAL: database “postgres” does not exist.
FYI the database is called test_nas, username and password is postgres.
I am pretty sure that SQLBackup can make a connection to the database, because if I put in a wrong password I get an authentification error but it seems to me that it does not find the database because it is not called “postgres”.
Is there a way how I can pass the real name of the db somehow on the connection level?
The client and server are on the same network and we do not block any ports on the NAS.
Thank you very much for your input. I appreceate it a lot.