Schema Migration with Bytebase

使用Docker拉起Bytebase，对PG的模式进行版本化管理

公开Demo地址：http://ddl.pigsty.cc

默认用户名与密码： admin / pigsty

Bytebase Schema Migrator - 图1

Bytebase概览

Schema Migrator for PostgreSQL

  1. cd app/bytebase; make up

Visit http://ddl.pigsty or http://10.10.10.10:8887

  1. make up         # pull up bytebase with docker-compose in minimal mode
  2. make run        # launch bytebase with docker , local data dir and external PostgreSQL
  3. make view       # print bytebase access point
  4. make log        # tail -f bytebase logs
  5. make info       # introspect bytebase with jq
  6. make stop       # stop bytebase container
  7. make clean      # remove bytebase container
  8. make pull       # pull latest bytebase image
  9. make rmi        # remove bytebase image
  10. make save       # save bytebase image to /tmp/bytebase.tgz
  11. make load       # load bytebase image from /tmp

使用外部的PostgreSQL

Bytebase use its internal PostgreSQL database by default, You can use external PostgreSQL for higher durability.

  1. # postgres://dbuser_bytebase:DBUser.Bytebase@10.10.10.10:5432/bytebase
  2. db:   { name: bytebase, owner: dbuser_bytebase, comment: bytebase primary database }
  3. user: { name: dbuser_bytebase , password: DBUser.Bytebase, roles: [ dbrole_admin ] }

if you wish to user an external PostgreSQL, drop monitor extensions and views & pg_repack

  1. DROP SCHEMA monitor CASCADE;
  2. DROP EXTENSION pg_repack;

After bytebase initialized, you can create them back with /pg/tmp/pg-init-template.sql

  1. psql bytebase < /pg/tmp/pg-init-template.sql

Last modified 2022-06-03: add scaffold for en docs (6a6eded)