Error railway database backup
mateo
PROOP

2 years ago

Hello everyone, I have completed all the necessary configurations to perform the daily backup of my PostgreSQL database in the provided documentation https://blog.railway.app/p/automated-postgresql-backups. However, during the execution of this process, an error occurred, and I am unsure of both the cause and how to resolve it. I would greatly appreciate your assistance in addressing this issue.

Error response:
NodeJS Version: v18.18.2

Backup cron scheduled…

Initiating DB backup…

Dumping DB to file…

Error while running backup: {

stderr: 'pg_dump: warning: there are circular foreign-key constraints on this table:\n' +

'pg_dump: detail: hypertable\n' +

'pg_dump: hint: You might not be able to restore the dump without using --disable-triggers or temporarily dropping the constraints.\n' +

'pg_dump: hint: Consider using a full dump instead of a --data-only dump to avoid this problem.\n' +

'pg_dump: warning: there are circular foreign-key constraints on this table:\n' +

'pg_dump: detail: chunk\n' +

'pg_dump: hint: You might not be able to restore the dump without using --disable-triggers or temporarily dropping the constraints.\n' +

'pg_dump: hint: Consider using a full dump instead of a --data-only dump to avoid this problem.'

}

1 Replies

2 years ago

known issue, I've already created a PR to fix that here

https://github.com/railwayapp-templates/postgres-s3-backups/pull/13

until this gets merged you could fork my branch thats used in the PR and deploy that to your backup service


Loading...