centos換源+安裝postgresql
centos換源+安裝postgresql
1 更換阿里源
[ivanlee@localhost Desktop]$ cd /etc/yum.repos.d [ivanlee@localhost yum.repos.d]$ ls CentOS-AppStream.repo CentOS-Devel.repo CentOS-PowerTools.repo CentOS-Base.repo CentOS-Extras.repo CentOS-Sources.repo CentOS-centosplus.repo CentOS-fasttrack.repo CentOS-Vault.repo CentOS-CR.repo CentOS-HA.repo CentOS-Debuginfo.repo CentOS-Media.repo
[root@localhost yum.repos.d]# rm *.repo rm: remove regular file 'CentOS-AppStream.repo'? y ·························
[root@localhost yum.repos.d]# wget -O /etc/yum.repos.d/CentOS-Base.repo --2022-03-22 13:53:56-- Resolving mirrors.aliyun.com (mirrors.aliyun.com)... 139.227.225.136, 2408:8744:803:2:3::3fe, 2408:8744:803:2:3::3fd Connecting to mirrors.aliyun.com (mirrors.aliyun.com)|139.227.225.136|:443... connected. HTTP request sent, awaiting response... 200 OK Length: 2495 (2.4K) [application/octet-stream] Saving to: ‘/etc/yum.repos.d/CentOS-Base.repo’ /etc/yum.repos.d/CentOS-Base.repo 100%[==========================================================================================================>] 2.44K --.-KB/s in 0s 2022-03-22 13:54:01 (60.0 MB/s) - ‘/etc/yum.repos.d/CentOS-Base.repo’ saved [2495/2495] [root@localhost yum.repos.d]# yum makecache CentOS-8.5.2111 - Base - mirrors.aliyun.com 437 kB/s | 4.6 MB 00:10 CentOS-8.5.2111 - Extras - mirrors.aliyun.com 1.0 kB/s | 10 kB 00:10 CentOS-8.5.2111 - AppStream - mirrors.aliyun.com 739 kB/s | 8.4 MB 00:11 Metadata cache created.
[root@localhost yum.repos.d]# wget -O /etc/yum.repos.d/CentOS-Base.repo --2022-05-07 15:42:13-- Resolving mirrors.aliyun.com (mirrors.aliyun.com)... failed: Name or service not known. wget: unable to resolve host address 'mirrors.aliyun.com'
nameserver 8.8.8.8 nameserver 8.8.4.4
手動安裝
pgsql
[root@localhost yum.repos.d]# dnf install Last metadata expiration check: 0:00:35 ago on Tue 22 Mar 2022 01:54:51 PM CST. pgdg-redhat-repo-latest.noarch.rpm 2.0 kB/s | 13 kB 00:06 Dependencies resolved. ===================================================================================================================================================================================================== Package Architecture Version Repository Size ===================================================================================================================================================================================================== Installing: pgdg-redhat-repo noarch 42.0-24 @commandline 13 k Transaction Summary ===================================================================================================================================================================================================== Install 1 Package Total size: 13 k Installed size: 12 k Is this ok [y/N]: y Downloading Packages: Running transaction check Transaction check succeeded. Running transaction test Transaction test succeeded. Running transaction Preparing : 1/1 Installing : pgdg-redhat-repo-42.0-24.noarch 1/1 Verifying : pgdg-redhat-repo-42.0-24.noarch 1/1 Installed products updated. Installed: pgdg-redhat-repo-42.0-24.noarch Complete! [root@localhost yum.repos.d]# dnf module list postgresql PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64 15 B/s | 195 B 00:12 PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64 1.6 MB/s | 1.7 kB 00:00 Importing GPG key 0x442DF0F8: Userid : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>" Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8 From : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG Is this ok [y/N]: y PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64 30 kB/s | 619 kB 00:20 PostgreSQL 14 for RHEL / Rocky 8 - x86_64 15 B/s | 195 B 00:12 PostgreSQL 14 for RHEL / Rocky 8 - x86_64 1.6 MB/s | 1.7 kB 00:00 Importing GPG key 0x442DF0F8: Userid : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>" Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8 From : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG Is this ok [y/N]: y PostgreSQL 14 for RHEL / Rocky 8 - x86_64 11 kB/s | 208 kB 00:19 PostgreSQL 13 for RHEL / Rocky 8 - x86_64 16 B/s | 195 B 00:12 PostgreSQL 13 for RHEL / Rocky 8 - x86_64 1.6 MB/s | 1.7 kB 00:00 Importing GPG key 0x442DF0F8: Userid : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>" Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8 From : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG Is this ok [y/N]: y PostgreSQL 13 for RHEL / Rocky 8 - x86_64 26 kB/s | 526 kB 00:19 PostgreSQL 12 for RHEL / Rocky 8 - x86_64 15 B/s | 195 B 00:12 PostgreSQL 12 for RHEL / Rocky 8 - x86_64 1.6 MB/s | 1.7 kB 00:00 Importing GPG key 0x442DF0F8: Userid : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>" Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8 From : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG Is this ok [y/N]: y PostgreSQL 12 for RHEL / Rocky 8 - x86_64 36 kB/s | 694 kB 00:19 PostgreSQL 11 for RHEL / Rocky 8 - x86_64 16 B/s | 195 B 00:12 PostgreSQL 11 for RHEL / Rocky 8 - x86_64 1.6 MB/s | 1.7 kB 00:00 Importing GPG key 0x442DF0F8: Userid : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>" Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8 From : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG Is this ok [y/N]: y PostgreSQL 11 for RHEL / Rocky 8 - x86_64 41 kB/s | 885 kB 00:21 PostgreSQL 10 for RHEL / Rocky 8 - x86_64 16 B/s | 195 B 00:12 PostgreSQL 10 for RHEL / Rocky 8 - x86_64 1.6 MB/s | 1.7 kB 00:00 Importing GPG key 0x442DF0F8: Userid : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>" Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8 From : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG Is this ok [y/N]: y PostgreSQL 10 for RHEL / Rocky 8 - x86_64 29 kB/s | 588 kB 00:20 CentOS-8.5.2111 - AppStream - mirrors.aliyun.com Name Stream Profiles Summary postgresql 9.6 client, server [d] PostgreSQL server and client module postgresql 10 [d] client, server [d] PostgreSQL server and client module postgresql 12 client, server [d] PostgreSQL server and client module postgresql 13 client, server [d] PostgreSQL server and client module Hint: [d]efault, [e]nabled, [x]disabled, [i]nstalled
[root@localhost ~]# dnf module disable postgresql PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64 16 B/s | 195 B 00:12 PostgreSQL 14 for RHEL / Rocky 8 - x86_64 16 B/s | 195 B 00:12 PostgreSQL 13 for RHEL / Rocky 8 - x86_64 16 B/s | 195 B 00:12 PostgreSQL 12 for RHEL / Rocky 8 - x86_64 16 B/s | 195 B 00:12 Dependencies resolved. ===================================================================================================================================================================================================== Package Architecture Version Repository Size ===================================================================================================================================================================================================== Disabling modules: postgresql Transaction Summary ===================================================================================================================================================================================================== Is this ok [y/N]: y Complete!
[root@localhost ~]# dnf install postgresql12 Last metadata expiration check: 0:08:39 ago on Tue 22 Mar 2022 02:00:31 PM CST. All matches were filtered out by modular filtering for argument: postgresql12 Error: Unable to find a match: postgresql12 [root@localhost ~]# dnf config-manager --disable pgdg11 [root@localhost ~]# dnf config-manager --disable pgdg10 [root@localhost ~]# dnf config-manager --disable pgdg96 Error: No matching repo to modify: pgdg96. [root@localhost ~]# dnf module disable postgresql PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64 16 B/s | 195 B 00:12 PostgreSQL 14 for RHEL / Rocky 8 - x86_64 16 B/s | 195 B 00:12 PostgreSQL 13 for RHEL / Rocky 8 - x86_64 16 B/s | 195 B 00:12 PostgreSQL 12 for RHEL / Rocky 8 - x86_64 16 B/s | 195 B 00:12 Dependencies resolved. ===================================================================================================================================================================================================== Package Architecture Version Repository Size ===================================================================================================================================================================================================== Disabling modules: postgresql Transaction Summary ===================================================================================================================================================================================================== Is this ok [y/N]: y Complete! [root@localhost ~]# dnf install postgresql12 Last metadata expiration check: 0:01:29 ago on Tue 22 Mar 2022 02:10:45 PM CST. Dependencies resolved. ===================================================================================================================================================================================================== Package Architecture Version Repository Size ===================================================================================================================================================================================================== Installing: postgresql12 x86_64 12.10-1PGDG.rhel8 pgdg12 1.7 M Installing dependencies: postgresql12-libs x86_64 12.10-1PGDG.rhel8 pgdg12 400 k Transaction Summary ===================================================================================================================================================================================================== Install 2 Packages Total download size: 2.1 M Installed size: 10 M Is this ok [y/N]: y Downloading Packages: (1/2): postgresql12-libs-12.10-1PGDG.rhel8.x86_64.rpm 50 kB/s | 400 kB 00:08 (2/2): postgresql12-12.10-1PGDG.rhel8.x86_64.rpm 172 kB/s | 1.7 MB 00:09 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 213 kB/s | 2.1 MB 00:09 warning: /var/cache/dnf/pgdg12-64e2194e85277659/packages/postgresql12-12.10-1PGDG.rhel8.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY PostgreSQL 12 for RHEL / Rocky 8 - x86_64 1.6 MB/s | 1.7 kB 00:00 Importing GPG key 0x442DF0F8: Userid : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>" Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8 From : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG Is this ok [y/N]: y Key imported successfully Running transaction check Transaction check succeeded. Running transaction test Transaction test succeeded. Running transaction Preparing : 1/1 Installing : postgresql12-libs-12.10-1PGDG.rhel8.x86_64 1/2 Running scriptlet: postgresql12-libs-12.10-1PGDG.rhel8.x86_64 1/2 Installing : postgresql12-12.10-1PGDG.rhel8.x86_64 2/2 Running scriptlet: postgresql12-12.10-1PGDG.rhel8.x86_64 2/2 Verifying : postgresql12-12.10-1PGDG.rhel8.x86_64 1/2 Verifying : postgresql12-libs-12.10-1PGDG.rhel8.x86_64 2/2 Installed products updated. Installed: postgresql12-12.10-1PGDG.rhel8.x86_64 postgresql12-libs-12.10-1PGDG.rhel8.x86_64 Complete!
[root@localhost ~]# dnf install postgresql12-server Last metadata expiration check: 0:05:33 ago on Tue 22 Mar 2022 02:10:45 PM CST. Dependencies resolved. ===================================================================================================================================================================================================== Package Architecture Version Repository Size ===================================================================================================================================================================================================== Installing: postgresql12-server x86_64 12.10-1PGDG.rhel8 pgdg12 5.2 M Transaction Summary ===================================================================================================================================================================================================== Install 1 Package Total download size: 5.2 M Installed size: 21 M Is this ok [y/N]: y Downloading Packages: postgresql12-server-12.10-1PGDG.rhel8.x86_64.rpm 390 kB/s | 5.2 MB 00:13 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 390 kB/s | 5.2 MB 00:13 Running transaction check Transaction check succeeded. Running transaction test Transaction test succeeded. Running transaction Preparing : 1/1 Running scriptlet: postgresql12-server-12.10-1PGDG.rhel8.x86_64 1/1 Installing : postgresql12-server-12.10-1PGDG.rhel8.x86_64 1/1 Running scriptlet: postgresql12-server-12.10-1PGDG.rhel8.x86_64 1/1 Verifying : postgresql12-server-12.10-1PGDG.rhel8.x86_64 1/1 Installed products updated. Installed: postgresql12-server-12.10-1PGDG.rhel8.x86_64 Complete!
[root@localhost ~]# dnf install postgresql12-contrib Last metadata expiration check: 0:09:45 ago on Tue 22 Mar 2022 02:10:45 PM CST. Dependencies resolved. ===================================================================================================================================================================================================== Package Architecture Version Repository Size ===================================================================================================================================================================================================== Installing: postgresql12-contrib x86_64 12.10-1PGDG.rhel8 pgdg12 645 k Transaction Summary ===================================================================================================================================================================================================== Install 1 Package Total download size: 645 k Installed size: 2.3 M Is this ok [y/N]: y Downloading Packages: postgresql12-contrib-12.10-1PGDG.rhel8.x86_64.rpm 84 kB/s | 645 kB 00:07 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 84 kB/s | 645 kB 00:07 Running transaction check Transaction check succeeded. Running transaction test Transaction test succeeded. Running transaction Preparing : 1/1 Installing : postgresql12-contrib-12.10-1PGDG.rhel8.x86_64 1/1 Running scriptlet: postgresql12-contrib-12.10-1PGDG.rhel8.x86_64 1/1 Verifying : postgresql12-contrib-12.10-1PGDG.rhel8.x86_64 1/1 Installed products updated. Installed: postgresql12-contrib-12.10-1PGDG.rhel8.x86_64 Complete!
pgsql的配置
1 設定資料庫預設的資料儲存目錄
[root@localhost /]# mkdir -p /data/pgsql12-data [root@localhost /]# ls bin boot data dev etc home lib lib64 lost+found media mnt opt proc root run sbin srv sys tmp usr var [root@localhost /]# cd data [root@localhost data]# ll total 4 drwxr-xr-x. 2 root root 4096 Mar 22 14:27 pgsql12-data
[root@localhost data]# chown postgres:postgres /data/pgsql12-data
2 初始化資料庫例項
[root@localhost data]# cd /usr/pgsql-12/bin [root@localhost bin]# ./postgresql-12-setup initdb Initializing database ... OK
3 啟動資料庫例項服務，並設定為開機自動啟動
[root@localhost bin]# systemctl enable postgresql-12.service Created symlink /etc/systemd/system/multi-user.target.wants/postgresql-12.service → /usr/lib/systemd/system/postgresql-12.service. [root@localhost bin]# systemctl start postgresql-12.service
4 設定資料庫例項超級管理員賬戶postgres的口令
[root@localhost bin]# passwd postgres Changing password for user postgres. New password: prs@2018 Retype new password: prs@2018 passwd: all authentication tokens updated successfully.
[root@localhost bin]# su postgres bash-4.4$ psql psql (12.10) Type "help" for help. postgres=# alter user postgres with password 'xxxxx'; ALTER ROLE postgres=# \q bash-4.4$ exit exit [root@localhost bin]#
5 設定資料庫例項的遠端訪問策略
vim /data/pgsql12-data/pg_hba.conf "配置檔案conf" image-20220507152653413
[root@localhost bin]# firewall-cmd --zone=public --add-port=5432/tcp --permanent success [root@localhost bin]# firewall-cmd --reload success
重新啟動資料庫服務例項
systemctl restart postgresql-12.service
資料庫的運維和管理
[root@localhost bin]# systemctl start postgresql-12.service #開啟
[root@localhost bin]# systemctl stop postgresql-12.service #停止
[root@localhost bin]# systemctl restart postgresql-12.service #重啟
[root@localhost bin]# systemctl status postgresql-12.service #檢視狀態
● postgresql-12.service - PostgreSQL 12 database server
Loaded: loaded (/usr/lib/systemd/system/postgresql-12.service; enabled; vendor preset: disabled)
Active: active (running) since Tue 2022-03-22 15:02:49 CST; 7s ago
Docs:
Process: 41843 ExecStartPre=/usr/pgsql-12/bin/postgresql-12-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
Main PID: 41849 (postmaster)
Tasks: 8 (limit: 11432)
Memory: 17.8M
CGroup: /system.slice/postgresql-12.service
├─41849 /usr/pgsql-12/bin/postmaster -D /data/pgsql12-data/
├─41853 postgres: logger
├─41855 postgres: checkpointer
├─41856 postgres: background writer
├─41857 postgres: walwriter
├─41858 postgres: autovacuum launcher
├─41859 postgres: stats collector
└─41860 postgres: logical replication launcher
Mar 22 15:02:49 localhost.localdomain systemd[1]: Starting PostgreSQL 12 database server...
Mar 22 15:02:49 localhost.localdomain postmaster[41849]: 2022-03-22 15:02:49.320 CST [41849] LOG: starting PostgreSQL 12.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8>
Mar 22 15:02:49 localhost.localdomain postmaster[41849]: 2022-03-22 15:02:49.321 CST [41849] LOG: listening on IPv4 address "0.0.0.0", port 5432
Mar 22 15:02:49 localhost.localdomain postmaster[41849]: 2022-03-22 15:02:49.321 CST [41849] LOG: listening on IPv6 address "::", port 5432
Mar 22 15:02:49 localhost.localdomain postmaster[41849]: 2022-03-22 15:02:49.324 CST [41849] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
Mar 22 15:02:49 localhost.localdomain postmaster[41849]: 2022-03-22 15:02:49.328 CST [41849] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
Mar 22 15:02:49 localhost.localdomain postmaster[41849]: 2022-03-22 15:02:49.338 CST [41849] LOG: redirecting log output to logging collector process
Mar 22 15:02:49 localhost.localdomain postmaster[41849]: 2022-03-22 15:02:49.338 CST [41849] HINT: Future log output will appear in directory "log".
Mar 22 15:02:49 localhost.localdomain systemd[1]: Started PostgreSQL 12 database server.
[root@localhost bin]# systemctl enable postgresql-12.service #開機自動開啟[root@localhost pgsql12-data]# su postgres bash-4.4$ psql psql (12.10) Type "help" for help. postgres=# CREATE DATABASE pvp_msf; CREATE DATABASE postgres=# CREATE DATABASE pvp_strike_db; CREATE DATABASE
離線安裝需要的包
postgresql12-contrib-12.10-1PGDG.rhel8.x86_64.rpm postgresql12-devel-12.10-1PGDG.rhel8.x86_64.rpm postgresql12-docs-12.10-1PGDG.rhel8.x86_64.rpm postgresql12-libs-12.10-1PGDG.rhel8.x86_64.rpm postgresql12-llvmjit-12.10-1PGDG.rhel8.x86_64.rpm postgresql12-plperl-12.10-1PGDG.rhel8.x86_64.rpm postgresql12-plpython-12.10-1PGDG.rhel8.x86_64.rpm postgresql12-plpython3-12.10-1PGDG.rhel8.x86_64.rpm postgresql12-pltcl-12.10-1PGDG.rhel8.x86_64.rpm postgresql12-server-12.10-1PGDG.rhel8.x86_64.rpm postgresql12-test-12.10-1PGDG.rhel8.x86_64.rpm
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/70003733/viewspace-2894405/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 【CentOS】CentOS7安裝PostgreSQLCentOSSQL
- CentOS7 切換阿里映象源並安裝 dockerCentOS阿里Docker
- CentOS 7.8安裝PostgreSQL(生產系統)CentOSSQL
- CentOS7.X安裝postgresql-10.3CentOSSQL
- CentOS7下PostgreSQL安裝過程CentOSSQL
- CentOS 7 安裝、配置、使用 PostgreSQL 10 安裝及基礎配置CentOSSQL
- Centos 7 上安裝Postgresql10.5和PostGISCentOSSQL
- rockylinux換源 安裝xfceLinux
- PostgreSQL tar.gz在centos7上安裝SQLCentOS
- Homebrew 換源安裝與使用
- Red Hat Linux安裝CentOS的yum源LinuxCentOS
- ubuntu更換安裝源和pip映象源Ubuntu
- CentOS7安裝PostgreSQL15以及PostGIS3.3CentOSSQLS3
- 教你如何在Centos8-stream安裝PostgreSQL13CentOSSQL
- centos 替換yum源CentOS
- CentOS8換源CentOS
- CentOS 7.4 環境下原始碼編譯安裝 postgreSQL 11.4CentOS原始碼編譯SQL
- CentOS7.5安裝PostgreSQL作業系統配置指令碼CentOSSQL作業系統指令碼
- postgresql安裝過程中核心資源的配置SQL
- 【yum源】CentOS7安裝第三方源CentOS
- Node-red節點安裝換源
- Mac上HomeBrew安裝及換源教程Mac
- Mac-Homebrew 安裝/解除安裝/更換國內映象源Mac
- Postgresql——postgis安裝SQL
- postgresql安裝(source)SQL
- PostgreSQL：Redhat 8.5 + PostgreSQL 14.5 安裝SQLRedhat
- 教你如何在CentOS7系統上安裝postgreSQL11CentOSSQL
- Linux伺服器配置——安裝CentOS以及源配置Linux伺服器CentOS
- PostgreSQL 10.12 安裝系列 - 原始碼安裝SQL原始碼
- PostgreSQL 10.12 安裝系列 - 本地RPM安裝SQL
- centos安裝nodeCentOS
- centos 安裝pyenvCentOS
- CentOS 安裝 dockerCentOSDocker
- CentOS安裝jdkCentOSJDK
- CentOS Docker 安裝CentOSDocker
- Centos 安裝 JenkinsCentOSJenkins
- centOS安裝rabbitMQCentOSMQ
- CentOS 安裝 mavenCentOSMaven