dro59505 2019-04-21 04:50
浏览 145
已采纳

如何使用docker-compose运行golang-migrate?

In golang-migrate's documentation, it is stated that you can run this command to run all the migrations in one folder.

docker run -v {{ migration dir }}:/migrations --network host migrate/migrate
    -path=/migrations/ -database postgres://localhost:5432/database up 2

How would you do this to fit the syntax of the new docker-compose, which discourages the use of --network?

And more importantly: How would you connect to a database in another container instead to one running in your localhost?

  • 写回答

1条回答 默认 最新

  • doutuan4361 2019-04-21 04:50
    关注

    Adding this to your docker-compose.yml will do the trick:

        db:
            image: postgres
            networks:
                new:
                    aliases:
                        - database
            environment:
                POSTGRES_DB: mydbname
                POSTGRES_USER: mydbuser
                POSTGRES_PASSWORD: mydbpwd
            ports:
                - "5432"
        migrate:
            image: migrate/migrate
            networks:
                - new
            volumes:
                - .:/migrations
            command: ["-path", "/migrations", "-database",  "postgres://mydbuser:mydbpwd@database:5432/mydbname?sslmode=disable", "up", "3"]
            links: 
                - db
    networks:
          new:
    

    Instead of using the --network host option of docker run you set up a network called new. All the services inside that network gain access to each other through a defined alias (in the above example, you can access the db service through the database alias). Then, you can use that alias just like you would use localhost, that is, in place of an IP address. That explains this connection string:

    "postgres://mydbuser:mydbpwd@database:5432/mydbname?sslmode=disable"
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 k210烧入flash报错error:2005
  • ¥15 GIS土地利用预测FLUS模型
  • ¥15 visual studio code打不出来中文双引号
  • ¥20 关于#matlab#的问题:ps:完美符合要求有打赏(相关搜索:自适应)
  • ¥15 声音感应灯,问题出在哪里
  • ¥15 关于#matlab#的问题:(0,0)上的贝塞尔曲线,0)上的贝塞尔曲线,并使用自适应积分计算其从t=0到不大于1的任意值区间的弧长
  • ¥20 关于#r语言#rda分析作图的问题,请各位专家解答!
  • ¥50 找回 股票行情系统的资源问题
  • ¥15 gwas 分析-plink 检查人口分层出现下面问题
  • ¥15 关于#matlab#的问题:需要 MATLAB 运行程序,对比四个多址通信方式(TDMA,FDMA,CDMA,OFDMA)的抗噪声性能