龙芯3A5000麒麟V10部署Java和postgresql15.4

一、安装前准备

step 1: 安装介质下载：

社区下载地址：
http://www.loongnix.cn/zh/api/java/
https://www.postgresql.org/ftp/source/

云盘下载地址：
链接: https://pan.baidu.com/s/1h1ytR5hLQ6XWlh08iCnnTA?pwd=1018 提取码: 1018
链接: https://pan.baidu.com/s/19l7T9AioDKBWeZH8TiKfUQ?pwd=1019 提取码: 1019

二、安装java

step 2：切换root用户

sudo -i 

输入当前用户密码

step 3：上传安装介质

创建文件目录，安装介质拷贝到服务器

mkdir /opt/software
mv /home/user/桌面/loongson8.1.16-fx-jdk8u382b05-linux-loongarch64.tar.gz /opt/software/
mv /home/user/桌面/postgresql-15.4.tar.gz /opt/software/

step 4：创建程序目录

mkdir /usr/local/java

step 5：解压文件程序目录

tar -zxvf loongson8.1.16-fx-jdk8u382b05-linux-loongarch64.tar.gz -C /usr/local/java

step 5：编辑环境变量

cat >> /etc/profile << “EOF”
export JAVA_HOME=/usr/local/java/jdk8u382-b05
export JRE_HOME=${JAVA_HOME}/jre 
export CLASSPATH=${JAVA_HOME}/lib:${JRE_HOME}/lib:$CLASSPATH
export JAVA_PATH=${JAVA_HOME}/bin:${JRE_HOME}/bin
export PATH=$PATH:${JAVA_PATH}
export PGDATA=/opt/postgresql/data
export PATH=$PATH:$HOME/bin:/opt/postgresql/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/postgresql/lib
export PGDATABASE=postgres
export PGPORT=5432
EOF

加载环境变量

source /etc/profile

step 6：验证程序是否安装成功

java -version

二、安装postgresql15.4

step 7：创建用户和目录

mkdir -p /opt/postgresql/data
groupadd pgsql
useradd -g pgsql -G pgsql -d /opt/postgresql pgsql
chown -R pgsql:pgsql /opt/postgresql
passwd pgsql #修改密码

step 8：创建用户和目录

mkdir -p /opt/postgresql/data
groupadd pgsql
useradd -g pgsql -G pgsql -d /opt/postgresql pgsql
chown -R pgsql:pgsql /opt/postgresql
passwd pgsql #修改密码

step 9：解压文件到指定目录

cd /opt/software
tar -zxvf postgresql-15.4.tar.gz -C /opt/postgresql/

step 10：编译安装

cd postgresql-15.4
./configure --prefix=/opt/postgresql --disable-spinlocks --without-readline --without-zlib
make && make install

step 11：初始化数据库

su - pgsql
/opt/postgresql/bin/initdb -D /opt/postgresql/data/

step 12：修改数据库配置

sed -i -e"s/^#listen_addresses =.*$/listen_addresses = '*'/" $DATADIR/postgresql.conf

sed -i -e"s/^max_connections = 100.*$/max_connections = 1000/" $DATADIR/postgresql.conf

sed -i -e"s/^shared_buffers =.*$/shared_buffers = 2GB/" $DATADIR/postgresql.conf

sed -i -e"s/^#effective_cache_size = 128MB.*$/effective_cache_size = 4GB/" $DATADIR/postgresql.conf

sed -i -e"s/^#work_mem = 1MB.*$/work_mem = 128MB/" $DATADIR/postgresql.conf

echo "host all all 0.0.0.0/0 md5" >> $DATADIR/pg_hba.conf

step 13：添加系统systemd服务启动

cat >> /etc/systemd/system/postgresql.service <<EOF

[Unit]

Description=PostgreSQL database server

After=network.target

[Service]

Type=forking

User=pgsql

Group=pgsql

#Environment=PGDATA=/opt/postgresql/data

#OOMScoreAdjust=-1000

ExecStart=/opt/postgresql/bin/pg_ctl -D /opt/postgresql/data -l /opt/postgresql/logfile start

ExecStop=/opt/postgresql/bin/pg_ctl stop -D /opt/postgresql/data

ExecReload=/opt/postgresql/bin/pg_ctl reload -D /opt/postgresql/data

TimeoutSec=300

[Install]

WantedBy=multi-user.target

EOF

step 14：启动数据库，添加开机启动

systemctl daemon-reload

systemctl start postgresql.service

systemctl enable postgresql.service

EOF