获取源代码

[root@master pg]# tar -zxvf postgresql-15.2.tar.gz

[root@master pg]#  cd postgresql-15.2/

·         编译，安装

[root@master postgresql-15.2]# ./configure

checking build system type... x86_64-pc-linux-gn

configure: error: readline library not found

If you have readline already installed, see config.log for details on the

failure.  It is possible the compiler isn't looking in the proper directory.

Use --without-readline to disable readline support.

[root@master postgresql-15.2]# make

You need to run the 'configure' program first. See the file

'INSTALL' for installation instructions, or visit:

<https://www.postgresql.org/docs/devel/installation.html>

make: *** [all] Error 1

解决办法

[root@master postgresql-15.2]# rpm -qa | grep readline

readline-6.2-10.el7.x86_64

[root@master postgresql-15.2]# yum search readline

Loaded plugins: fastestmirror, langpacks

Repodata is over 2 weeks old. Install yum-cron? Or run: yum makecache fast

Determining fastest mirrors

 * base: mirrors.aliyun.com

 * extras: mirrors.bfsu.edu.cn

 * updates: mirrors.aliyun.com

=================================================================== N/S matched: readline ===================================================================

lua-readline.x86_64 : Lua interface to the readline and history libraries

perl-Term-ReadLine-Gnu.x86_64 : Perl extension for the GNU Readline/History Library

rakudo-Readline.x86_64 : Simple Perl 6 binding to GNU libreadline

readline-devel.i686 : Files needed to develop programs which use the readline library

readline-devel.x86_64 : Files needed to develop programs which use the readline library

readline-static.i686 : Static libraries for the readline library

readline-static.x86_64 : Static libraries for the readline library

tcl-tclreadline.x86_64 : GNU Readline extension for Tcl/Tk

tcl-tclreadline-devel.x86_64 : Development files for the tclreadline library

editline.x86_64 : A small compatible replacement for readline

linenoise.x86_64 : Minimal replacement for readline

perl-Term-UI.noarch : Term::ReadLine user interface made easy

readline.x86_64 : A library for editing typed command lines

readline.i686 : A library for editing typed command lines

rlwrap.x86_64 : Wrapper for GNU readline

  Name and summary matches only, use "search all" for everything.

[root@master postgresql-15.2]#  yum -y install -y readline-devel

configure: error: zlib library not found

If you have zlib already installed, see config.log for details on the

failure.  It is possible the compiler isn't looking in the proper directory.

Use --without-zlib to disable zlib support.

[root@master postgresql-15.2]# make

You need to run the 'configure' program first. See the file

'INSTALL' for installation instructions, or visit:

<https://www.postgresql.org/docs/devel/installation.html>

make: *** [all] Error 1

[root@master postgresql-15.2]# yum install zlib-devel

make

make[1]: Leaving directory `/data/pg/postgresql-15.2/config'

[root@master postgresql-15.2]# make all

创建用户

为 postgres 创建用户

[root@master postgresql-15.2]# useradd postgres

[root@master postgresql-15.2]# passwd postgres

Changing password for user postgres.

New password:

[root@master config]#

[root@master config]# chown -R postgres:postgres /data/

[root@master config]#

[root@master config]#

[root@master config]#

[root@master config]# su - postgres

Last login: Thu Mar 16 08:59:57 CST 2023 on pts/0

[postgres@master ~]$ mkdir -p /data/pgdata/

[postgres@master ~]$

初始化数据库

su - postgres

initdb -D /data/pgdata/

修改配置文件

cd /data/pgdata/

vi postgresql.conf

# 将该条配置反注释，将localhost 改成*

listen_addresses = '*'

修改访问控制文件

vi pg_hba.conf

# IPv4 local connections:

host    all             all             0.0.0.0/0            md5

启动数据库

[postgres@pgDatabase ~]$ pg_ctl -D /data/pgdata/ -l logfile start

server starting

进入数据库修改postgres 密码

psql

postgres=# ALTER USER postgres WITH PASSWORD 'postgres';

ALTER ROLE

这样就算全部完成了，远程也可以连接数据库了。