© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago
ray

Error using timescaledb

Hi, I'm currently getting my local environment set up with supabase and when I try to run
supabase db remote commit
supabase db remote commit
I'm getting the error
 Error: Error running pg_dump on remote database: pg_dump: warning: there are circular foreign-key constraints on this table:
pg_dump:   hypertable
pg_dump: You might not be able to restore the dump without using --disable-triggers or temporarily dropping the constraints.
pg_dump: 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:   chunk
pg_dump: You might not be able to restore the dump without using --disable-triggers or temporarily dropping the constraints.
pg_dump: Consider using a full dump instead of a --data-only dump to avoid this problem.
 Error: Error running pg_dump on remote database: pg_dump: warning: there are circular foreign-key constraints on this table:
pg_dump:   hypertable
pg_dump: You might not be able to restore the dump without using --disable-triggers or temporarily dropping the constraints.
pg_dump: 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:   chunk
pg_dump: You might not be able to restore the dump without using --disable-triggers or temporarily dropping the constraints.
pg_dump: Consider using a full dump instead of a --data-only dump to avoid this problem.

This seems to be a common issue when working with timescaledb as indicated by issues like this. https://github.com/timescale/timescaledb/issues/1581

I believe this could be solved by adding the flag
--disable-triggers
--disable-triggers
to the pg_dump command but how would I append that flag to the
supabase db remote commit
supabase db remote commit
command? Thanks again!
GitHub
circular warning while backup using pg_dump with version 1.5.1 · Is...
Relevant system information: OS: archlinux 64bit kernel 5.1.15 PostgreSQL version (output of postgres --version): postgres (PostgreSQL) 11.2 TimescaleDB version (output of \dx in psql): 1.5.1 Insta...
circular warning while backup using pg_dump with version 1.5.1 · Is...
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources
Was this page helpful?

Similar Threads

Recent Announcements

Similar Threads

TimeScaleDB on Supabase
SupabaseSSupabase / help-and-questions
4y ago
Partition management | Timescaledb -> pg_partman?
SupabaseSSupabase / help-and-questions
2mo ago
Why TimescaleDB extension got deprecated?
SupabaseSSupabase / help-and-questions
7mo ago
Upgrade TimeScaleDB to Community edition
SupabaseSSupabase / help-and-questions
4y ago