fschrempf
  • Joined on 2021-09-10
fschrempf commented on issue borgmatic-collective/borgmatic#509 2022-03-12 20:59:09 +00:00
Database backups fail and cause stalling in borg

@witten Thanks for the pointers. Especially the latter sounds like a nice and easy workaround.

fschrempf closed issue borgmatic-collective/borgmatic#509 2022-03-12 20:26:43 +00:00
Database backups fail and cause stalling in borg
fschrempf commented on issue borgmatic-collective/borgmatic#509 2022-03-12 20:26:36 +00:00
Database backups fail and cause stalling in borg

It's possible Borg only prints the name of a file after it's done being backed up. In which case the actual file causing the hang might be another file that's not listed. You could try `sudo…

fschrempf commented on issue borgmatic-collective/borgmatic#509 2022-03-12 20:14:15 +00:00
Database backups fail and cause stalling in borg

It's possible Borg only prints the name of a file after it's done being backed up. In which case the actual file causing the hang might be another file that's not listed. You could try `sudo…

fschrempf commented on issue borgmatic-collective/borgmatic#509 2022-03-12 20:10:49 +00:00
Database backups fail and cause stalling in borg

Ok, this is still very strange. I can reliably solve the issue when I remove all the database hooks from the config.yaml even though the issue seems to be elsewhere.

@witten Can you come up…

fschrempf commented on issue borgmatic-collective/borgmatic#509 2022-03-12 19:49:50 +00:00
Database backups fail and cause stalling in borg

Thanks for reporting this. A little context: borgmatic streams database backups to Borg via a named pipe. Specifically, that postgres file (notice the "p" at the start of the line), so it…

fschrempf opened issue borgmatic-collective/borgmatic#509 2022-03-12 13:04:29 +00:00
Database backups fail and cause stalling in borg
fschrempf commented on issue borgmatic-collective/borgmatic#382 2021-10-08 16:43:13 +00:00
Using environment variables for databases hooks

I had a look at the code to see how the two things (using optional identifier for database configs and check environment for db user/password) could be implemented. It doesn't look too complicated…

fschrempf commented on issue borgmatic-collective/borgmatic#382 2021-09-16 17:01:47 +00:00
Using environment variables for databases hooks

I'm curious how you have this working! Here's a quote from the borgmatic database docs under limitations: "borgmatic does not currently support backing up or restoring multiple databases that share…

fschrempf commented on issue borgmatic-collective/borgmatic#382 2021-09-10 13:33:56 +00:00
Using environment variables for databases hooks

Or maybe letting borgmatic check for the env variables MYSQL_PWD_ and MYSQL_USER_ automatically would be a solution?

On second thought, the name of the db is not unique and…

fschrempf commented on issue borgmatic-collective/borgmatic#382 2021-09-10 13:24:46 +00:00
Using environment variables for databases hooks

Or maybe letting borgmatic check for the env variables MYSQL_PWD_<dbname> and MYSQL_USER_<dbname> automatically would be a solution?

fschrempf commented on issue borgmatic-collective/borgmatic#382 2021-09-10 12:47:28 +00:00
Using environment variables for databases hooks

I'd like to do the exact same thing as described above: reuse the exising database credentials in the environment and pass them to borgmatic. Though in my case I would need to support multiple…