castled 运行试用

castled 官方直接提供了docker-compose 一键运行

环境运行

docker-compose

git clone https://github.com/castledio/castled.git

cd castled

docker-compose up -d 

pg 准备

docker run -d -p 5432:5432 -e POSTGRES_PASSWORD=dalong postgres:14.0

rest api server

docker run -p  80:80 -d kennethreitz/httpbin

权限分配
可以参考官方文档

 
-----------------------------------USER CREATON STARTS-------------------------------------------------------

— Create a new user CASTLED for connecting to postgres DB

CREATE USER CASTLED WITH PASSWORD 'dalongdemoapp';

-----------------------------------USER CREATON ENDS----------------------------------------------------------
 
-----------------------------------BOOK KEEPING SCHEMA ACCESS STARTS------------------------------------------

-- Create a private bookkeeping schema for storing sync data

CREATE SCHEMA CASTLED;
 
-- Give the CASTLED user full access to the bookkeeping schema

GRANT ALL ON SCHEMA CASTLED TO CASTLED;
 
-- Give CASTLED user access to all objects existing n the bookkeeping schema

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA CASTLED TO CASTLED;
 
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA PUBLIC TO CASTLED;