alias useproxy="
 export http_proxy=http://10.0.2.2:2080;
 export https_proxy=http://10.0.2.2:2080;
 export all_proxy=http://10.0.2.2:2080;
"

alias unproxy="
 unset http_proxy;
 unset https_proxy;
 unset all_proxy;
"

## 移除多于内核
echo "-- BEFORE --";rpm -qa | grep ^kernel;  rpm -qa  |grep ^kernel  |grep -E -v `uname -r`  |xargs  rpm  -e  --nodeps;  echo "--- AFTER ---";  rpm -qa | grep ^kernel

rpm -qa|grep kernel
 

dnf install epel-release nano  net-tools htop -y


dnf install langpacks-en glibc-all-langpacks -y

dnf install langpacks-en glibc-all-langpacks  -y

localectl list-locales | grep zh
localectl set-locale LANG="zh_CN.utf8"
localectl status


dnf groupinstall 'Development Tools'  -y

dnf install  cmake -y 

# 搜索文件Pkg
yum provides "*/pg_config"

curl --proto '=https' --tlsv1.2 -sSf https://sh.rustup.rs | sh

cargo install fd-find
cargo install ripgrep
cargo install lsd

nano /etc/selinux/config

dnf config-manager --add-repo https://download.docker.com/linux/centos/docker-ce.repo
dnf install docker-ce docker-ce-cli containerd.io

systemctl enable --now docker
 
systemctl status docker

mkdir -p /opt/docker/mariadb

docker run --name mariadb  --restart=always  -e MYSQL_ROOT_PASSWORD=root  -v /opt/docker/mariadb:/var/lib/mysql  -p 3306:3306  -d mariadb:10.11.2

mkdir -p /opt/docker/redis

docker run -itd --name redis --restart=always -v /opt/docker/redis:/data -p 6379:6379 redis:7.0.10
docker ps

mkdir -p /opt/docker/postgresql
docker run --name postgres  --restart=always  -e POSTGRES_USER=postgres -e POSTGRES_PASSWORD=postgres -v /opt/docker/postgresql:/var/lib/postgresql/data  -p 5432:5432    -d  postgres:15.2
docker ps

docker exec -it postgres bash
# 启动失败时 查看日志
docker inspect --format '{{.LogPath}}' 6343f20e07f9
cat /var/lib/docker/containers/6343f20e07f905de0c53008e11659c82127447f07acc79923574fc72ea4cda29/6343f20e07f905de0c53008e11659c82127447f07acc79923574fc72ea4cda29-json.log

docker exec -it postgres bash
docker stop  6343f20e07f9
docker rm 6343f20e07f9

 

mariadb-secure-installation

mysql -u root -p

firewall-cmd --permanent --add-service=mysql
firewall-cmd --reload

dnf install redis -y
systemctl enable --now redis.service
systemctl status redis.service

firewall-cmd --zone=public --add-port=6379/tcp --permanent
firewall-cmd --reload

dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm
dnf -qy module disable postgresql

dnf install postgresql14-contrib  postgresql14-devel postgresql14-server
/usr/pgsql-14/bin/postgresql-14-setup initdb

systemctl enable --now postgresql-14
systemctl status postgresql-14


sudo -u postgres psql -c "SELECT version();"


firewall-cmd --zone=public --add-port=5432/tcp --permanent 
firewall-cmd  --reload

sed -i '/^local/s/peer/trust/'  /var/lib/pgsql/14/data/pg_hba.conf 
sed -i '/^host/s/ident/md5/' /var/lib/pgsql/14/data/pg_hba.conf 

pg_hba.conf 追加
host    all             all             0.0.0.0/0               trust

cat  /var/lib/pgsql/14/data/postgresql.conf | grep listen_addresses
nano /var/lib/pgsql/14/data/postgresql.conf 修改 listen_addresses=*

cd ~
mkdir workspaces  
cd workspaces/
git clone https://github.com/jaiminpan/pg_jieba
cd pg_jieba/
 
git submodule update --init --recursive

mkdir build 
cd build

export PATH=/usr/pgsql-14/bin:$PATH

cmake ..

# 定位 include文件位置
fd postgres.h /

cmake -DPostgreSQL_INCLUDE_DIR=/usr/pgsql-14/include/server/   -DPostgreSQL_LIBRARY=/usr/pgsql-14/lib/    ..
cmake -DPostgreSQL_TYPE_INCLUDE_DIR=/usr/pgsql-14/include/server/ ..

make 
make install

systemctl restart postgresql-14

sudo -u postgres psql -c "create extension pg_jieba;"