Pg_dump for hypertable not working

TimescaleDB and PostgreSQL
1

Hi,

Trying to get a data export for a 30gb hypertable using pg_dump :-

postgres version 14.13
timescale version 2.14.2

Currently failing with below error :-

pg_dump -Fc -v -t mytab_v4 -f mytab_v4.dmp

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 <hypertable>) TO ..." to copy all data in hypertable, or copy each chunk individually.

I know I could use \COPY but given the size of the table, this is suboptimal, any clues/help on fixing the above error ?

2

Consider the second option :point_up:

You can use show_chunks and then use COPY one by one.

You can also use the range from the timescaledb information to copy then by range, so, you just open and export one by one.