一、PostgreSQL软件安装

1. 配置主机名，添加/etc/hosts绑定

# hostname set-hostname test

# cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

172.20.184.83  test

2.关闭防火墙和selinux

# systemctl stop firewalld

# systemctl disable firewalld

# setenforce 0

# cat /etc/selinux/config

SELINUX=disabled

3.安装系统依赖包

#yum install -y gcc gcc-c++ perl-devel readline-devel zlib*

4.添加组与用户，创建目录

# groupadd postgres

# useradd  -g  postgres  postgres

# mkdir -p /var/postgre/data     /*存放数据文件*/

# mkdir -p /var/postgre/14.1      /*存放编译后的软件程序*/

# mkdir -p /var/postgre/software-iso   /*存放软件安装包*/

5.将安装包 postgresql-14.1.tar.bz2放到/var/postgre/software-iso目录下

6.修改权限

chown -R postgres:postgres /var/postgre

chmod -R 775 /var/postgre

7.配置环境变量

# su - postgres

$ vi .bash_profile  (添加如下内容)

export PGHOME=/var/postgre/14.1         #说明：postgre的安装、编译、数据的根目录

export PGDATA=/var/postgre/data         #说明：postgre的数据放置目录上述有说明路径

export PATH=$PATH:$PGHOME/bin           #说明：$PGHOME/psq/bin为编译路径

以下内容可选：

export PS1='[\u@\h \w]$'

export TMP=/tmp

export TMPDIR=$TMP

export EDITOR=vi

export LANG=en_US

export NLS_DATE_FORMAT='yyyy/mm/dd hh24:mi:ss'

8.解压安装包

$ cd  /var/postgre/software-iso

$ tar -xvf postgresql-14.1.tar.bz2

9.编译安装

$ cd /var/postgre/software-iso/postgresql-14.1

$ ./configure --prefix=/var/postgre/14.1

$ make world

$ make install-world

【编译报错一】

configure: error: could not determine flags for linking embedded Perl.

This probably means that ExtUtils::Embed or ExtUtils::MakeMaker is not

installed.

【解决方法】

# yum install perl-ExtUtils-Embed

【编译报错二】

configure: error: header file <Python.h> is required for Python

【解决方法】

# yum install python python-devel