## 1. 停止b040容器
docker stop opengauss-b040

## 2. 使用b041版本启动（环境之前实际的启动命令，版本号改为b041）
vol_path=/test/dockervol5
docker run --name opengauss-b041 --net=ognetwork --privileged=true -p 7000:5432 -d -e GS_PASSWORD=Test@123 -v $vol_path:/var/lib/opengauss opengauss:6.0.0-b041


## 3. b041启动后执行升级sql (先解压upgradeb041.tar.gz)

docker_name=opengauss-b041
docker cp upgradeb041 ${docker_name}:/var/lib/opengauss/

docker exec ${docker_name} chown omm:omm /var/lib/opengauss/upgradeb041/ -R
docker exec ${docker_name} ls -al /var/lib/opengauss/upgradeb041
docker exec ${docker_name} su - omm -c "gs_guc reload -D /var/lib/opengauss/data -c 'upgrade_mode=2'"


docker exec ${docker_name} su - omm -c "gsql -d postgres -f /var/lib/opengauss/upgradeb041/upgrade-post_catalog_maindb_92_955.sql"

docker exec ${docker_name} su - omm -c "gsql -A -q -x -c \"select datname from pg_database where upper(datcompatibility) = 'B';\"" > database_tmplist
for db in `cat database_tmplist | grep datname | awk -F "|" '{print $2}'`;do 
	echo "exec upgrade sql on $db"
	docker exec ${docker_name} su - omm -c "gsql -d $db -f /var/lib/opengauss/upgradeb041/upgrade-post_catalog_otherdb_92_955.sql"
	echo "end upgrade sql on $db"
done;
docker exec ${docker_name} su - omm -c "gs_guc reload -D /var/lib/opengauss/data -c 'upgrade_mode=0'"