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

最新推荐文章于 2024-05-25 09:00:00 发布

aileen5150

最新推荐文章于 2024-05-25 09:00:00 发布

阅读量205

点赞数

分类专栏： postgresql docker

本文链接：https://blog.csdn.net/aileen5150/article/details/118574190

版权

docker 同时被 2 个专栏收录

12 篇文章 0 订阅

订阅专栏

postgresql

10 篇文章 0 订阅

订阅专栏

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