《PostgreSQL+PolarDB开源数据库人才认证培训》实验手册持续建设 about blog HOT 3 OPEN

# 拉取镜像, 第一次拉取一次即可.  
docker pull registry.cn-hangzhou.aliyuncs.com/digoal/opensource_database:pg14_with_exts  
  
# 启动容器  
docker run -d -it --cap-add=SYS_PTRACE --cap-add SYS_ADMIN --privileged=true --name pg registry.cn-hangzhou.aliyuncs.com/digoal/opensource_database:pg14_with_exts  
  
# 进入容器  
docker exec -ti pg bash  
  
# 连接数据库  
psql

[root@iZuf6g6afqwaglx4kxuskxZ ~]# docker images  
REPOSITORY                                                     TAG              IMAGE ID       CREATED        SIZE  
registry.cn-hangzhou.aliyuncs.com/digoal/opensource_database   pg14_with_exts   1b9d30ed2910   5 days ago     5.25GB  
polardbx/polardb-x                                             latest           f4da3f72d974   3 months ago   2.91GB  
polardb/polardb_pg_local_instance                              htap             62fcb916564e   3 months ago   5.65GB  
polardb/polardb_pg_devel                                       latest           bc8f10854b35   3 months ago   1.92GB  

docker run -d -it --cap-add=SYS_PTRACE --privileged=true --name polardb-pg polardb/polardb_pg_local_instance:htap   

docker exec -ti polardb-pg bash  

psql -h 127.0.0.1 -c 'select version();'  

docker stop polardb-pg  

docker rm polardb-pg  

docker run -d --name polardb-x -p 8527:8527 polardbx/polardb-x  

docker exec -ti polardb-x bash  

mysql -h127.0.0.1 -P8527 -upolardbx_root -p123456  

docker stop polardb-x  

docker rm polardb-x  

docker run -d -it --cap-add=SYS_PTRACE --cap-add SYS_ADMIN --privileged=true --name pg registry.cn-hangzhou.aliyuncs.com/digoal/opensource_database:pg14_with_exts  

docker exec -ti pg bash  

psql  

docker stop pg  

docker rm pg