Trying to pg_dump and getting this weird error:

Hi guys I am following this tutorial: https://blog.railway.app/p/postgre-backup and i am getting this error. Anyone know how to get rid of it to have a fully working backup? pg_dump: warning: there are circular foreign-key constraints on this table: pg_dump: detail: hypertable pg_dump: hint: You might not be able to restore the dump without using --disable-triggers or temporarily dropping the constraints. pg_dump: hint: Consider using a full dump instead of a --data-only dump to avoid this problem. pg_dump: warning: there are circular foreign-key constraints on this table: pg_dump: detail: chunk
Railway Blog
How to Backup and Restore Your Postgres Database
In this post, we will go over the process of backing up and restoring your Postgres database hosted on Railway.
13 Replies
Percy
Percy15mo ago
Project ID: a8c3ec2f-e491-45cc-a338-2abe95233acb
🇩🇴gmcamposano
a8c3ec2f-e491-45cc-a338-2abe95233acb
Brody
Brody15mo ago
I think the error is giving you some good pointers already
🇩🇴gmcamposano
But isn’t that flag of —disable-triggers just something to use temporary? It says something regarding the table chunk and hypertable, which I have no clue what I have to do with those
Brody
Brody15mo ago
tbh that's more so a question for the pg_dump documentation
🇩🇴gmcamposano
Ok thanks
Mattèo
Mattèo14mo ago
Hey @gmcamposano what did you finally do ?
🇩🇴gmcamposano
Didn’t do any backup :p. Do you perhaps know the answer?
Mattèo
Mattèo14mo ago
I'm trying to understand this warning too, I don't have the answer 😅🤷‍♂️
🇩🇴gmcamposano
I have tried following the exact tutorial from railway and I get this error
SCIENTIFIC
SCIENTIFIC13mo ago
@🇩🇴gmcamposano if you didn't get backups going, here's a possible solution for you: https://railway.app/template/tqxaEg?referralCode=pfY63c
Railway
Deploy Postgres Backup to GCS on Railway
Postgres backups to Google Cloud Storage (GCS)
🇩🇴gmcamposano
Thank you. I end up just ignoring that alert and doing the backups like if that waning never existed. 😄
SCIENTIFIC
SCIENTIFIC13mo ago
Make sure to test restore! It's not a backup system unless it works both ways 😂
Want results from more Discord servers?
Add your server