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
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.

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
to the pg_dump command but how would I append that flag to the 
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...
Was this page helpful?