Disable tiering on a hypertable

Call remove_tiering_policy and drop any tiering policy associated with this hypertable.

Make sure that there is no tiered data associated with this hypertable:

1. List the tiered chunks associated with this hypertable:

   select * from timescaledb_osm.tiered_chunks

   Copy

2. If you have any tiered chunks, either untier this data, or drop these chunks from tiered storage.

   You can use the untier_chunk procedure to untier chunks that have already been tiered to local storage.

Use disable_tiering to drop all tiering related metadata for the hypertable:

select disable_tiering('my_hypertable_name');

Copy

Verify that tiering has been disabled by listing the hypertables that have tiering enabled.

select * from timescaledb_osm.tiered_hypertables;

Copy