Ubuntu22.04安装postgresql16.8

1.下载已经编译好的二进制包

安装包直达：pgsql16.8
二进制打包方式见：postgresql16.8二进制包编译

2.解压

sudotar-xvf pgsql16.8-ubuntu.tar.gz -C /opt/

3.编辑 postgresql.service

sudonano/etc/systemd/system/postgresql.service

[Unit]Description=PostgreSQL16.8ServerAfter=network.target[Service]Type=forkingUser=postgresGroup=postgresPIDFile=/opt/pgsql16.8/data/postmaster.pidEnvironment=PGDATA=/opt/pgsql16.8/dataEnvironment=PATH=/opt/pgsql16.8/bin:/usr/bin:/binExecStart=/opt/pgsql16.8/bin/pg_ctl start -D /opt/pgsql16.8/data -l /opt/pgsql16.8/data/logfileExecStop=/opt/pgsql16.8/bin/pg_ctl stop -D /opt/pgsql16.8/dataExecReload=/opt/pgsql16.8/bin/pg_ctl reload -D /opt/pgsql16.8/dataPermissionsStartOnly=trueRestart=on-failureRestartSec=3LimitNOFILE=65535LimitNPROC=65535[Install]WantedBy=multi-user.target

4.启动pgsql

## 加载servicesudosystemctl daemon-reload## 启动pgsqlsudosystemctl start postgresql## 加入开机启动sudosystemctlenablepostgresql## 查看状态sudosystemctl status postgresql

5.配置环境变量

echo'export PATH=/opt/pgsql16.8/bin:$PATH'>>~/.bashrcecho'export LD_LIBRARY_PATH=/opt/pgsql16.8/lib:$LD_LIBRARY_PATH'>>~/.bashrcsource~/.bashrc

6.修改密码

ALTERUSERpostgres PASSWORD'root@2025';

7.设置远程连接

# 修改 pg_hba.conf ，添加如下配置hostall all0.0.0.0/0 md5# 修改 postgresql.conflisten_addresses='*'# 重启服务sudosystemctl restart postgresql

8.登录验证

sudopsql -U postgres