Backup and Restore Issue

213 views
Skip to first unread message

Satheesh Kumar

unread,
Sep 21, 2023, 11:03:19 AM9/21/23
to Postgres Operator
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

unread,
Sep 28, 2023, 4:47:25 PM9/28/23
to Postgres Operator, Satheesh Kumar
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

unread,
Sep 28, 2023, 4:49:24 PM9/28/23
to Postgres Operator, drew.s...@crunchydata.com, Satheesh Kumar
You might check this Timescale issue out:

Reply all
Reply to author
Forward
0 new messages