Integrated backups issue - exit status 1

pixelplumber

Hi, I've read the docs and looked at the tutorial here.

Up to now I was using the portable install on my windows laptop and everything worked.

I've setup a development and production server on debian 12 with dedicated postgres 15 databases. Was trying to see how the integrated backups work but I'm just getting error:

2023-08-30 03:05:28 backup could not execute job 'monthly', exit status 1
2023-08-30 03:05:28 scheduler task 'Integrated full backups' failed to execute, exit status 1

My database setup in config.json has a different database name to username, the default I see they're both 'app' should I have kept the same name?

"db": { "host": "localhost", "port": 5432, "name": "app", "user": "rei3dbusr", "pass": "<<snipped>>", "embedded": false, "ssl": false, "sslSkipVerify": false },

Manually executing the pg_dump command from the tutorial I have to add my database name separately to get it to work manually.

pixelplumber

Dropped and recreated the postgres DB and user and it looks like if the username and database name match (app) the integrated backups work, but if they're different they don't?

gabriel

I´ve had a look and it seems you are right. I was able to replicate this issue on a test system and already applied a fix. The cause was that our backup command did not include the DB name; when the user name matched the DB name, the backup command found the corresponding DB - if not, it failed.

Many use the embedded DB of REI3, which just uses app:app as default names for both user and DB - we also internally have user names identical to database names, so we never stumbled over this issue.

The fix will go live with R3.5, which is nearing completion. Thank you very much for your reports!