linux 离线包安装 pg 数据库（亲测有效）

#创建用户
useradd postgres
#设置密码
passwd postgres

1 解压
tar -xvf postgresql-14.5.tar.gz -C /usr/local/

##2.yum依赖
yum install -y gcc gcc-c++
yum install -y readline-devel
yum install -y zlib-devel

##3.编绎，并安装到/opt/postgresql目录
mkdir /opt/postgresql
cd /opt/postgresql-14.5
./configure --prefix=/opt/postgresql
make
make install

#4.准备数据目录
mkdir -p /usr/local/pg/pgsqldata
chown -R postgres:postgres /usr/local/pg/pgsqldata

#5.切换到postgres用户
su postgres
#初始化数据库
/usr/local/pg/bin/initdb -D /usr/local/pg/pgsqldata


mkdir /usr/local/pg/pgsqldata/logs

#启动
/usr/local/pg/bin/pg_ctl -D /usr/local/pg/pgsqldata -l /usr/local/pg/pgsqldata/logs/pgsql.log start 


/usr/local/pg/bin/createdb test #创建测试库
/usr/local/pg/bin/psql test #进入数据库

#6.修改管理员密码
ALTER USER postgres WITH PASSWORD '060708';

su  postgres  
/usr/local/pg
./bin/psql -h 127.0.0.1 -d test -U postgres  -p 5432

su  postgres  
/usr/local/pg/bin/pg_ctl -D /usr/local/pg/pgsqldata -l /usr/local/pg/pgsqldata/logs/pgsql.log stop

####修改postgresql.conf文件，取消 listen_addresses 的注释，将参数值改为“*”

####修改pg_hba.conf文件，增加下图红框部分内容
host    all             all             0.0.0.0/0            md5

####navicat
https://www.cnblogs.com/zhi-leaf/p/11432054.html

CREATE USER admin  WITH PASSWORD '060708';

#6.修改管理员密码
ALTER USER postgres WITH PASSWORD '060708';

SELECT usename, passwd FROM pg_shadow;

[Unit]
Description=PostgreSQL Database Server
Documentation=man:postgres(1)

[Service]
ExecStart=/usr/local/pg/bin/pg_ctl -D /usr/local/pg/pgsqldata
ExecReload=/bin/kill -HUP $MAINPID
KillMode=mixed
KillSignal=SIGINT
TimeoutSec=300

[Install]
WantedBy=default.target

/etc/systemd/system/

这个目录下 ，是  存放service  文件的地方