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.
Project ID: a8c3ec2f-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
Deploy Postgres Backup to GCS on Railway
Postgres backups to Google Cloud Storage (GCS)
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 😂

Looking for more? Join the community!

Want results from more Discord servers?
Add your server
Recommended Posts
How to check which region is the database in and how to request to change it (if needed)?We started on the hobby plan and now we are Pro plan. For GDPR compliance we need to check which regDjango projects loading issuesI have two Django projects that I have deployed and both projects are facing similar issues (most liClicking 'Observability' button goes to the wrong projectExpected Flow - You click on a project, go to 'Observability' and view the logs. - You then click onTell Nixpack to include public folder in buildI have an Axum build on Rust that is are web socket chat rooms, which also serves static files. When.NET 6.0 Deployment Failed during build processProject ID f8a04cde-c088-4000-923e-0de1e0d144aa I can not deploy my backend, this is the error NETSMonorepoIf I am inside monorepo how will assigning domain work I wanna asign domain in two aspectsI can not deploy angular project, killedI do not know what is the problem I hope someone can help me, Project ID dd70810d-29a4-4c5e-b7b4-f2NPM ssh dependancyHi I'm running into an issue where I'm using a private github npm dependancy and the build step is How to set mailgun to Ghost(docker) + SqliteI had used Ghost with mysql, but currently I try to use a new Ghost template with Sqlite. I did not Timeout while waiting for registry?All of my deploys have been building successfully but failing to deploy for the past ~hour or so. TContainer is failing to start.Everything was working fine, I just added a few new features to the app and now it is failing to depSeeing failures in deploying saying container shut down, but cannot find the container logs.Need help figuring out how to debug this issue with deploying to prod. From my end I don't think theHow to Delete Project?How do I delete a project I created so it doesn't show up in my homepage? Railway's documentation juInitial Deployment Continues To FailHello everyone. I am trying to setup, and stuck at the starting line. All ive done is connect githubDeployments sometimes takes timeMany times deployments take more than 5 minutes, although it should take less than 1 minute.Sveltekit memory usagemy sveltekit apps are almost locked to 100mb memory, anyone knows if theres like an option or somethOpen SourceHi, I am Richard, creator of ExpressoTS framework. Currently we are working in a section of our docuDifficulty with deploying a Flask + React appHi - I have a code architecture with a Flask backend (python) and a Node React frontend. The architeAny way to measure API Metrics for APIs deployed via Railwaythe no. of requests, the avg response timeMultiple accounts with same Github account?Can I somehow have multiple accounts but use code from the same Github account? I want to have a sep