Database Backups with wrong encoding

[Splicho]

I’m asking because I recently set up daily database backups and upload them to my R2 bucket. However, when I try to open the resulting .sql files locally, they appear to be corrupted. My IDE shows the following message:

The file is not displayed in the text editor because it is either binary or uses an unsupported text encoding.

Is the backup still valid, or does this indicate corruption? If it is corrupted, how can I configure Dokploy to back up the database in a readable text format (for example, UTF-8–encoded SQL)?

Thanks!

[mstaack]

postgres?if i remember correctly, dokploy uses the binary format. check pg_dump formats.... its a non text dump which only can be used with pg_restore

[Splicho]

Yeah I spun up a postgres db. Does that mean Dokploy is unable to backup postgres databases properly or what do you try to say?

[mstaack]

postgres dump format is not plain text! its a custom binary format. read about the format here:
https://www.postgresql.org/docs/current/app-pgdump.html

[Splicho]

postgres dump format is not plain text! its a custom binary format. read about the format here: https://www.postgresql.org/docs/current/app-pgdump.html

But dokploy didn't generate a .dump, it generated a .sql file archived into a gzip.

For context:

What I did was, I went into my Postgres DB service/application on Dokploy -> Backups -> Created a daily midnight backup -> Automated upload to CloudFlare R2

[Splicho]

Still looking for a solution within Dokploy, anyone has one?