PostgreSQL 15

一、安装前的准备

1、版本信息

操作系统	CentOS 7.9.2009
PostgreSQL 版本	PostgreSQL 15-15.7

2、下载安装包

RPM Chart - PostgreSQL YUM Repositoryhttps://yum.postgresql.org/rpmchart/进入官网，找到相应版本

点击框选内容

依次进入下载页面，下载相应版本安装包

二、安装

1、上传安装包到服务器/opt/目录下

2、安装

rpm -ivh postgresql15-libs-15.7-1PGDG.rhel7.x86_64.rpm  rpm -ivh postgresql15-15.7-1PGDG.rhel7.x86_64.rpm  rpm -ivh postgresql15-server-15.7-1PGDG.rhel7.x86_64.rpm

3、修改配置

vi /usr/lib/systemd/system/postgresql-15.service # 修改存储目录 Environment=PGDATA=/opt/postgres/data/

4、创建目录并修改权限

mkdir -p /opt/postgres/data chown -R postgres: postgres chmod 700 data/

5、初始化数据库

/usr/pgsql-15/bin/postgresql-15-setup initdb Initializing database ... OK

6、启动服务并设置开机自启

[root@localhost postgres]# systemctl start postgresql-15.service  [root@localhost postgres]# systemctl status postgresql-15.service  ● postgresql-15.service - PostgreSQL 15 database server    Loaded: loaded (/usr/lib/systemd/system/postgresql-15.service; disabled; vendor preset: disabled)    Active: active (running) since Fri 2024-08-02 04:59:05 EDT; 7s ago      Docs: https://www.postgresql.org/docs/15/static/   Process: 48801 ExecStartPre=/usr/pgsql-15/bin/postgresql-15-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)  Main PID: 48806 (postmaster)    CGroup: /system.slice/postgresql-15.service            ├─48806 /usr/pgsql-15/bin/postmaster -D /opt/postgres/data/            ├─48808 postgres: logger             ├─48809 postgres: checkpointer             ├─48810 postgres: background writer             ├─48812 postgres: walwriter             ├─48813 postgres: autovacuum launcher             └─48814 postgres: logical replication launcher   Aug 02 04:59:05 localhost.localdomain systemd[1]: Starting PostgreSQL 15 database server... Aug 02 04:59:05 localhost.localdomain postmaster[48806]: 2024-08-02 04:59:05.058 EDT [48806] LOG:  redirecting log output to logging collector process Aug 02 04:59:05 localhost.localdomain postmaster[48806]: 2024-08-02 04:59:05.058 EDT [48806] HINT:  Future log output will appear in directory "log". Aug 02 04:59:05 localhost.localdomain systemd[1]: Started PostgreSQL 15 database server. [root@localhost postgres]#  [root@localhost postgres]#  [root@localhost postgres]# systemctl enable postgresql-15.service g Failed to execute operation: No such file or directory [root@localhost postgres]# systemctl enable postgresql-15.service  Created symlink from /etc/systemd/system/multi-user.target.wants/postgresql-15.service to /usr/lib/systemd/system/postgresql-15.service.

7、修改管理员密码

[root@localhost postgres]# su - postgres  -bash-4.2$ psql  psql (15.7) Type "help" for help.  postgres=# alter user postgres with password 'postgres'; ALTER ROLE

8、设置允许远程登陆

vi /opt/postgres/data/postgresql.conf # 修改下面行 listen_addresses = '*'  vi /opt/postgres/data/pg_hba.conf # 在最后添加下面行 host    all             all             0.0.0.0/0               md5  # 重启服务，进行远程连接测试

三、错误

[root@localhost opt]# rpm -ivh postgresql15-server-15.7-1PGDG.rhel7.x86_64.rpm  warning: postgresql15-server-15.7-1PGDG.rhel7.x86_64.rpm: Header V4 RSA/SHA1 Signature, key ID 73e3b907: NOKEY error: Failed dependencies:         libicui18n.so.50()(64bit) is needed by postgresql15-server-15.7-1PGDG.rhel7.x86_64         libicuuc.so.50()(64bit) is needed by postgresql15-server-15.7-1PGDG.rhel7.x86_64         libzstd.so.1()(64bit) is needed by postgresql15-server-15.7-1PGDG.rhel7.x86_64         postgresql15(x86-64) = 15.7-1PGDG.rhel7 is needed by postgresql15-server-15.7-1PGDG.rhel7.x86_64  rpm -ivh libicu-50.2-4.el7_7.x86_64.rpm yum -y install libzstd.x86_64