Backup and Restore Issue

[Satheesh Kumar]

I have followed procedure mentioned in this document for pg_dump and pg_restore

https://docs.timescale.com/use-timescale/latest/migration/pg-dump-and-restore/#restore-your-entire-database-from-backup

But Still i am getting below error

psql:/tmp/alldb.sql:27303: ERROR:  operation not supported on chunk tables
psql:/tmp/alldb.sql:27312: ERROR:  operation not supported on chunk tables
psql:/tmp/alldb.sql:27321: ERROR:  operation not supported on chunk tables
psql:/tmp/alldb.sql:27330: ERROR:  operation not supported on chunk tables
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
psql:/tmp/alldb.sql:27393: ERROR:  ONLY option not supported on hypertable operations
psql:/tmp/alldb.sql:27573: ERROR:  ONLY option not supported on hypertable operations
psql:/tmp/alldb.sql:27582: ERROR:  ONLY option not supported on hypertable operations

[drew.s...@crunchydata.com]

Satheesh,

Your errors are referencing chunk tables and hypertables, both Timescale specific things. I recommend you seek support in a Timescale specific forum.

Regards,

Drew

[drew.s...@crunchydata.com]

You might check this Timescale issue out:

https://github.com/timescale/timescaledb/issues/531