I have tried to backup and restore a database according to the docs at https://docs.timescale.com/self-hosted/latest/backup-and-restore/pg-dump-and-restore/
This did not work, I kept getting
pg_restore: error: did not find magic string in file header as an error.
PostgreSQL version is 12.9 and TimescaleDB version is 2.5.1
I then tried to use pg_dump without the -Fc option, which creates an ASCII backup. I could restore this like so:
psql --set ON_ERROR_STOP=on -U myuser -f /dbdump-asc.sql
Cursory tests of our application show that the data from the hypertable appears to be there. But my concern is now that perhaps the ASCII backup isn’t suitable for the binary hypertable chunks. Is there a way to verify that those were indeed restored correctly?