1.建立目录
   # mkdir -p /data/pgsql
   # mkdir -p / data/pgsql/data

2.安装依赖包
   # yum install -y perl-ExtUtils-Embed readline-devel zlib-devel pam-devel libxml2-devel libxslt-devel openldap-devel  python36-devel gcc-c++ openssl-devel cmake make

3.下载安装介质

postgresql.org/ftp/source/v14.8/

  上传到 /data

5. 创建postgresql用户
    # useradd postgres

6.设置数据目录
    # chown postgres:postgres -R   /data/pgsql

7 .设置postgres用户环境变量
    # su - postgres
    $ vi .bash_profile

    export PATH

    export PGHOME=/data/pgsql

    export PGDATA=/data/pgsql/data

    xport GG_HOME=/data/ogg

    export PATH=$PGHOME/bin:$PATH:$GG_HOME/bin

8.解压 安装源包
    $  cd /data
    $  tar -xvf postgresql-14.8.tar.gz

9 .安装配置
  $  cd /data/postgresql-14.8
   ./configure --prefix=/ data/pgsql --with-wal-blocksize=8 --with-segsize=1 --with-blocksize=8

10.编译  安装
    $ make
    $ make install

11 .安装扩展
    $  export PATH= /data/pgsql/bin:$PATH
    $ cd /data/postgresql-14.8/contrib
    $ make all
    $  make install

12. 初始化数据库

postgres@pgdb bin]$ ./initdb  -D /data/pgsql/data/

The files belonging to this database system will be owned by user "postgres".

This user must also own the server process.

The database cluster will be initialized with locale "zh_CN.UTF-8".

The default database encoding has accordingly been set to "UTF8".

initdb: could not find suitable text search configuration for locale "zh_CN.UTF-8"

The default text search configuration will be set to "simple".

Data page checksums are disabled.

fixing permissions on existing directory /data/pgsql/data ... ok

creating subdirectories ... ok

selecting dynamic shared memory implementation ... posix

selecting default max_connections ... 100

selecting default shared_buffers ... 128MB

selecting default time zone ... PRC

creating configuration files ... ok

running bootstrap script ... ok

performing post-bootstrap initialization ... ok

syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections

You can change this by editing pg_hba.conf or using the option -A, or

--auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    ./pg_ctl -D /data/pgsql/data/ -l logfile start

13. 修改参数

pg_hba.conf 

host      all           all              0.0.0.0/0              trust

listen_addresses = '*'          # what IP address(es) to listen on;

                                        # comma-separated list of addresses;

                                        # defaults to 'localhost'; use '*' for all

                                        # (change requires restart)

port = 5432                             # (change requires restart)

max_connections = 100                   # (change requires restart)

#superuser_reserved_connections = 3     # (change requires restart)

#unix_socket_directories = '/tmp'       # comma-separated list of directories

unix_socket_directories = '/data/pgsql/run'

                                        # (change requires restart)

#unix_socket_group = ''                 # (change requires restart)

#unix_socket_permissions = 0777         # begin with 0 to use octal notation

                                        # (change requires restart)

附：

自动启动脚本

1.

[root@pgdb system]# cat /etc/systemd/system/postgresql.service 

[Unit]

Description=PostgreSQL Database Server

After=network.target

[Service]

Type=forking

User=postgres

Group=postgres

Environment=PGPORT=5432

Environment=PGDATA=/data/pgsql/data

1OOMScoreAdjust=-1000

# 启动命令

ExecStart=/data/pgsql/bin/pg_ctl start -D ${PGDATA} -s -o "-p ${PGPORT}" -w -t 300

# 重新加载

ExecReload=/data/pgsql/bin/pg_ctl reload -D ${PGDATA} -s

# 停止程序

ExecStop=/data/pgsql/bin/pg_ctl  stop -D ${PGDATA} -s -m fast

KillMode=mixed

KillSignal=SIGINT

TimeoutSec=0

PrivateTmp=true

[Install]

WantedBy=multi-user.target

 2.重载systemctl服务

@pgdb ~]$systemctl daemon-reload 

3. 启动postgresql服务

@pgdb ~]$ sudo systemctl start postgresql.service

4.判断服务是否启动，这里提示成功启动

@pgdb ~]$ systemctl is-active postgresql.service 

active

5. 也可以通过此命令判断服务状态

@pgdb ~]$  systemctl status postgresql.service

6. 停止postgresql服务

pgdbt ~]$  systemctl stop postgresql.service

7. 如果启动配置失败，也可以通过journalctl命令查看日志查找原因

pgdb ~]$ journalctl -u postgresql.service 

设置开机自启动