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