influx 1.7.7 alpine docker-compose 创建数据库并设置保存策略

version: "3"
services:                   
    influxdb:
        image: reg.ji.com/influxdb:1.7.7-alpine
        restart: always
        volumes:
            - "$VOLUME_PATH/influxdb:/var/lib/influxdb"
        ports:
            - 8086:8086
        #entrypoint: 
        entrypoint: 
            - /entrypoint.sh 
        command: sh -c "sleep 10 && influx -execute \"create database mydb;CREATE RETENTION POLICY one_month ON mydb DURATION 30d REPLICATION 1 DEFAULT;\" & influxd " 

outflux，将influxdb中的数据导入到postgresql timescaledb中

https://docs.timescale.com/timescaledb/latest/how-to-guides/migrate-data/migrate-influxdb#schema-discovery-validation-and-transfer

 

./outflux migrate 1912 tracks --input-server=http://192.168.0.230:8086 --output-conn="dbname=1912 user=postgres password=123456 host=10.10.11.192 port=5432" --schema-strategy=DropAndCreate --tags-as-json