1.安装依赖环境 yum install -y gcc gcc-c++ cmake ncurses-devel perl zlib* yum -y install -y readline-devel readline 2.创建运行用户、程序目录 useradd pgsql usermod -G pgsql pgsql mkdir -p /data/server_home/pg13/ chown -R pgsql.pgsql /data/server_home/pg13 #修改安装目录权限 chown -R pgsql.pgsql postgresql-13.1 3.安装 su - pgsql，切换用户， ./configure --prefix=/data/server_home/pg13 make make install 4.初始化数据库 su - pgsql vim /home/pgsql/.bash_profile export PGHOME=/data/server_home/pg13 export PGDATA=/data/server_home/pg13/data export PATH=$PGHOME/bin:$PATH export MANPATH=$PGHOME/share/man:$MANPATH export LANG=en_US.utf8 export DATE=`date +"%Y-%m-%d %H:%M:%S"` export LD_LIBRARY_PATH=$PGHOME/lib:$LD_LIBRARY_PATH source /home/pgsql/.bash_profile initdb -D /data/server_home/pg13/data/ mkdir /data/server_home/pg13/logs/ touch /data/server_home/pg13/logs/server.log 5.启动数据库 修改配置文件 参数优化 vim /etc/security/limits.conf pgsql soft nofile 1024000 pgsql hard nofile 1024000 pgsql soft nproc unlimited pgsql hard nproc unlimited pgsql soft core unlimited pgsql hard core unlimited pgsql soft memlock unlimited pgsql hard memlock unlimited vim /data/server_home/pg13/data/pg_hba.conf 修改开启密码验证 local all all password # IPv4 local connections: host all all 127.0.0.1/32 password # IPv6 local connections: host all all ::1/128 password 启动服务 su - pgsql pg_ctl -D /data/server_home/pg13/data/ -l /data/server_home/pg13/logs/server.log start pg_ctl -D /data/server_home/pg13/data/ -l /data/server_home/pg13/logs/server.log stop 6.创建用户、密码 psql postgres Alter USER pgsql WITH PASSWORD 'xxxxxx'; #添加密码 CREATE DATABASE fs_core; #创建数据库 CREATE user 用户 password 'xxxxx'; #创建用户 GRANT ALL PRIVILEGES ON DATABASE fs_core TO xxxx; #授权 7.测试链接 psql -U fs_core -d xxx -h 127.0.0.1 -p 5432
瑞思拜！！！
