Vastbase G100 V3 单机静默安装实战：CentOS 7.9 环境

mkdir /mnt

cat >> /etc/yum.repos.d/local.repo << "EOF"
[local]
name=Local Repository
baseurl=file:///mnt
enabled=1
gpgcheck=0

EOF

mount -o loop CentOS-7-x86_64-Everything-2009.iso /mnt

yum clean all
yum makecache

yum install -y zlib-devel libaio libuuid readline-devel krb5-libs libicu libxslt tcl perl openldap pam openssl-devel libxml2 bzip2

sudo firewall-cmd --state
sudo systemctl status firewalld.service

sudo systemctl stop firewalld.service

sudo systemctl disable firewalld.service

vi /etc/systemd/system/disable-thp.service

[Unit]
Description=Disable Transparent Huge Pages (THP)
 
[Service]
Type=simple
ExecStart=/bin/sh -c "echo 'never' > /sys/kernel/mm/transparent_hugepage/enabled && echo 'never' > /sys/kernel/mm/transparent_hugepage/defrag"
 
[Install]
WantedBy=multi-user.target

systemctl daemon-reload
systemctl start disable-thp
systemctl enable disable-thp

cat /sys/kernel/mm/transparent_hugepage/enabled
cat /sys/kernel/mm/transparent_hugepage/defrag

timedatectl

cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime

vi /etc/systemd/logind.conf

vi /usr/lib/systemd/system/systemd-logind.service

systemctl daemon-reload
systemctl restart systemd-logind

loginctl show-session | grep RemoveIPC
systemctl show systemd-logind | grep RemoveIPC

cat >> /etc/sysctl.conf << "EOF"

#Vastbase setting
fs.aio-max-nr=1048576
fs.file-max= 76724600
kernel.sem = 4096 2097152000 4096 512000
kernel.shmall = 26843545         # pages,  80% MEM or higher
kernel.shmmax = 68719476736     # bytes,  50% MEM or higher
kernel.shmmin = 819200
net.core.netdev_max_backlog = 10000
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 4194304
net.core.somaxconn = 4096
net.ipv4.tcp_fin_timeout = 5
vm.dirty_background_bytes = 409600000 
vm.dirty_expire_centisecs = 3000
vm.dirty_ratio = 80
vm.dirty_writeback_centisecs = 50
vm.overcommit_memory = 0
vm.swappiness = 0
net.ipv4.ip_local_port_range = 40000 65535
fs.nr_open = 20480000

EOF

sysctl -p

setenforce 0
sed -ri 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config
sestatus

#根据您的ip地址主机名进行相应修改
hostnamectl set-hostname testdb-host
cat >> /etc/hosts << "EOF"

192.168.18.133    testdb-host

EOF

vi /etc/ssh/sshd_config
#PermitRootLogin no
PermitRootLogin yes

service sshd restart

useradd -m vastbase
passwd vastbase

mkdir -p /home/vastbase/data/db_coredump
chmod 770 /home/vastbase/data
chown vastbase:vastbase /home/vastbase/data

mkdir -p /home/vastbase/data/vastbase
chmod 700 /home/vastbase/data/vastbase
chown -R vastbase:vastbase /home/vastbase/data/vastbase

mkdir -p /home/vastbase/local/vastbase
chown -R vastbase:vastbase /home/vastbase

vi /etc/security/limits.conf

vastbase soft nproc unlimited
vastbase hard nproc unlimited
vastbase soft stack unlimited
vastbase hard stack unlimited
vastbase soft core unlimited
vastbase hard core unlimited
vastbase soft memlock unlimited
vastbase hard memlock unlimited
vastbase soft nofile 1024000
vastbase hard nofile 1024000

mkdir -p /soft/vb
cd /soft/vb
tar -xf Vastbase-G100-3.0_Build8_29407-Linux-x86_64-no_mot-202512072036.tar
chown -R vastbase:vastbase /soft/vb/
chmod -R 775 /soft/vb/

cd /soft/vb/
vi db_install.rsp

vastbase_password=Vbase@123
encryption_key=Aa123456
vastbase_home=/home/vastbase/local/vastbase
vastbase_data=/home/vastbase/data/vastbase
port=5432
max_connections=100
shared_buffers=200
db_compatibility=A
isinitdb=true

su - vastbase
cd /soft/vb/vastbase-installer/
./vastbase_installer --silent -responseFile /soft/vb/db_install.rsp

echo "/omTmp/corefile/core-%e-%p-%t" > /proc/sys/kernel/core_pattern

source ~/.bashrc

vb_ctl start

vb_ctl stop

vb_ctl restart

vb_ctl status

vi $PGDATA/pg_hba.conf
#如下为示例配置，表示配置允许来自IP地址xx.xx.xx.xx的客户端通过vastbase用户连接到所有数据库，并且连接方式为trust，即不需要密码验证。
host all vastbase xx.xx.xx.xx/32 trust

vsql -d postgres -p 5432

CREATE DATABASE testdb1;

CREATE USER dbuser PASSWORD 'Vbase@123';

CREATE DATABASE testdb2 OWNER dbuser TEMPLATE template0;

\l

DROP DATABASE testdb1;
DROP DATABASE testdb2;
DROP USER dbuser;

CREATE TABLE customer_t1
(
c_customer_sk integer not null,
c_customer_id char(6) not null,
c_first_name varchar(20) ,
c_last_name varchar(20) , 
c_country varchar(20)
);

CREATE TABLE customer_t2
(
c_customer_sk integer not null,
c_customer_id char(6) not null,
c_first_name varchar(20) ,
c_last_name varchar(20) ,
c_state CHAR(2) DEFAULT 'GA', 
c_country varchar(20)
);

\dt

\d tablename

CREATE TABLE customer_t3
(
c_customer_sk integer PRIMARY KEY,
c_customer_id char(6) not null,
c_first_name varchar(20) ,
c_last_name varchar(20) , 
c_country varchar(20)
);

CREATE TABLE public.customer_t4
(
c_customer_sk integer CHECK (c_customer_sk > 0),
c_customer_id char(6) not null,
c_first_name varchar(20) CHECK (c_first_name is not null),
c_last_name varchar(20) , 
c_country varchar(20)
);

ALTER TABLE customer_t1 ADD c_company varchar(30);

ALTER TABLE customer_t2 ADD CONSTRAINT c_CONSTR_KEY4 CHECK (c_customer_sk >10);

ALTER TABLE customer_t3 ALTER COLUMN c_country SET NOT NULL;

ALTER TABLE customer_t4 RENAME TO newtab;

DROP TABLE customer_t1;
DROP TABLE customer_t2;
DROP TABLE customer_t3;
DROP TABLE newtab;

\?

\l

\dt

\d tablename

\dn

\di

\c dbname

#!/usr/bin/env bash
# ============================================================
# Vastbase G100 3.0.x for Linux 单机一键静默安装脚本（EL7 优化最终版）
# 适用：CentOS/RHEL/OL 7.x（也可兼容多数 RHEL 系）
# 特性：
#   1) 完整日志：控制台 + 文件双写
#   2) 出错自动打印行号、命令、关键上下文
#   3) 自动探测安装包路径（PKG_DIR / 当前目录 / 脚本目录）
#   4) 修复安装器需在自身目录启动的问题
#   5) 避免 db_install.rsp 被解压步骤删除
#   6) EL7 兼容：RemoveIPC / THP / sysctl / locale 处理
#   7) 默认附带小内存启动参数，适合 4GB 测试机
#
# 用法：
#   chmod +x install_vastbase_g100_v3_final_el7.sh
#   ./install_vastbase_g100_v3_final_el7.sh
# ============================================================

set -Eeuo pipefail

# ------------------------------
# 可配置参数
# ------------------------------
VB_USER="vastbase"
VB_GROUP="vastbase"

# 安装包常用位置：
# 1) PKG_DIR/${PKG_FILE}
# 2) 当前执行目录/${PKG_FILE}
# 3) 脚本所在目录/${PKG_FILE}
PKG_DIR="/opt/vastbase_pkg"
PKG_FILE="Vastbase-G100-3.0_Build8_29407-Linux-x86_64-no_mot-202512072036.tar"

BASE_DIR="/home/${VB_USER}"
WORK_DIR="/opt/vastbase_work"
VB_HOME="${BASE_DIR}/local/vastbase"
VB_DATA="${BASE_DIR}/data/vastbase"
VB_CORE="${BASE_DIR}/corefile"
RSP_FILE="${BASE_DIR}/db_install.rsp"

PORT="5432"
DB_COMPATIBILITY="A"
IS_INITDB="true"
OPEN_REMOTE_ACCESS="yes"
INSTALLER_CMD=""

# 小内存测试机默认值（建议保守）
# 4GB 虚拟机建议保持以下值；内存 >= 8GB 可自行调大
MAX_CONNECTIONS="10"
SHARED_BUFFERS="64"   # installer 应答文件通常写整数，单位 MB
LOW_MEM_MODE="yes"
MAX_PROCESS_MEMORY="3072MB"
CSTORE_BUFFERS="16MB"
WAL_BUFFERS="4MB"
MAX_LOCKS_PER_TRANSACTION="16"
MAX_PRED_LOCKS_PER_TRANSACTION="16"
WORK_MEM="1MB"
MAINTENANCE_WORK_MEM="32MB"
MAX_PREPARED_TRANSACTIONS="0"

# 请自行修改密码
VB_PASSWORD='Aa123456!'
ENCRYPTION_KEY='Aa123456!'

# 日志目录
LOG_DIR="/var/log/vastbase"
LOG_FILE="${LOG_DIR}/install_vastbase_$(date +%F_%H%M%S).log"
INSTALLER_LOG="${LOG_DIR}/vastbase_installer_$(date +%F_%H%M%S).log"

# ------------------------------
# 日志与错误处理
# ------------------------------
COLOR_INFO='[1;32m'
COLOR_WARN='[38;5;208m'
COLOR_ERRO='[1;31m'
COLOR_RESET='[0m'

timestamp() {
  date "+%F %T"
}

init_logging() {
  mkdir -p "${LOG_DIR}"
  touch "${LOG_FILE}"
  chmod 600 "${LOG_FILE}"
  exec > >(tee -a "${LOG_FILE}") 2>&1

  echo -e "============================================================"
  echo -e "${COLOR_INFO}[INFO]${COLOR_RESET} $(timestamp) 日志文件: ${LOG_FILE}"
  echo -e "${COLOR_INFO}[INFO]${COLOR_RESET} $(timestamp) 安装器日志: ${INSTALLER_LOG}"
  echo -e "${COLOR_INFO}[INFO]${COLOR_RESET} $(timestamp) 脚本路径: $0"
  echo -e "============================================================"
}

log()  { echo -e "${COLOR_INFO}[INFO]${COLOR_RESET} $(timestamp) $*"; }
warn() { echo -e "${COLOR_WARN}[WARN]${COLOR_RESET} $(timestamp) $*"; }
err()  { echo -e "${COLOR_ERRO}[ERRO]${COLOR_RESET} $(timestamp) $*" >&2; }

run_step() {
  local step_name="$1"
  shift
  log ">>> 开始: ${step_name}"
  "$@"
  log "<<< 完成: ${step_name}"
}

dump_files() {
  echo "---------------- FILE SNAPSHOT BEGIN ----------------"
  echo "PKG_DIR=${PKG_DIR}"
  echo "PKG_FILE=${PKG_FILE}"
  echo "WORK_DIR=${WORK_DIR}"
  echo "VB_HOME=${VB_HOME}"
  echo "VB_DATA=${VB_DATA}"
  echo "RSP_FILE=${RSP_FILE}"
  echo
  ls -ld "${PKG_DIR}" 2>/dev/null || true
  ls -l "${PKG_DIR}" 2>/dev/null || true
  ls -ld "${WORK_DIR}" 2>/dev/null || true
  ls -l "${WORK_DIR}" 2>/dev/null || true
  ls -ld "${VB_HOME}" 2>/dev/null || true
  ls -ld "${VB_DATA}" 2>/dev/null || true
  [[ -f "${RSP_FILE}" ]] && ls -l "${RSP_FILE}" || true
  echo "---------------- FILE SNAPSHOT END ------------------"
}

dump_context() {
  echo "---------------- CONTEXT BEGIN ----------------"
  echo "TIME: $(timestamp)"
  echo "USER: $(id -un)"
  echo "PWD : $(pwd)"
  echo "SHELL: ${SHELL:-unknown}"
  echo
  dump_files
  echo
  echo "[INFO] 主日志最后 80 行："
  tail -n 80 "${LOG_FILE}" 2>/dev/null || true
  echo
  echo "[INFO] 安装器日志最后 80 行："
  tail -n 80 "${INSTALLER_LOG}" 2>/dev/null || true
  echo "---------------- CONTEXT END ------------------"
}

on_error() {
  local exit_code=$?
  local line_no=${1:-unknown}
  err "脚本执行失败，退出码=${exit_code}，失败行号=${line_no}，失败命令=${BASH_COMMAND}"
  dump_context
  exit "${exit_code}"
}

trap 'on_error $LINENO' ERR

# ------------------------------
# 工具函数
# ------------------------------
require_root() {
  if [[ "$(id -u)" -ne 0 ]]; then
    err "请使用 root 执行该脚本。"
    exit 1
  fi
}

detect_pm() {
  if command -v dnf >/dev/null 2>&1; then
    PM="dnf"
  elif command -v yum >/dev/null 2>&1; then
    PM="yum"
  else
    PM=""
  fi
}

detect_locale_value() {
  if locale -a 2>/dev/null | grep -qi '^en_US\.UTF-8$'; then
    echo "en_US.UTF-8"
  elif locale -a 2>/dev/null | grep -qi '^en_US\.utf8$'; then
    echo "en_US.utf8"
  elif locale -a 2>/dev/null | grep -qi '^C\.UTF-8$'; then
    echo "C.UTF-8"
  else
    echo "C"
  fi
}

find_package() {
  local script_dir
  script_dir=$(cd "$(dirname "$0")" && pwd)

  local candidates=(
    "${PKG_DIR}/${PKG_FILE}"
    "$(pwd)/${PKG_FILE}"
    "${script_dir}/${PKG_FILE}"
  )

  local c
  for c in "${candidates[@]}"; do
    if [[ -f "${c}" ]]; then
      echo "${c}"
      return 0
    fi
  done

  return 1
}

# 注释掉已有参数，避免重复值误导
comment_out_key() {
  local file="$1"
  local key="$2"
  if [[ -f "${file}" ]]; then
    sed -ri "/^[[:space:]#]*${key}[[:space:]]*=/ s/^/# old by script: /" "${file}" || true
  fi
}

set_conf() {
  local file="$1"
  local key="$2"
  local val="$3"
  comment_out_key "${file}" "${key}"
  echo "${key} = ${val}" >> "${file}"
}

# ------------------------------
# 安装前准备
# ------------------------------
install_deps() {
  detect_pm
  if [[ -z "${PM}" ]]; then
    warn "未检测到 yum/dnf，跳过依赖自动安装，请手工补齐依赖。"
    return 0
  fi

  log "安装常见依赖包..."
  # EL7 不再安装 glibc-langpack-en，避免 No package 错误
  ${PM} install -y \
    tar gzip which hostname sudo \
    zlib-devel libaio libuuid readline-devel \
    krb5-libs libicu libxslt tcl perl \
    openldap pam openssl-devel libxml2 bzip2
}

create_user_and_dirs() {
  log "创建用户与目录..."
  getent group "${VB_GROUP}" >/dev/null || groupadd "${VB_GROUP}"
  id "${VB_USER}" >/dev/null 2>&1 || useradd -m -g "${VB_GROUP}" "${VB_USER}"

  mkdir -p "${PKG_DIR}" "${WORK_DIR}" "${VB_HOME}" "${VB_DATA}" "${VB_CORE}"
  chown -R "${VB_USER}:${VB_GROUP}" "${BASE_DIR}" "${PKG_DIR}" "${WORK_DIR}"
  chmod 755 "${PKG_DIR}" "${WORK_DIR}"
}

set_limits() {
  log "配置资源限制..."
  cat >/etc/security/limits.d/99-vastbase.conf <<EOF2
${VB_USER} soft nproc unlimited
${VB_USER} hard nproc unlimited
${VB_USER} soft nofile 1024000
${VB_USER} hard nofile 1024000
${VB_USER} soft stack unlimited
${VB_USER} hard stack unlimited
${VB_USER} soft core unlimited
${VB_USER} hard core unlimited
${VB_USER} soft memlock unlimited
${VB_USER} hard memlock unlimited
EOF2
}

set_sysctl() {
  log "配置内核参数..."
  cat >/etc/sysctl.d/99-vastbase.conf <<'EOF2'
fs.aio-max-nr=1048576
fs.file-max= 76724600
kernel.sem = 4096 2097152000 4096 512000
kernel.shmall = 26843545         # pages,  80% MEM or higher
kernel.shmmax = 68719476736     # bytes,  50% MEM or higher
kernel.shmmni = 819200
net.core.netdev_max_backlog = 10000
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 4194304
net.core.somaxconn = 4096
net.ipv4.tcp_fin_timeout = 5
vm.dirty_background_bytes = 409600000 
vm.dirty_expire_centisecs = 3000
vm.dirty_ratio = 80
vm.dirty_writeback_centisecs = 50
vm.overcommit_memory = 0
vm.swappiness = 0
net.ipv4.ip_local_port_range = 40000 65535
fs.nr_open = 20480000
EOF2
  sysctl --system
}

disable_firewall_selinux() {
  log "关闭防火墙与 SELinux..."
  systemctl disable --now firewalld 2>/dev/null || warn "firewalld 未运行或关闭失败，已忽略"

  if command -v setenforce >/dev/null 2>&1; then
    setenforce 0 2>/dev/null || warn "setenforce 0 执行失败，已忽略"
  fi

  if [[ -f /etc/selinux/config ]]; then
    sed -ri 's/^SELINUX=.*/SELINUX=disabled/g' /etc/selinux/config || warn "修改 /etc/selinux/config 失败，已忽略"
  fi
}

disable_thp() {
  log "关闭透明大页 THP..."
  cat >/etc/systemd/system/disable-thp.service <<'EOF2'
[Unit]
Description=Disable Transparent Huge Pages
After=network.target

[Service]
Type=oneshot
ExecStart=/bin/sh -c 'test -f /sys/kernel/mm/transparent_hugepage/enabled && echo never > /sys/kernel/mm/transparent_hugepage/enabled || true'
ExecStart=/bin/sh -c 'test -f /sys/kernel/mm/transparent_hugepage/defrag && echo never > /sys/kernel/mm/transparent_hugepage/defrag || true'
RemainAfterExit=yes

[Install]
WantedBy=multi-user.target
EOF2
  systemctl daemon-reload
  systemctl enable disable-thp.service || warn "enable disable-thp.service 失败，已忽略"
  systemctl start disable-thp.service || warn "start disable-thp.service 失败，已忽略"
}

set_removeipc() {
  log "配置 RemoveIPC=no ..."

  # 1) /etc/systemd/logind.conf
  if [[ -f /etc/systemd/logind.conf ]]; then
    sed -ri 's/^[#[:space:]]*RemoveIPC=.*/RemoveIPC=no/' /etc/systemd/logind.conf || true
    grep -q '^RemoveIPC=no$' /etc/systemd/logind.conf || echo 'RemoveIPC=no' >> /etc/systemd/logind.conf
  else
    cat >/etc/systemd/logind.conf <<'EOF2'
[Login]
RemoveIPC=no
EOF2
  fi

  # 2) /etc/systemd/logind.conf.d/
  mkdir -p /etc/systemd/logind.conf.d
  cat >/etc/systemd/logind.conf.d/vastbase.conf <<'EOF2'
[Login]
RemoveIPC=no
EOF2

  # 3) /usr/lib/systemd/system/systemd-logind.service
  if [[ -f /usr/lib/systemd/system/systemd-logind.service ]]; then
    if grep -q '^RemoveIPC=' /usr/lib/systemd/system/systemd-logind.service; then
      sed -ri 's/^[#[:space:]]*RemoveIPC=.*/RemoveIPC=no/' /usr/lib/systemd/system/systemd-logind.service || true
    else
      sed -ri '/^\[Service\]/a RemoveIPC=no' /usr/lib/systemd/system/systemd-logind.service || true
    fi
  fi

  systemctl daemon-reload
  systemctl restart systemd-logind || warn "restart systemd-logind 失败，已忽略"

  log "验证 RemoveIPC 配置..."
  grep -n 'RemoveIPC' /etc/systemd/logind.conf 2>/dev/null || true
  grep -n 'RemoveIPC' /etc/systemd/logind.conf.d/vastbase.conf 2>/dev/null || true
  grep -n 'RemoveIPC' /usr/lib/systemd/system/systemd-logind.service 2>/dev/null || true
}

set_profile() {
  log "配置 ${VB_USER} 环境变量..."
  local profile_file="${BASE_DIR}/.bashrc"
  local locale_value
  locale_value=$(detect_locale_value)

  grep -q "VASTBASE ENV BEGIN" "${profile_file}" 2>/dev/null || cat >>"${profile_file}" <<EOF2

# ===== VASTBASE ENV BEGIN =====
export GAUSSHOME=${VB_HOME}
export VB_HOME=${VB_HOME}
export PGDATA=${VB_DATA}
export VB_DATA=${VB_DATA}
export PGPORT=${PORT}
export PATH=\$GAUSSHOME/bin:\$PATH
export LD_LIBRARY_PATH=\$GAUSSHOME/lib:\$LD_LIBRARY_PATH
export LANG=${locale_value}
export LC_ALL=${locale_value}
# ===== VASTBASE ENV END =====
EOF2

  chown "${VB_USER}:${VB_GROUP}" "${profile_file}"
}

# ------------------------------
# 解包与安装
# ------------------------------
write_rsp() {
  log "生成静默安装应答文件 ${RSP_FILE} ..."
  cat >"${RSP_FILE}" <<EOF2
vastbase_password=${VB_PASSWORD}
encryption_key=${ENCRYPTION_KEY}
vastbase_home=${VB_HOME}
vastbase_data=${VB_DATA}
port=${PORT}
max_connections=${MAX_CONNECTIONS}
shared_buffers=${SHARED_BUFFERS}
db_compatibility=${DB_COMPATIBILITY}
isinitdb=${IS_INITDB}
EOF2
  chown "${VB_USER}:${VB_GROUP}" "${RSP_FILE}"
  chmod 600 "${RSP_FILE}"
}

unpack_pkg() {
  local pkg
  pkg=$(find_package) || {
    err "未找到安装包：${PKG_FILE}"
    err "请把安装包放在以下任一位置："
    err "  1) ${PKG_DIR}/${PKG_FILE}"
    err "  2) $(pwd)/${PKG_FILE}"
    err "  3) $(cd "$(dirname "$0")" && pwd)/${PKG_FILE}"
    exit 1
  }

  log "解压安装包：${pkg}"
  rm -rf "${WORK_DIR:?}/"*
  tar -xf "${pkg}" -C "${WORK_DIR}"
  chown -R "${VB_USER}:${VB_GROUP}" "${WORK_DIR}"
}

detect_installer() {
  if [[ -n "${INSTALLER_CMD}" ]]; then
    echo "${INSTALLER_CMD}"
    return 0
  fi

  local candidates=(
    "${WORK_DIR}/vastbase-installer/vastbase_installer"
    "${WORK_DIR}/vastbase_installer"
    "${WORK_DIR}/installer/vastbase_installer"
    "${WORK_DIR}/script/vastbase_installer"
    "${WORK_DIR}/install/vastbase_installer"
  )

  local f
  for f in "${candidates[@]}"; do
    if [[ -x "${f}" ]]; then
      echo "${f}"
      return 0
    fi
  done

  f=$(find "${WORK_DIR}" -maxdepth 4 -type f \( -name "vastbase_installer" -o -name "install.sh" \) | head -n 1 || true)
  if [[ -n "${f}" ]]; then
    chmod +x "${f}" || true
    echo "${f}"
    return 0
  fi

  return 1
}

run_installer() {
  local installer installer_dir installer_name

  installer=$(detect_installer) || {
    err "未探测到安装器，请先手工查看 ${WORK_DIR} 下的实际安装入口。"
    exit 1
  }

  installer_dir=$(dirname "${installer}")
  installer_name=$(basename "${installer}")

  log "使用安装器：${installer}"
  log "安装器目录：${installer_dir}"
  log "安装器日志：${INSTALLER_LOG}"

  [[ -f "${RSP_FILE}" ]] || {
    err "应答文件不存在：${RSP_FILE}"
    exit 1
  }

  if [[ -d "${installer_dir}/locales" ]]; then
    log "检测到 locales 目录：${installer_dir}/locales"
  else
    warn "未检测到 locales 目录：${installer_dir}/locales"
    ls -l "${installer_dir}" || true
  fi

  # 注意：必须切到安装器目录执行，否则可能报 locales 目录不存在
  if [[ "${installer_name}" == "vastbase_installer" ]]; then
    su - "${VB_USER}" -c "cd '${installer_dir}' && ./'${installer_name}' --silent -responseFile '${RSP_FILE}'" \
      2>&1 | tee -a "${INSTALLER_LOG}"
  else
    su - "${VB_USER}" -c "cd '${installer_dir}' && ./'${installer_name}' --silent -responseFile '${RSP_FILE}'" \
      2>&1 | tee -a "${INSTALLER_LOG}"
  fi
}

post_install_check() {
  [[ -x "${VB_HOME}/bin/vsql" ]] || { err "安装未完成：${VB_HOME}/bin/vsql 不存在"; exit 1; }
  [[ -x "${VB_HOME}/bin/vb_ctl" ]] || { err "安装未完成：${VB_HOME}/bin/vb_ctl 不存在"; exit 1; }
}

# ------------------------------
# 安装后配置
# ------------------------------
post_install_tune() {
  local conf="${VB_DATA}/postgresql.conf"
  if [[ ! -f "${conf}" ]]; then
    warn "未找到 postgresql.conf，跳过安装后调优"
    return 0
  fi

  log "执行安装后参数调优..."

  if [[ "${LOW_MEM_MODE}" == "yes" ]]; then
    log "启用小内存模式参数..."
    set_conf "${conf}" "max_process_memory" "${MAX_PROCESS_MEMORY}"
    set_conf "${conf}" "shared_buffers" "${SHARED_BUFFERS}MB"
    set_conf "${conf}" "cstore_buffers" "${CSTORE_BUFFERS}"
    set_conf "${conf}" "max_connections" "${MAX_CONNECTIONS}"
    set_conf "${conf}" "max_prepared_transactions" "${MAX_PREPARED_TRANSACTIONS}"
    set_conf "${conf}" "wal_buffers" "${WAL_BUFFERS}"
    set_conf "${conf}" "max_locks_per_transaction" "${MAX_LOCKS_PER_TRANSACTION}"
    set_conf "${conf}" "max_pred_locks_per_transaction" "${MAX_PRED_LOCKS_PER_TRANSACTION}"
    set_conf "${conf}" "work_mem" "${WORK_MEM}"
    set_conf "${conf}" "maintenance_work_mem" "${MAINTENANCE_WORK_MEM}"
  fi

  if [[ "${OPEN_REMOTE_ACCESS}" == "yes" ]]; then
    set_conf "${conf}" "listen_addresses" "'*'"
  fi
}

post_config() {
  local hba="${VB_DATA}/pg_hba.conf"

  if [[ "${OPEN_REMOTE_ACCESS}" == "yes" && -f "${hba}" ]]; then
    log "放通远程 md5 接入..."
    grep -q "host all all 0.0.0.0/0 md5" "${hba}" 2>/dev/null || echo "host all all 0.0.0.0/0 md5" >> "${hba}"
    grep -q "host all all ::/0 md5" "${hba}" 2>/dev/null || echo "host all all ::/0 md5" >> "${hba}"
    chown "${VB_USER}:${VB_GROUP}" "${hba}"
  fi
}

start_and_verify() {
  log "启动数据库并验证..."
  su - "${VB_USER}" -c "
    source ~/.bashrc
    vb_ctl start
    sleep 5
    vb_ctl status
    vsql -d postgres -p ${PORT} -c 'select version();'
  "
}

print_summary() {
  log "安装流程执行完毕。"
  log "主日志：${LOG_FILE}"
  log "安装器日志：${INSTALLER_LOG}"
  log "常用命令："
  echo "  su - ${VB_USER}"
  echo "  source ~/.bashrc"
  echo "  vb_ctl start"
  echo "  vb_ctl stop"
  echo "  vb_ctl restart"
  echo "  vb_ctl status"
  echo "  vsql -d postgres -p ${PORT}"
}

main() {
  init_logging

  run_step "检查 root" require_root
  run_step "安装依赖" install_deps
  run_step "创建用户和目录" create_user_and_dirs
  run_step "配置 limits" set_limits
  run_step "配置 sysctl" set_sysctl
  run_step "关闭防火墙和 SELinux" disable_firewall_selinux
  run_step "关闭 THP" disable_thp
  run_step "配置 RemoveIPC" set_removeipc
  run_step "配置环境变量" set_profile
  run_step "解压安装包" unpack_pkg
  run_step "生成应答文件" write_rsp
  run_step "执行安装器" run_installer
  run_step "安装后检查" post_install_check
  run_step "安装后调优" post_install_tune
  run_step "放通远程访问" post_config
  run_step "启动并验证" start_and_verify

  print_summary
}

main "$@"