26 openGauss容器数据库版本升级.txt

李宏达

208

4页

0次

2022-10-10

100墨值下载

# 一、文件目录

```s

[mogdb@ecs-lee upgrade]$ ls -lrt

total 4372

-rwxr-xr-x 1 mogdb mogdb 1100 Apr 1 18:34 upgrade_GAUSSV5.sh

-rw-r--r-- 1 mogdb mogdb 392 May 26 09:55 upgrade_errorcode.sh

drwxrwxr-x 9 mogdb mogdb 4096 May 26 10:06 pkg_2.1.1

drwxrwxr-x 9 mogdb mogdb 4096 May 26 10:20 pkg_3.0.0_beta1

drwxrwxr-x 9 mogdb mogdb 4096 May 31 14:28 pkg_3.0.0_beta2

-rw-r--r-- 1 mogdb mogdb 755 May 31 14:29 upgrade_config.sh

-rwxr-xr-x 1 mogdb mogdb 39150 May 31 14:30 upgrade_common.sh

drwx------ 4 mogdb mogdb 4096 May 31 14:31 bak

drwx------ 5 mogdb mogdb 4096 May 31 14:50 tmp

-rw------- 1 mogdb mogdb 4343558 May 31 14:50 upgrade.log

-rw-rw-r-- 1 mogdb mogdb 51200 Jun 1 10:00 upgrade.tar

```

# 二、文件解释

- upgrade_GAUSSV5.sh :主控文件，调用 upgrade_common.sh。

- upgrade_errorcode.sh:错误代码

- upgrade_config.sh:配置信息

- upgrade_common.sh:实际升级文件

- upgrade.log:升级日志

- pkg_2.1.1,pkg_3.0.0_beta1,pkg_3.0.0_beta2:数据库升级根位置

- bak:数据库低版本备份位置

- tmp:数据库临时目录

# 三、环境变量

```s

[mogdb@ecs-lee upgrade]$ cat ~/.bashrc

export GAUSSDATA=/home/mogdb/2.0.0_data/data

export GAUSSHOME=/home/mogdb/2.0.0

export PATH=$GAUSSHOME/bin:$PATH

export LD_LIBRARY_PATH=$GAUSSHOME/lib:$LD_LIBRARY_PATH

```

# 四、配置文件解释

```s

[mogdb@ecs-lee upgrade]$ cat upgrade_config.sh

#!/bin/bash

# date: 2021-12-22

# version: 1.0

# 数据库监听端口

GAUSS_LISTEN_PORT="5432"

# 数据库管理员用户名

GAUSS_ADMIN_USER="mogdb"

#数据库升级回退日志路径

GAUSS_LOG_PATH="/home/mogdb/upgrade"

#数据库升级根位置

GAUSS_UPGRADE_BASE_PATH="/home/mogdb/upgrade/pkg_3.0.0_beta2"

#数据库 SQL 包位置

GAUSS_SQL_TAR_PATH="/home/mogdb/upgrade/pkg_3.0.0_beta2"

#数据库低版本备份位置

GAUSS_BACKUP_BASE_PATH="/home/mogdb/upgrade/bak"

#数据库临时目录

GAUSS_TMP_PATH="/home/mogdb/upgrade/tmp"

#是否使用存在的 bin 解压包

GAUSS_UPGRADE_BIN_PATH=""

#需要同步的 cluster config 列表

GAUSS_UPGRADE_SYNC_CONFIG_LIST=""

```

# 五、正常执行流程及输出

- upgrade_pre

```s

[mogdb@ecs-lee upgrade]$ sh upgrade_GAUSSV5.sh -t upgrade_pre

Current env value: GAUSSHOME is /home/mogdb/2.0.0, PGDATA is

/home/mogdb/2.0.0_data/data.

Parse cmd line successfully.

Check available disk space successfully.

Big upgrade is needed!

Old version commitId is f892ccb7, version info is 92299

New version commitId is 03211457, version info is 92421

decompress upgrade_sql.tar.gz successfully.

kernel: CentOS

Bak gausshome successfully.

Bak postgresql.conf successfully.

Bak pg_hba.conf successfully.

begin decompress pkg in /home/mogdb/upgrade/tmp/install_bin_03211457

Decompress MogDB-2.1.1-CentOS-64bit.tar.bz2 successfully.

cp version.cfg successfully

input sql password:

The upgrade_pre step is executed successfully.

```

- upgrade_bin

```s

[mogdb@ecs-lee upgrade]$ sh upgrade_GAUSSV5.sh -t upgrade_bin

Current env value: GAUSSHOME is /home/mogdb/2.0.0, PGDATA is

/home/mogdb/2.0.0_data/data.

Parse cmd line successfully.

Binfile upgrade to new version successfully.

Delete guc successfully

start gaussdb by cmd: gs_ctl start -D /home/mogdb/2.0.0_data/data -o '-u

92299' --single_node

The upgrade_bin step is executed successfully.

```

- upgrade_post

```s

[mogdb@ecs-lee upgrade]$ sh upgrade_GAUSSV5.sh -t upgrade_post

Current env value: GAUSSHOME is /home/mogdb/2.0.0, PGDATA is

/home/mogdb/2.0.0_data/data.

Parse cmd line successfully.

input sql password:

of 4

100墨值下载

lession

关注

评论