So I’ve been browsing my discourse folders and found a dump.sql file on the /backup folder that I don’t remember creating manually. I’d this a file that is automatically created during backups or am I having an intrusion?

It may have been left behind by a failed backup, perhaps if the disk filled during the backup. It’s not likely due to an intrusion.

There must be a different reason, because the backup process creates a compressed dump.sql.gz file. Only a restore could leave a decompressed dump.sql file, but it should clean up after itself. @Mr.X_Mr.X What’s the absolute path of the dump.sql file you’ve seen? And what’s the timestamp of the file? Could it be very old?

/var/www/discourse/tmp/backups There was a dump.sql and a tar.gz typical archive. Nothing else, I’m storing backups on S3.

In case the disk is nearly full, it’s a possibility.

[image] Mr.X_Mr.X: /var/www/discourse/tmp/backups I’m pretty sure the file you are seeing was manually copied/uploaded and decompressed at that location. Backups use /var/www/discourse/tmp/backups/ / for storing the temporary dump.sql.gz file und restoring uses a completely different directory. [image] Jakke Flemming: Unless compression fails? We are calling pg_dump with the --compress parameter, so it writes a compressed dump without a temporary file. Worst case, you’d see an incomplete dump.sql.gz file.

Dump.sql file in the backup folder?

Product Support

Canapin (Coin-coin le Canapin) December 2, 2022, 12:24pm 3

I believe I’ve seen this kind of stuff several times and I also thought they were failed backups remnants.
~~Your explanation seems to confirm this.~~

Or not: ↓

Topic		Replies	Views
Backup files not found at local disk Product Support	1	441	February 15, 2023
Backups are no longer happening Product Support	4	670	April 9, 2021
Restore failure - extracting dump file, no such file or directory Self-hosting	15	969	July 4, 2023
When backup fails, delete the useless backup Feature	7	1506	December 15, 2017
Discourse restore with pg_dump Self-hosting	2	1091	October 22, 2018

Dump.sql file in the backup folder?

Related topics