How to update from ts 2.1.0? Docker container is failing on startup

kiesel · September 11, 2023, 10:30pm

In brief:
I have a dump of a DB that uses ts version 2.1.0-dev, which I want to restore.
I can’t use it with ts 2.11 and I can’t use docker image timescale/timescaledb-ha:pg12.6-ts2.1.0-latest because it crashes with /docker-entrypoint.sh: line 288: exec: su-exec: not found.
What to do?

TimescaleDB version: 2.1.0-dev
PostgreSQL version: 12
Other software: Postgis 3.2.1
OS: Debian
Platform: amd64
Install method: Docker
Environment: Test

I am moving from an ARM to an AMD64 environment. This has proven quite the challenge because the newest timescale docker container for pg12 starts, but can’t restore my dump and the corresponding version doesn’t start on the new architecture.

Any ideas? Thanks!

jonatasdp · September 12, 2023, 12:52pm

I’d just try to use psql and use like COPY to copy the data from your hypertables.

It can be a simple sql like this example:

github.com

jonatas/sql-data-science-training/blob/main/update_data.sh#L9


      
          #! /bin/bash
          set -x
          
          CITIES=("Nairobi" "New York" "Princeton" "Stockholm" "Toronto" "Vienna")
          
          for city in "${CITIES[@]}"
          do
            csv=$(echo $city | tr '[:upper:]' '[:lower:]' | tr ' ' '_')
            psql $openweather_uri -c "\copy (select * from weather_metrics where city_name = '$city') TO data/$csv.csv DELIMITER ',' CSV"
          done

I’m just exporting in separated csvs because I’d like to load them one by one but you can probably do select * from

and in the other way around, you can also do the import from the csv.

\COPY weather_metrics FROM './data/nairobi.csv' DELIMITER ',' CSV HEADER;
\COPY weather_metrics FROM './data/new_york.csv' DELIMITER ',' CSV HEADER;
\COPY weather_metrics FROM './data/toronto.csv' DELIMITER ',' CSV HEADER;
\COPY weather_metrics FROM './data/stockholm.csv' DELIMITER ',' CSV HEADER;
\COPY weather_metrics FROM './data/princeton.csv' DELIMITER ',' CSV HEADER;
\COPY weather_metrics FROM './data/vienna.csv' DELIMITER ',' CSV HEADER;

kiesel · September 12, 2023, 1:41pm

Thanks for the reply @jonatasdp!

Could you elaborate on the “try to take another dump using a different format, more raw to data”-part? What format is recommended?

I am absolutely on board with migrating to pg15 and ts 2.11, I am just unsure how at this point.

jonatasdp · September 12, 2023, 3:09pm

I thought I was replying and it end up updating my previous answer

@kiesel please check it again