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


Welcome!

Sign in to your Railway account to join the conversation.

Loading...