Automatic Database backup fails every time

Below is the error stack

[2020-10-07 22:21:06] pg_dump: creating DEFAULT "public.muted_users id"
[2020-10-07 22:21:06] pg_dump: creating DEFAULT "public.notifications id"
[2020-10-07 22:21:06] pg_dump: creating DEFAULT "public.oauth2_user_infos id"
[2020-10-07 22:21:06] EXCEPTION: pg_dump failed
[2020-10-07 22:21:06] /var/www/discourse/lib/backup_restore/backuper.rb:150:in `dump_public_schema'
/var/www/discourse/lib/backup_restore/backuper.rb:36:in `run'
/var/www/discourse/script/spawn_backup_restore.rb:8:in `backup'
/var/www/discourse/script/spawn_backup_restore.rb:33:in `<main>'
[2020-10-07 22:21:06] Deleting old backups...
[2020-10-07 22:21:06] Cleaning stuff up...
[2020-10-07 22:21:06] Removing '.tar' leftovers...
[2020-10-07 22:21:06] Marking backup as finished...
[2020-10-07 22:21:06] Refreshing disk stats...
[2020-10-07 22:21:06] Notifying 'shoaib627' of the end of the backup...
1 Like

How did you install discourse? Is this a standard install?

2 Likes

Yes, it’s the standard Discourse docker. I have the exact installation on two environments staging and production. Backup works on one and fail on another.

1 Like

Which version is this install? Is it Postgres 12 or did you block the update?

2 Likes

Current discourse version is: 2.6.0.beta3
Postgres version: 12.3

There is no auto update of discourse.I have left the settings default.

Is not much to go on. Are you out of disk space or anything like that?