Details:
TimescaleDB version: 2.9.3
PostgreSQL version:13.9
Platform: Kuberntes
Install method: Helm chart (TimescaleDB)
Environment: [Production]
I want to backup single database using pg_dump , here is the command that I am using,
time pg_dump -h kapi-timescaledb-replica.prod -p 5432 -U postgres -Fc -f /pgdata/db.bak db```
Here is the Error we are getting,
pg_dump: warning: there are circular foreign-key constraints on this table:
pg_dump: warning: there are circular foreign-key constraints on this table:
pg_dump: warning: there are circular foreign-key constraints on this table:
pg_dump: error: Dumping the contents of table "_hyper_39_8142_chunk" failed: PQgetResult() failed.
pg_dump: detail: Error message from server: ERROR: canceling statement due to conflict with recovery
DETAIL: User query might have needed to see row versions that must be removed.
pg_dump: detail: Command was: COPY _timescaledb_internal._hyper_39_8142_chunk (source, id, revision, clazz, creator, changed_at, company_id, key_id, payload) TO stdout;
Command exited with non-zero status 1
real 1m 57.39s
user 1m 34.84s
sys 0m 6.84s