本文提供瀚高数据库V4.1.1的标准化安装流程，包括安装前的系统准备、安装步骤及数据库配置等关键信息。
详细介绍瀚高数据库V4.1.1的标准化安装流程。
1. 数据库安装路径
安装目录： /home/hgdb4.1.1/
data目录： /data/highgo/4.1.1/data
归档目录： /hgarch
2. 检查swap空间
grep MemTotal /proc/meminfo
grep SwapTotal /proc/meminfo
3. 关闭防火墙
service iptables stop
chkconfig iptables off
4. 关闭NetworkManager和selinux
service NetworkManager stop
chkconfig NetworkManager off
sed -i "s/SELINUX=enforcing/SELINUX=disabled/g" /etc/selinux/config
cat /etc/selinux/config
setenforce 0
5. 检查主机名、时间、时区
cat /etc/sysconfig/network
cat /etc/hosts
cat /etc/sysconfig/clock
date
6. 安装系统软件包
vi /etc/yum.repos.d/highgo.repo
[Server]
name=Red Hat Enterprise Linux $releasever Beta - $basearch - Source
baseurl=file:///mnt
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release
挂载操作系统镜像
mount /dev/sr0 /mnt
yum install wget readline readline-static readline-devel zlib zlib-devel zlib-static openssl openssl-devel pam-devel libxml2-devel libxslt-devel python-devel tcl-devel gcc gcc-c++ -y
7. 创建操作系统用户
8. 创建数据库安装目录
mkdir -p /home/hgdb4.1.1/
mkdir -p /data/highgo/4.1.1/data
mkdir /hgarch
chown -R highgo:highgo /home/hgdb4.1.1
chown -R highgo:highgo /data
chown -R highgo:highgo /hgarch
9. 配置操作系统内核参数
vi /etc/sysctl.conf
#for highgo db 4.1.1
kernel.shmmni = 4096
kernel.sem = 4096 2147483647 2147483646 512000
fs.file-max = 7672460
net.ipv4.ip_local_port_range = 9000 65000
net.core.rmem_default = 1048576
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.tcp_tw_recycle = 1
net.ipv4.tcp_max_syn_backlog = 4096
net.core.netdev_max_backlog = 10000
vm.overcommit_memory = 0
fs.aio-max-nr = 1048576
net.ipv4.tcp_timestamps = 0
root用户运行如下命令是参数立即生效。
sysctl -p
10. 配置操作系统limits
vi /etc/security/limits.conf
#for highgo db 4.1.1
highgo soft core unlimited
highgo hard nproc unlimited
highgo soft nproc unlimited
highgo hard memlock unlimited
highgo hard nofile 1024000
highgo soft memlock unlimited
highgo soft nofile 1024000
11. 设置highgo用户环境变量
vi /home/highgo/.bash_profile
export #本地化设置
export PGHOME=/home/hgdb4.1.1/ #软件安装目录
export PGUSER=highgo #连接数据库的用户（可选）
export PGPORT=5866 #连接端口
export PGDATA=/data/highgo/4.1.1/data #数据目录
export PATH=$PGHOME/bin:$PATH:$HOME/bin #执行文件目录
export LD_LIBRARY_PATH=$PGHOME/lib:$LD_LIBRARY_PATH #lib库路径
使环境变量生效
source /home/highgo/.bash_profile
12. 上传到/tmp目录并解压HGDB安装包
cd /tmp
tar -zxvf hgdb4.1.1_installer_redhat6.x_Standard_64.tar.gz
cd /tmp/hgdb4.1.1_installer_redhat6.x_Standard_64
chmod +x runinstall
切换到highgo用户下并切换到数据库解压路径
su - highgo
cd /tmp/hgdb4.1.1_installer_redhat6.x_Standard_64
./runinstall
Welcome to the installation of HighGo Database 4.1.1 Enterprise Edition !
press 1 to continue(继续), 2 to quit(退出), 3 to redisplay(重新显示)
1 ##选择1，enter
显示服务条款
press 1 to accept(接受), 2 to reject(拒绝), 3 to redisplay(重新显示)
1 ##选择1，enter
Select target path [/data/highgo/4.1.1]
##设置安装路径，enter
press 1 to continue(继续), 2 to quit(退出), 3 to redisplay(重新显示)
1 ##选择1，enter
TreePacksPanel
[JDK_JRE] [required]
[DataBase Server] [Y/n] ##选择安装组件，enter
[User interfaces] [Y/n] ##选择安装组件，enter
psql [Y/n] ##选择安装组件，enter
hgdbAdmin [Y/n] ##选择安装组件，enter
[Development] [Y/n] ##选择安装组件，enter
[install database] [required]
init and configure database [required]
uninstalldata [required]
[tempExecutableFiles] [required]
...pack selection done.
press 1 to continue(继续), 2 to quit(退出), 3 to redisplay(重新显示)
1 ##选择1，enter
To check the dependent packs. ##检查依赖包。
press 1 to check(检查), 2 to skip(跳过), 3 to exit(退出)
1 ##选择1，enter
Checks Status Fixable
net.netfilter.nf_conntrack_max Failed Yes
net.nf_conntrack_max Failed Yes
Use the root user to execute the following script to modify the system parameters.
/tmp/hgdb_3790188031/kernelParameterSets.sh ##修复脚本
press 1 to ignore(忽略), 2 to reject(拒绝), 3 to recheck(重新检查)
1 ##选择1，enter
Data directory [/data/highgo/4.1.1/data]
##设置data目录，enter
Port number [5866]
##设置端口号，enter
##设置数据库超级用户，默认highgo，enter
Password []
##设置用户密码，enter
Password(again) []
##再次输入用户密码，enter
[x] Whether to start automatically. ##是否设置自动启动
input 1 to select, 0 to deselect:
1 ##选择1，enter
datatype
0 [x] OLTP
1 [ ] OLAP
2 [ ] HTAP
3 [ ] Web
4 [ ] Desktop
input selection:
##设置数据库类型，enter
Total Memory (GB) [2]
##设置操作系统总内存大小，enter
connectionNumber [300]
##设置数据库最大连接数，enter
Locale
0 [ ] C
1 [ ] POSIX
2 [ ] aa_DJ
3 [ ] aa_DJ.iso88591
4 [ ] aa_DJ.utf8
5 [ ] aa_ER
6 [ ] aa_ER.utf8
7 [ ] aa_ER.utf8@saaho
8 [ ] aa_ER@saaho
9 [ ] aa_ET
----------------
770 [ ] zh_CN
771 [ ] zh_CN.gb18030
772 [ ] zh_CN.gb2312
773 [ ] zh_CN.gbk
774 [x] zh_CN.utf8
775 [ ] zh_HK
776 [ ] zh_HK.big5hkscs
777 [ ] zh_HK.utf8
778 [ ] zh_SG
779 [ ] zh_SG.gb2312
780 [ ] zh_SG.gbk
781 [ ] zh_SG.utf8
782 [ ] zh_TW
783 [ ] zh_TW.big5
784 [ ] zh_TW.euctw
785 [ ] zh_TW.utf8
786 [ ] zu_ZA
787 [ ] zu_ZA.iso88591
788 [ ] zu_ZA.utf8
input selection:
0 ##设置Locale，选择C，输入0，enter
Encoding
0 [ ] EUC_JP
1 [ ] EUC_KR
2 [ ] ISO_8859_5
3 [ ] ISO_8859_6
4 [ ] ISO_8859_7
5 [ ] ISO_8859_8
6 [ ] JOHAB
7 [ ] KOI8-R
8 [ ] LATIN1
9 [ ] LATIN2
10 [ ] LATIN3
11 [ ] LATIN4
12 [ ] LATIN5
13 [ ] LATIN9
14 [ ] MULE_INTERNAL
15 [ ] SQL_ASCII
16 [ ] WIN866
17 [ ] WIN874
18 [ ] WIN1250
19 [ ] WIN1251
20 [ ] WIN1252
21 [ ] WIN1256
22 [ ] WIN1258
23 [x] UTF8
input selection:
##设置Encoding，默认UTF8，enter
[ ] Whether encrypted storage. ##是否加密存储
input 1 to select, 0 to deselect:
0 ##选择0（不加密），enter
press 1 to continue(继续), 2 to quit(退出), 3 to redisplay(重新显示)
1 ##选择1，enter
Installation path: /data/highgo/4.1.1.
Data directory: /data/highgo/4.1.1/data.
Database port: 5866.
Database Locale: C.
Server Encoding: UTF8.
Super User: highgo.
Database Type: oltp
Total Memory: 2
Connections: 300
press 1 to continue(继续), 2 to quit(退出), 3 to redisplay(重新显示)
1 ##选择1，enter
[ Starting to unpack ]
[ Processing package: Jre (1/8) ]
[ Processing package: Database Server (2/8) ]
[ Processing package: User interfaces (3/8) ]
[ Processing package: psql (4/8) ]
[ Processing package: hgdbAdmin (5/8) ]
[ Processing package: Development (6/8) ]
[ Processing package: Install database (7/8) ]
[ Processing package: Initial the database (8/8) ]
To finish the database install, please follow the below steps:
1. execute following script with root user
/data/highgo/4.1.1/hginstall.sh
2. Press enter to continue, after hginstall.sh execute successfully .
[Press enter to continue!]
##root用户执行hginstall.sh脚本，执行完成后enter
[root@hgdb ~]# /data/highgo/4.1.1/hginstall.sh
Starting HighGo Database Server:
waiting for server to start.... done
server started
HighGo Database Server started successfully
[ Unpacking finished ]
Begin create shorcut:
[x]Create additional shortcuts on the desktop ##桌面创建快捷方式
input 1 to select, 0 to deselect:
1 ##选择1，enter
[x]Create shortcuts in the StartMenu ##在开始菜单中创建快捷方式
input 1 to select, 0 to deselect:
1 ##选择1，enter
Select which user the program will create shortcut for: ##哪个用户创建快捷方式
0 [ ] current user ##当前用户
1 [x] all users ##所有用户
input selection:
##enter
Name of programgroup [HighgoDB V4.1.1] ##程序组名
##enter
press 1 to continue(继续), 2 to quit(退出), 3 to redisplay(重新显示)
1 ##选择1，enter
Install was successful
application installed on /data/highgo/4.1.1
[ Console installation done ]
13. 修改数据库参数
alter system set listen_addresses = '*'; #允许所有连接
alter system set max_connections = 1000; #数据库最大连接数
alter system set shared_buffers = '16384MB'; #内存大小的25%
alter system set checkpoint_completion_target = 0.8;
alter system set log_destination = 'csvlog'; #记录日志模式
alter system set logging_collector = on; #开启日志记录
alter system set log_directory = 'hgdb_log'; #日志存放路径
alter system set log_filename = 'highgodb-%a.log'; #日志命名格式
alter system set log_rotation_age = '1d';
alter system set log_rotation_size = 0;
alter system set log_truncate_on_rotation = on;
alter system set log_hostname = on;
alter system set log_line_prefix = '%m';
alter system set log_statement = 'ddl';
alter system set wal_level = archive;
alter system set archive_mode = on; #开启归档
alter system set archive_directory = '/hgarch'; #归档路径
创建数据库实例以及用户
create database gwjhdb;
create user swgwjh superuser password 'swgwjh';
14. 修改网络访问控制
su - highgo
cd $PGDATA
vi pg_hba.conf
修改如下所示标红的部分：
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 0.0.0.0/0 md5
（允许所有IP地址使用密码连接数据库）
# IPv6 local connections:
host all all ::1/128 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local replication highgo md5
#host replication highgo 127.0.0.1/32 md5
#host replication highgo ::1/128 md5
15. 卸载数据库
关闭数据库
[highgo@hgdb ~]$ pg_ctl -m fast stop
waiting for server to shut down.... done
server stopped
以root用户执行uninstall卸载数据库和软件
[root@hgdb ~]# cd /home/hgdb4.1.1/
[root@hgdb 4.1.1]# ./uninstall
Command line uninstaller.
Force the deletion of /data/highgo/4.1.1/data [y/n] y
To finish the database uninstall, please follow the below steps:
1. execute following script with root user
/data/highgo/4.1.1/hguninstall.sh
2. Press enter to continue, after hguninstall.sh execute successfully .
[Press enter to continue!]
执行脚本hguninstall.sh后按回车继续
[root@hgdb data]# /home/hgdb4.1.1/hguninstall.sh
Execute Success !
如果执行./uninstall后选择n，会删除HGDB软件，保留data目录
[root@hgdb ~]# cd /home/hgdb4.1.1/
[root@hgdb 4.1.1]# ./uninstall
Command line uninstaller.
Force the deletion of /data/highgo/4.1.1/data [y/n] n
To finish the database uninstall, please follow the below steps:
1. execute following script with root user
/home/hgdb4.1.1/hguninstall.sh
2. Press enter to continue, after hguninstall.sh execute successfully .
[Press enter to continue!]
执行脚本hguninstall.sh后按回车继续
[root@hgdb ~]# /home/hgdb4.1.1/hguninstall.sh
Execute Success !
扫一扫
1212
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
