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
Project ID:
a8c3ec2f-e491-45cc-a338-2abe95233acba8c3ec2f-e491-45cc-a338-2abe95233acb
I think the error is giving you some good pointers already
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
tbh that's more so a question for the pg_dump documentation
Ok thanks
Hey @gmcamposano what did you finally do ?
Didn’t do any backup :p. Do you perhaps know the answer?
I'm trying to understand this warning too, I don't have the answer 😅🤷♂️
I have tried following the exact tutorial from railway and I get this error
@🇩🇴gmcamposano if you didn't get backups going, here's a possible solution for you: https://railway.app/template/tqxaEg?referralCode=pfY63c
Thank you. I end up just ignoring that alert and doing the backups like if that waning never existed. 😄
Make sure to test restore! It's not a backup system unless it works both ways 😂