centos换源+安装pgsql

最新推荐文章于 2024-04-15 02:45:33 发布
最新推荐文章于 2024-04-15 02:45:33 发布
阅读量1k 收藏 1
点赞数
文章标签： centos linux 运维
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_41669555/article/details/124518465
版权

centos换源+安装pgsql

http://mirror.nsc.liu.se/centos-store/8.2.2004/isos/x86_64/ 镜像安装网站

https://mirrors.edge.kernel.org/pub/software/scm/git/git-2.24.0.tar.xz git版本网站

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

首先全部删除源的所有文件，遇到所有的询问都是y

[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 https://mirrors.aliyun.com/repo/Centos-vault-8.5.2111.repo
--2022-03-22 13:53:56--  https://mirrors.aliyun.com/repo/Centos-vault-8.5.2111.repo
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.

手动安装pgsql

[root@localhost yum.repos.d]# dnf install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
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!

安装pgsql12

[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!

注意：程序安装目录是"/usr/pgsql-12"，程序运行目录是"/var/run/postgresql"，程序运行用户和组是"postgres:postgres"，"postgres"用户和组安装时默认创建。

pgsql的配置

1 设置数据库默认的数据存储目录

数据库实例的默认存储目录是/var/lib/pgsql/12/data/,/var是一个系统目录，不适合存放大量的业务数据，因此要在初始化数据库实例之前创建一个存储目录

mkdir -p /data/pgsql12-data：因为创建了多级目录，所以需要-p

[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

设置数据存储目录的所有者用户和组为postgres:postgres，postgres用户和组在安装PostgreSQL12时已创建

[root@localhost data]# chown postgres:postgres /data/pgsql12-data

修改postgreSQL12开机启动服务配置文件，设置为新的数据存储目录

[root@localhost data]# vim /usr/lib/systemd/system/postgresql-12.service <服务配置文件路径！>

将其中的enviroment变量注释掉，改为新的（vim如果卡死，按键ctrl+q）

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-liDSS5VY-1651322889719)(/Users/ivanlee/Library/Application Support/typora-user-images/image-20220322143611729.png)]

2 初始化数据库实例

进入程序安装目录下的bin目录下，执行postgresql-12-setup initdb命令。

[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的口令

postgreSQL12安装完成后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 'prs@2018';
ALTER ROLE
postgres=# \q
bash-4.4$ exit
exit
[root@localhost bin]#
5 设置数据库实例的远程访问策略

postgreSQL12安装完成后默认只允许本地访问

  1. 设置数据库实例访问策略，可以设置多个由主机类型、数据库、用户、IP地址组成的策略。

​ 在文件的"# IPv4 local connections"策略中追加一条“允许全部用户，通过全部网络地址访问全部数据库”的策略并保存，策略定义如 下：

vim /data/pgsql12-data/pg_hba.conf  "配置文件conf"

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-m5x3keWQ-1651322889720)(/Users/ivanlee/Library/Application Support/typora-user-images/image-20220322145413999.png)]

  1. 设置数据库实例的监听端口

    监听地址：*默认是全部地址，默认是localhost ｜｜监听端口：默认是5432

​ vim /data/pgsql12-data/postgresql.conf

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-cQbmVsVj-1651322889720)(/Users/ivanlee/Library/Application Support/typora-user-images/image-20220322145856514.png)]

  1. 设置防火墙端口

​ centOS8默认安装firewall防火墙，允许5432端口（PostgreSQL默认端口）访问服务器。

[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

数据库的运维和管理

  1. 数据库启动、停止、重启、查看状态、开机自启动、禁用开机自启动

    [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: https://www.postgresql.org/docs/12/static/
  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   #开机自动开启

  2. 创建用户

    [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

离线安装需要的包

rpms包：

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

静态资源包:postgresql-12.10 -tar.gz

IvanLee717
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
用于说明在 CentOS 下安装 PGSQL
03-16
CentOS / RHEL Linux 安装 PostgreSQL 数据库服务器 http://wiki.hawebs.net/index.php?title=PostgreSQL_%E7%9B%B8%E5%85%B3%E8%B5%84%E6%96%99%E4%B8%8B%E8%BD%BD
zabbix6.2.3系统数据库从Mysql迁移至PostgreSQL数据库（一）安装PostgreSQL数据库
forestqq的博客
11-11 1929
zabbix最新的6.2.3版从mysql切换到PostgreSQL数据库，并启用timescaledb，提升整体性能的实践案例
centos环境下postgresql安装配置_centospostmaster，2024年最新从新手到Flutter架构师一篇就够
最新发布
2401_84247505的博客
04-15 888
root@www ~]# su postgres //yum安装的默认创建一个’postgres’用户。postgres=# alter user postgres with password ‘密码’bash-4.2$ psql -U postgres // 进入postgres数据库。-bash-4.2$ psql -U postgres // 进入数据库。[root@www ~]# su - postgres // 切换用户。5、设置开机自启、启动。
3、在 CentOS 8 系统上安装 PostgreSQL 15.4
Stayhungry,Stayfoolish.
10-09 1796
PostgreSQL项目为最常见的发行版提供了所有支持版本的软件包存储库，支持所有Red Hat系列，如CentOS、Fedora、Scientific Linux、Oracle Linux和Red Hat Enterprise Linux。 目前，PostgreSQL的主流稳定版本是15版本。在本文中，我们将详细介绍在 CentOS 8 系统上安装PostgreSQL 15 版本的过程。
rocky9配置postgresql并备份到指定存放位置
weixin_69010480的博客
03-19 149
rocky9配置postgresql创建数据库和表适用中职组学生学习
从零开始学PostgreSQL (三) & Linux RPM 安装 PostgreSQL
优秀小白熊的博客
01-17 907
前言 rpm离线安装本质就是通过yum进行安装，只不过是在网络条件的限制下、无法联通互联网环境。可以用此处方式来进行替换，从而达到安装postgresql数据库的目的。 安装步骤 1、下载相关的rpm依赖包 PostgreSQL 官网下载网址：https://www.postgresql.org/download/ 选择你需要下载的环境 第一个选择的是系统，选择您的操作系统系列：这...
[BZOJ 4589] Hard Nim
C202044zxy的博客
06-09 165
一、题目 Claris和NanoApe在玩石子游戏，他们有n堆石子，规则如下： Claris和NanoApe两个人轮流拿石子，Claris先拿。 每次只能从一堆中取若干个，可将一堆全取走，但不可不取，拿到最后1颗石子的人获胜。 不同的初始局面，决定了最终的获胜者，有些局面下先拿的Claris会赢，其余的局面Claris会负。 Claris很好奇，如果这n堆石子满足每堆石子的初始数量是不超过m的质数，而且他们都会按照最优策略玩游戏，那么NanoApe能获胜的局面有多少种。 由于答案可能很大，你只需要给出答
postgresql 安装过程中遇到的问题总结
whiteautumnlovers的博客
12-10 1604
       本人使用的是Ubuntu系统，想要在新电脑上安装postgresql，本来只想用命令 sudo apt-get install postgresql 安装，但是出现了安装依赖问题，这个问题已经解决了后面会说明是怎样解决的,现在会将我安装的步骤和遇到的问题在下面列出。      1  由于使用命令下载postgresql不成，我就改成了使用二进制包来安装。要使用二进制包来安装post...
​在 Rocky Linux 9 上安装 PostgreSQL​
weixin_45729077的博客
04-17 367
要断开与 PostgreSQL 数据库命令提示符的连接，只需键入以下命令并按 Enter。现在您已登录到 PostgreSQL 数据库服务器。基础存储库中不可用。步骤 1. 第一步是将您的系统更新到最新版本的软件包列表。系统上安装 PostgreSQL 14。如需更多帮助或有用信息，我们建议您查看。步骤 3. 访问 PostgreSQL 命令提示符。数据库服务器后，默认情况下，它会创建一个。默认情况下，PostgreSQL 在。它还会创建一个具有相同名称“角色为 ' ' 的用户 '
pgsql优势，pgsql安装(centOs)，pgagent安装
运气不好努力来凑
09-12 1506
pgsql，pgagent安装说明，以及pgsql和mysql对比
Centos下安装postgreSQL
梦幻通灵
11-26 1万+
linux下安装使用postgresql数据库
centOS离线安装pgsql-12
12-11
sudo yum install -y postgresql12-server sudo /usr/pgsql-12/bin/postgresql-12-setup initdb sudo systemctl enable postgresql-12 sudo systemctl start postgresql-12
centos下php安装pgsql和pdo_pgsql扩展，这是另一种方法，很简便，用.so文件来安装
04-25
centos下php安装pgsql和pdo_pgsql扩展，这是另一种方法，很简便，用.so文件来安装
centos7离线安装postgres10和postgis
08-21
内有postgres和postgis的软件及其依赖包，还有一个无脑部署安装文档，亲自用虚拟机安装无网centos测过
Centos7.9安装部署Zabbix6
06-21
Centos7.9安装部署Zabbix6，需要安装包的发邮箱，文件里面包含邮箱地址
CentOS7 PostgreSQL安装、配置、使用详解
01-10
CentOS7 PostgreSQL安装 Install 安装 使用yum安装 yum install http://yum.postgresql.org/9.4/redhat/rhel-6-x86_64/pgdg-redhat94-9.4-1.noarch.rpm yum install postgresql94-server postgresql94-contrib ...
Linux centos7 在线及离线安装postgresql12 详细教程
weixin_68547003的博客
08-09 7361
Linux centos7 在线及离线安装postgresql12 详细教程
PostgreSQL（Pgsql）快速开始/ ubuntu、centos下PostgreSQL数据库安装配置/查看已经编译的pg 编译选项
热门推荐
西京刀客
01-04 1万+
PostgreSQL支持JSON和其他NoSQL功能，本机支持XML，允许索引JSON数据，MySQL支持JSON，不过不支持其他的NoSQL功能。只有社区版，没有其他任何分支版本，PGSQL官方统一开发，统一维护，社区版有所有功能，不像SQL Server和MySQL有标准版、企业版、经典版、社区版、开发版、web版之分。物理流复制，属于物理复制，跟SQL Server镜像/AlwaysOn一样，严格一致，没有任何可能导致不一致，性能和可靠性上，物理复制完胜逻辑复制，维护简单。
CentOS 下PostgreSQL安装、简单配置及数据迁移(存储目录迁移)
夜灬狼丶
01-31 5011
centosan安装postgresql数据库 postgresql数据库初始化 postgresql数据库配置修改 postgresql数据库修改监听范围 postgresql数据库修改数据库用户密码 postgresql数据库开启远程连接 附件内容：PostgreSQL数据迁移 方式一，postgresql数据库重新初始化数据库在导出导入 方式二：postgresql数据库存储文件迁移
centos7安装pgsql
08-26
您可以使用以下步骤在CentOS 7上安装PGSQL： 1. 首先，您需要安装PGSQL的yum源。您可以通过以下命令安装yum源： ``` sudo yum install -y ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值