function pg17() {
export PGHOME=/usr/pgsql-17
export PGDATA=/postgresql/data/pg17
export PGPORT=5433
export PATH=$PGHOME/bin:$PATH
export LD_LIBRARY_PATH=$PGHOME/lib:$LD_LIBRARY_PATH
echo “========================================”
echo “PostgreSQL 17 Environment Activated”
echo “========================================”
echo “PGHOME: $PGHOME”
echo “PGDATA: $PGDATA”
echo “PGPORT: $PGPORT”
echo “Version: $(psql –version 2>/dev/null || echo ‘Not installed’)”
echo “========================================”
}

function pg18() {
export PGHOME=/postgresql/fgapp
export PGDATA=/postgresql/data/pg18
export PGPORT=5434
export PATH=$PGHOME/bin:$PATH
export LD_LIBRARY_PATH=$PGHOME/lib:$LD_LIBRARY_PATH
echo “========================================”
echo “PostgreSQL 18 Environment Activated”
echo “========================================”
echo “PGHOME: $PGHOME”
echo “PGDATA: $PGDATA”
echo “PGPORT: $PGPORT”
echo “Version: $(psql –version 2>/dev/null || echo ‘Not installed’)”
echo “========================================”
}

# 显示当前环境
function pg_env() {
echo “========================================”
echo “Current PostgreSQL Environment”
echo “========================================”
echo “PGHOME: ${PGHOME:-Not set}”
echo “PGDATA: ${PGDATA:-Not set}”
echo “PGPORT: ${PGPORT:-Not set}”
echo “PGHOST: ${PGHOST:-Not set}”
echo “PGDATABASE: ${PGDATABASE:-Not set}”
echo “PGUSER: ${PGUSER:-Not set}”
echo “PGCLIENTENCODING:${PGCLIENTENCODING:-Not set}”
echo “PGTZ: ${PGTZ:-Not set}”
echo “”
echo “psql location: $(which psql 2>/dev/null || echo ‘Not found’)”
echo “psql version: $(psql –version 2>/dev/null || echo ‘Not found’)”
echo “========================================”
}

# 显示帮助
function pg_help() {
echo “PostgreSQL Environment Management”
echo “”
echo “Usage:”
echo ” pg16 – Switch to PostgreSQL 16 environment”
echo ” pg17 – Switch to PostgreSQL 17 environment”
echo ” pg18 – Switch to PostgreSQL 18 environment”
echo ” pg_env – Show current environment settings”
echo ” pg_help – Show this help message”
}

# 默认加载PG18环境
pg18 >/dev/null 2>&1
EOF

# 设置权限
$ sudo chmod 644 /etc/profile.d/pg_env.sh

# 使配置生效
$ source /etc/profile.d/pg_env.sh

# 检查LD_LIBRARY_PATH
echo “3. Checking LD_LIBRARY_PATH…”
if [ -z “$LD_LIBRARY_PATH” ]; then
echo ” [WARN] LD_LIBRARY_PATH is not set”
else
echo ” [OK] LD_LIBRARY_PATH = $LD_LIBRARY_PATH”
fi
echo “”

# 检查数据目录
echo “4. Checking PGDATA…”
if [ -d “$PGDATA” ]; then
echo ” [OK] PGDATA directory exists”
if [ -f “$PGDATA/PG_VERSION” ]; then
PG_VERSION=$(cat $PGDATA/PG_VERSION)
echo ” [OK] Database version: $PG_VERSION”
else
echo ” [WARN] PG_VERSION file not found”
fi
else
echo ” [ERROR] PGDATA directory does not exist”
fi
echo “”

# 检查连接
echo “5. Checking fgedudb connection…”
if psql -c “SELECT 1″ >/dev/null 2>&1; then
echo ” [OK] Database connection successful”
else
echo ” [ERROR] Database connection failed”
fi
echo “”

# 检查.pgpass文件
echo “6. Checking .pgpass file…”
PGPASS_FILE=”$HOME/.pgpass”
if [ -f “$PGPASS_FILE” ]; then
PGPASS_PERM=$(stat -c %a “$PGPASS_FILE” 2>/dev/null)
if [ “$PGPASS_PERM” = “600” ]; then
echo ” [OK] .pgpass exists with correct permissions (600)”
else
echo ” [WARN] .pgpass exists but permissions are $PGPASS_PERM (should be 600)”
fi
else
echo ” [INFO] .pgpass file not found”
fi
echo “”

echo “==========================================”
echo “Environment check completed”
echo “==========================================”
EOF

# 设置执行权限
$ chmod +x /postgresql/scripts/pg_env_check.sh

# 执行检查
$ /postgresql/scripts/pg_env_check.sh

$ echo “PGDATA: $PGDATA”
PGDATA: /postgresql/data

$ echo “PGPORT: $PGPORT”
PGPORT: 5432

# 验证可执行文件路径
$ which psql
/postgresql/fgapp/pgsql-18/bin/psql

$ which pg_dump
/postgresql/fgapp/pgsql-18/bin/pg_dump

$ which pg_restore
/postgresql/fgapp/pgsql-18/bin/pg_restore

# 验证版本
$ psql –version
psql (PostgreSQL) 18.3

$ pg_dump –version
pg_dump (PostgreSQL) 18.3

$ pgsql –version
pgsql (PostgreSQL) 18.3

# 验证动态库
$ ldd $PGHOME/bin/psql | grep pgsql libpq.so.5 => /postgresql/fgapp/pgsql-18/lib/libpq.so.5

# 验证连接
$ psql -c “SELECT version();”
version
———————————————————————————————————
PostgreSQL 18.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.4.1 20230605 (Red Hat 11.4.1-2), 64-bit
(1 行记录)

# 验证默认数据库
$ psql -c “SELECT current_fgedudb();”
current_fgedudb
——————
fgedudb
(1 行记录)