# 切换到yashan用户
su – yashan
# 上传安装包并解压
unzip yashandb-23.4.zip
cd yashandb-23.4
# 创建响应文件
cat > responsefile.rsp << EOF INSTALL_TYPE=Typical INSTALL_DIR=/yashandb/app DATA_DIR=/yashandb/fgdata PORT=5432 ENCODING=UTF8 MEMORY_PERCENT=50 EOF # 执行静默安装 ./yashan_installer.run -silent -responsefile responsefile.rsp

输出日志：

# 执行静默安装输出
[yashan@fgedu.net.cn yashan-23.4]$ ./yashan_installer.run -silent -responsefile responsefile.rsp
Starting YashanDB Installer…
Preparing installation…
Installing YashanDB…
10%…20%…30%…40%…50%…60%…70%…80%…90%…100%
Installation completed successfully.
YashanDB has been installed to /yashandb/app.
Please run ‘yasboot create’ to create a database instance.

# 典型安装配置文件
INSTALL_TYPE=Typical
INSTALL_DIR=/yashandb/app
DATA_DIR=/yashandb/fgdata
PORT=5432
ENCODING=UTF8
MEMORY_PERCENT=50

# 自定义安装配置文件
INSTALL_TYPE=Custom
INSTALL_DIR=/yashandb/app
DATA_DIR=/yashandb/fgdata
LOG_DIR=/yashandb/log
BACKUP_DIR=/yashandb/backup
PORT=5432
ENCODING=UTF8
MEMORY_PERCENT=60
MAX_CONNECTIONS=1000

#!/bin/bash
# yashan_install.sh
# from:www.itpux.com.qq113257174.wx:itpux-com
# web: `http://www.fgedu.net.cn`

# 检查系统环境
echo “Checking system environment…”
cat /etc/redhat-release
nproc
free -h
df -h

# 创建用户和组
echo “Creating user and group…”
groupadd yashan
useradd -g yashan yashan
echo “yashan:yashan123” | chpasswd

# 创建目录
echo “Creating directories…”
mkdir -p /yashandb/app
mkdir -p /yashandb/fgdata
mkdir -p /yashandb/log
mkdir -p /yashandb/backup
chown -R yashan:yashan /yashandb

# 上传并解压安装包
echo “Uploading and extracting installation package…”
# 假设安装包已经上传到/tmp目录
cp /tmp/yashandb-23.4.zip /home/yashan/
su – yashan -c “unzip /home/yashan/yashandb-23.4.zip”

# 创建响应文件
echo “Creating response file…”
su – yashan -c “cat > /home/yashan/yashandb-23.4/responsefile.rsp << EOF INSTALL_TYPE=Typical INSTALL_DIR=/yashandb/app DATA_DIR=/yashandb/fgdata PORT=5432 ENCODING=UTF8 MEMORY_PERCENT=50 EOF" # 执行静默安装 echo "Executing silent installation..." su - yashan -c "cd /home/yashan/yashandb-23.4 && ./yashan_installer.run -silent -responsefile responsefile.rsp" # 创建实例 echo "Creating database instance..." su - yashan -c "yasboot create -d /yashandb/fgdata -n fgedudb" # 启动数据库 echo "Starting database..." su - yashan -c "yasboot start -n fgedudb" # 验证安装 echo "Verifying installation..." su - yashan -c "yassql -U sys -P sys -d fgedudb -c 'SELECT version();'" echo "Installation completed successfully!"

# 切换到yashan用户
su – yashan

# 配置环境变量
echo “export YASHAN_HOME=/yashandb/app” >> ~/.bashrc
echo “export PATH=$YASHAN_HOME/bin:$PATH” >> ~/.bashrc
source ~/.bashrc

# 创建数据库实例
yasboot create -d /yashandb/fgdata -n fgedudb

# 配置实例参数
vi /yashandb/fgdata/fgedudb/postgresql.conf
# 修改以下参数
shared_buffers = 8GB
work_mem = 32MB
maintenance_work_mem = 1GB
effective_cache_size = 24GB

# 启动数据库
yasboot start -n fgedudb

# 连接测试
yassql -U sys -P sys -d fgedudb

# 初始化数据库
CREATE USER fgedu IDENTIFIED BY ‘fgedu123’;
GRANT ALL PRIVILEGES ON DATABASE fgedudb TO fgedu;
CREATE TABLE fgedu_test (id serial primary key, name varchar(100), value int);
INSERT INTO fgedu_test (name, value) VALUES (‘test1’, 100), (‘test2’, 200);
SELECT * FROM fgedu_test;

# 配置远程访问
vi /yashandb/fgdata/fgedudb/pg_hba.conf
# 添加以下行
host all all 0.0.0.0/0 md5

# 重启数据库
yasboot restart -n fgedudb

输出日志：

# 创建实例输出
[yashan@fgedu.net.cn ~]$ yasboot create -d /yashandb/fgdata -n fgedudb
Creating YashanDB instance fgedudb…
YashanDB instance fgedudb created successfully.

# 启动数据库输出
[yashan@fgedu.net.cn ~]$ yasboot start -n fgedudb
Starting YashanDB instance fgedudb…
YashanDB instance fgedudb started successfully.

# 连接测试和初始化输出
[yashan@fgedu.net.cn ~]$ yassql -U sys -P sys -d fgedudb
YashanDB SQL Client V23.4.0
Connected to: YashanDB Server V23.4.0 at 127.0.0.1:5432
Type “help” for help.
fgedudb=> CREATE USER fgedu IDENTIFIED BY ‘fgedu123’;
CREATE USER
fgedudb=> GRANT ALL PRIVILEGES ON DATABASE fgedudb TO fgedu;
GRANT
fgedudb=> CREATE TABLE fgedu_test (id serial primary key, name varchar(100), value int);
CREATE TABLE
fgedudb=> INSERT INTO fgedu_test (name, value) VALUES (‘test1’, 100), (‘test2’, 200);
INSERT 0 2
fgedudb=> SELECT * FROM fgedu_test;
id | name | value
—-+——-+——-
1 | test1 | 100
2 | test2 | 200
(2 rows)
fgedudb=> \q

# 重启数据库输出
[yashan@fgedu.net.cn ~]$ yasboot restart -n fgedudb
Stopping YashanDB instance fgedudb…
YashanDB instance fgedudb stopped successfully.
Starting YashanDB instance fgedudb…
YashanDB instance fgedudb started successfully.