9月25日PG18发布，赶紧下来看看。
环境：
Oracle linux 10.0 + pg18.0
1. 建用户
useradd postgres
echo "sztech@4U" |passwd --stdin postgres
2.创建软件目录
mkdir /software/pg18
mkdir /pg18/soft
mkdir /data
chown postgres: /software/pg18 /data /pg18/soft
chmod -R 775 /data
3.下载源码到 /software/pg18
cd /software/pg18
wget https://ftp.postgresql.org/pub/s ... tgresql-18.0.tar.gz
4.解压源码
tar -xvf postgresql-18.0.tar.gz
5.安装依赖包
使用root用户执行
yum install e2fsprogs-devel libuuid-devel perl-core
yum install bison tcl tcl-devel perl-ExtUtils-Embed readline-devel zlib-devel pam-devel libxml2-devel libxslt-devel libicu-devel openldap-devel python3-devel gcc-c++ openssl-devel cmake gcc* readline-devel
yum install docbook-dtds docbook-style-xsl libxml2 libxml2-devel libxslt libxslt-devel xmlto perl-XML-SAX
6.配置
su - postgres
cd /software/pg18/postgresql-18.0
./configure --prefix=/pg18/soft --with-openssl --with-pgport=5432 --with-tcl --with-perl --with-python --with-libxml --with-libxslt --with-uuid=e2fs --with-pam --with-ldap
7.编译
gmake world
8.安装
gmake install-world
9.配置环境变量
vim /home/postgres/.bash_profile
export PGHOME=/pg18/soft
export PGDATA=/data/
export PATH=$PGHOME/bin:$PATH
export LD_LIBRARY_PATH=$PGHOME/lib:$LD_LIBRARY_PATH
10.初始化数据库
/pg18/soft/bin/initdb -D /data --encoding=UTF8 --lc-collate=en_US.UTF-8 --lc-ctype=en_US.UTF-8
11.登录测试一下
postgres@pg16:~$ psql
psql (18.0)
Type "help" for help.
postgres=# select version();
version
----------------------------------------------------------------------------------------------------------
PostgreSQL 18.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 14.2.1 20250110 (Red Hat 14.2.1-7), 64-bit
(1 row)
postgres=#
到此，PG18安装完成。
其他自动启动脚本，后续再搞，不影响应用。