postgresql安装包

ot@controller ~]# ifconfig docker0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500 inet 172.17.0.1 netmask 255.255.0.0 broadcast 172.17.255.255 inet6 fe80::42:28ff:fe83:4220 prefixlen 64 scopeid 0x20<link> ether 02:42:28:83:42:20 txqueuelen 0 (Ethernet) RX packets 0 bytes 0 (0.0 B) RX errors 0 dropped 0 overruns 0 frame 0 TX packets 21 bytes 3018 (2.9 KiB) TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 ens33: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500 inet 192.168.182.132 netmask 255.255.255.0 broadcast 192.168.182.255 inet6 fe80::ea43:5fa0:747f:7b67 prefixlen 64 scopeid 0x20<link> ether 00:0c:29:8f:e2:aa txqueuelen 1000 (Ethernet) RX packets 157 bytes 55661 (54.3 KiB) RX errors 0 dropped 0 overruns 0 frame 0 TX packets 139 bytes 15534 (15.1 KiB) TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 ens34: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500 ether 00:0c:29:8f:e2:b4 txqueuelen 1000 (Ethernet) RX packets 56 bytes 3360 (3.2 KiB) RX errors 0 dropped 0 overruns 0 frame 0 TX packets 0 bytes 0 (0.0 B) TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 lo: flags=73<UP,LOOPBACK,RUNNING> mtu 65536 inet 127.0.0.1 netmask 255.0.0.0 inet6 ::1 prefixlen 128 scopeid 0x10<host> loop txqueuelen 1000 (Local Loopback) RX packets 32 bytes 2592 (2.5 KiB) RX errors 0 dropped 0 overruns 0 frame 0 TX packets 32 bytes 2592 (2.5 KiB) TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 veth643fb56: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500 inet6 fe80::2087:6cff:fea6:ff0e prefixlen 64 scopeid 0x20<link> ether 22:87:6c:a6:ff:0e txqueuelen 0 (Ethernet) RX packets 0 bytes 0 (0.0 B) RX errors 0 dropped 0 overruns 0 frame 0 TX packets 27 bytes 3336 (3.2 KiB) TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 virbr0: flags=4099<UP,BROADCAST,MULTICAST> mtu 1500 inet 192.168.122.1 netmask 255.255.255.0 broadcast 192.168.122.255 ether 52:54:00:4e:61:a8 txqueuelen 1000 (Ethernet) RX packets 0 bytes 0 (0.0 B) RX errors 0 dropped 0 overruns 0 frame 0 TX packets 0 bytes 0 (0.0 B) TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 [root@controller ~]# pwd /root [root@controller ~]# ls anaconda-ks.cfg 公共 initial-setup-ks.cfg 模板 install.sh 视频 o2server 图片 o2server-7.1.4-linux-x64.zip 文档 postgresql13-13.8-1PGDG.rhel7.x86_64.rpm 下载 postgresql13-contrib-13.8-1PGDG.rhel7.x86_64.rpm 音乐 postgresql13-libs-13.8-1PGDG.rhel7.x86_64.rpm 桌面 postgresql13-server-13.8-1PGDG.rhel7.x86_64.rpm [root@controller ~]# mv ./*.rpm /tmp/ [root@controller ~]# cd /tmp/ [root@controller tmp]# ls postgresql13-13.8-1PGDG.rhel7.x86_64.rpm postgresql13-contrib-13.8-1PGDG.rhel7.x86_64.rpm postgresql13-libs-13.8-1PGDG.rhel7.x86_64.rpm postgresql13-server-13.8-1PGDG.rhel7.x86_64.rpm ssh-t8rphHU5B9GA systemd-private-c522dd6f2f0a49d19d4db9b727c8517c-bolt.service-BMyhVY systemd-private-c522dd6f2f0a49d19d4db9b727c8517c-chronyd.service-GdeU4v systemd-private-c522dd6f2f0a49d19d4db9b727c8517c-colord.service-U7ipgh systemd-private-c522dd6f2f0a49d19d4db9b727c8517c-cups.service-2zeJk8 systemd-private-c522dd6f2f0a49d19d4db9b727c8517c-fwupd.service-ZaAH1K systemd-private-c522dd6f2f0a49d19d4db9b727c8517c-rtkit-daemon.service-HGSgj1 tracker-extract-files.0 yum_save_tx.2022-09-26.21-46.qZnAP4.yumtx yum_save_tx.2022-09-27.06-46.8a0jIf.yumtx yum_save_tx.2022-09-28.06-46.g6YlRM.yumtx yum_save_tx.2022-09-29.06-46.xwDYiS.yumtx [root@controller tmp]# yum localinstall *.rpm 已加载插件：fastestmirror 正在检查 postgresql13-13.8-1PGDG.rhel7.x86_64.rpm: postgresql13-13.8-1PGDG.rhel7.x86_64 postgresql13-13.8-1PGDG.rhel7.x86_64.rpm 将被安装 正在检查 postgresql13-contrib-13.8-1PGDG.rhel7.x86_64.rpm: postgresql13-contrib-13.8-1PGDG.rhel7.x86_64 postgresql13-contrib-13.8-1PGDG.rhel7.x86_64.rpm 将被安装 正在检查 postgresql13-libs-13.8-1PGDG.rhel7.x86_64.rpm: postgresql13-libs-13.8-1PGDG.rhel7.x86_64 postgresql13-libs-13.8-1PGDG.rhel7.x86_64.rpm 将被安装 正在检查 postgresql13-server-13.8-1PGDG.rhel7.x86_64.rpm: postgresql13-server-13.8-1PGDG.rhel7.x86_64 postgresql13-server-13.8-1PGDG.rhel7.x86_64.rpm 将被安装 正在解决依赖关系 --> 正在检查事务 ---> 软件包 postgresql13.x86_64.0.13.8-1PGDG.rhel7 将被 安装 ---> 软件包 postgresql13-contrib.x86_64.0.13.8-1PGDG.rhel7 将被 安装 ---> 软件包 postgresql13-libs.x86_64.0.13.8-1PGDG.rhel7 将被 安装 ---> 软件包 postgresql13-server.x86_64.0.13.8-1PGDG.rhel7 将被 安装 --> 解决依赖关系完成 依赖关系解决 ======================================================================================= Package 架构 版本 源 大小 ======================================================================================= 正在安装: postgresql13 x86_64 13.8-1PGDG.rhel7 /postgresql13-13.8-1PGDG.rhel7.x86_64 7.4 M postgresql13-contrib x86_64 13.8-1PGDG.rhel7 /postgresql13-contrib-13.8-1PGDG.rhel7.x86_64 2.1 M postgresql13-libs x86_64 13.8-1PGDG.rhel7 /postgresql13-libs-13.8-1PGDG.rhel7.x86_64 1.5 M postgresql13-server x86_64 13.8-1PGDG.rhel7 /postgresql13-server-13.8-1PGDG.rhel7.x86_64 22 M 事务概要 ======================================================================================= 安装 4 软件包 总计：33 M 安装大小：33 M Is this ok [y/d/N]: y Downloading packages: Running transaction check Running transaction test Transaction test succeeded Running transaction 警告：RPM 数据库已被非 yum 程序修改。 正在安装 : postgresql13-libs-13.8-1PGDG.rhel7.x86_64 1/4 正在安装 : postgresql13-13.8-1PGDG.rhel7.x86_64 2/4 正在安装 : postgresql13-server-13.8-1PGDG.rhel7.x86_64 3/4 正在安装 : postgresql13-contrib-13.8-1PGDG.rhel7.x86_64 4/4 验证中 : postgresql13-13.8-1PGDG.rhel7.x86_64 1/4 验证中 : postgresql13-server-13.8-1PGDG.rhel7.x86_64 2/4 验证中 : postgresql13-libs-13.8-1PGDG.rhel7.x86_64 3/4 验证中 : postgresql13-contrib-13.8-1PGDG.rhel7.x86_64 4/4 已安装: postgresql13.x86_64 0:13.8-1PGDG.rhel7 postgresql13-contrib.x86_64 0:13.8-1PGDG.rhel7 postgresql13-libs.x86_64 0:13.8-1PGDG.rhel7 postgresql13-server.x86_64 0:13.8-1PGDG.rhel7 完毕！ [root@controller tmp]# systemctl status postgresql-13 ● postgresql-13.service - PostgreSQL 13 database server Loaded: loaded (/usr/lib/systemd/system/postgresql-13.service; disabled; vendor preset: disabled) Active: inactive (dead) Docs: https://www.postgresql.org/docs/13/static/ [root@controller tmp]# su - postgres -bash-4.2$ cd /usr/pgsql-13/bin/ -bash-4.2$ ls clusterdb pgbench pg_recvlogical pg_waldump createdb pg_checksums pg_resetwal postgres createuser pg_config pg_restore postgresql-13-check-db-dir dropdb pg_con