Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Timescaledb dump #2566

Closed
Kumar6295 opened this issue Oct 19, 2020 · 2 comments
Closed

Timescaledb dump #2566

Kumar6295 opened this issue Oct 19, 2020 · 2 comments

Comments

@Kumar6295
Copy link

Kumar6295 commented Oct 19, 2020

When we try to dump(Backup) database,below errors showing.
is it harmful to database/data or not?
How we can get database dump without below error with all the data?

pg_dump: NOTICE: 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: NOTICE: 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.

pg_dump: NOTICE: hypertable data are in the chunks, no data will be copied
DETAIL: Data for hypertables are stored in the chunks of a hypertable so COPY TO of a hypertable will not copy any data.
HINT: Use "COPY (SELECT * FROM ) TO ..." to copy all data in hypertable, or copy each chunk individually.

What is the reason this errors/warning are happening?

@svenklemm
Copy link
Member

These are only warnings/hints and can safely be ignored.

@svenklemm
Copy link
Member

Duplicate of #1581

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants