Error when creating Postgres backup

I'm trying out backups, but I get this error:

[
    {
        "error": {
            "json": {
                "message": "Error to run manual postgres backup ",
                "code": -32600,
                "data": {
                    "code": "BAD_REQUEST",
                    "httpStatus": 400,
                    "path": "backup.manualBackupPostgres",
                    "zodError": null
                }
            }
        }
    }
]

[
    {
        "error": {
            "json": {
                "message": "Error to run manual postgres backup ",
                "code": -32600,
                "data": {
                    "code": "BAD_REQUEST",
                    "httpStatus": 400,
                    "path": "backup.manualBackupPostgres",
                    "zodError": null
                }
            }
        }
    }
]

13 Replies

Siumauricio•7mo ago

Your S3 destinatation is working fine did you test the connection?

tschuehlyOP•7mo ago

Also throws an error What should I put in region? I use Cloudflare R2 What permission does the token need?

tschuehlyOP•7mo ago

Siumauricio•7mo ago

I guess write In the region put enam?

tschuehlyOP•7mo ago

I created a temporary token Access Key: d2e21234bf591c5d90b868c22ad6f6f3 Secret: fdcbcca39ba58654d032c4c2aeaeadc9aaa43173cee3cb6f519e96e8f29884ee bucket: dokploy-backup-test endpoint: https://3f077e0dd35e1daabccb43ada90e425f.eu.r2.cloudflarestorage.com

Siumauricio•7mo ago

in my case I have like this

tschuehlyOP•7mo ago

works now weird tried it before with enam @Siumauricio How do you rollback to a certain backup version?

Siumauricio•7mo ago

not possible for now to rollback

tschuehlyOP•7mo ago

I'm not sure I understand, but what is the use of a backup when you can't use it? I tried to download the sql file but it is a binary? @Siumauricio is that true?

Siumauricio•7mo ago

yes is a binary which allow to you to import to the database in the case I need to restore I download the backup, expose the database to the internet, connect to the db using pgadmin for example and then importing the file

tschuehlyOP•7mo ago

ah ok, why is it not a SQL dump? https://www.postgresql.org/docs/current/backup-dump.html That would be easier I think 🙂

PostgreSQL Documentation

25.1. SQL Dump

25.1. SQL Dump # 25.1.1. Restoring the Dump 25.1.2. Using pg_dumpall 25.1.3. Handling Large Databases The idea behind this dump method …

Siumauricio•7mo ago

there's a feature request on github is not implemented yet

Siumauricio•7mo ago

in fact we use pg dump to create the backup https://github.com/Dokploy/dokploy/blob/canary/packages/server/src/utils/backups/postgres.ts#L34

GitHub

dokploy/packages/server/src/utils/backups/postgres.ts at canary · D...

Open Source Alternative to Vercel, Netlify and Heroku. - Dokploy/dokploy

Gaming

Programming

Error when creating Postgres backup

Did you find this page helpful?