环境:
当前版本:pg 9.4.6 安装路劲为:/data/pg946/
目标版本:pg 9.5.1 安装路劲为:/data/pg951/
*****************************************************
1.安装新版本
*****************************************************
/*******
make --version
gcc --version
perl --version
python --version
----1.安装环境包
yum -y install wget gcc gcc-c++ readline-devel zlib-devel make systemtap systemtap-sdt-devel \
perl perl-devel python python-devel tcl tcl-devel perl-ExtUtils-Embed \
sgml-common docbook stylesheets openjade sgml-tools xsltproc libxslt libxslt-devel \
libxml2 libxml2-devel zlib zlib-devel openssl openssl-devel pam pam-devel bison flex libreadline6-devel
******/
----2.编译安装
#useradd postgres && echo 'password' |passwd --stdin postgres
#mkdir -p /data/pg951/data && chown -R postgres /data/pg951/data
# wget https://ftp.postgresql.org/pub/source/v9.5.1/
#mkdir -p /soft && cd /soft
#rz
# tar xf postgresql-9.5.1.tar.gz && cd postgresql-9.5.1
#./configure
./configure --prefix=/data/pg951 \
--with-pgport=5435 \
--with-perl --with-python --with-tcl \
--with-openssl --without-ldap \
--with-libxml --with-libxslt \
--enable-thread-safety \
--with-wal-blocksize=64 \
--with-blocksize=32 \
--with-wal-segsize=64 \
-enable-dtrace \
--enable-debug
#make && make install
-----3.执行数据库初始化脚本(指定字符集)
$/data/pg951/bin/initdb -D /data/pg951/data --encoding=utf8 -U postgres
---结果如下
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 "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory /data/pg951/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementat
postgresql大版本升级
最新推荐文章于 2024-08-16 20:00:00 发布
本文档详细介绍了如何从PostgreSQL 9.4.6升级到9.5.1的过程,包括安装新版本、数据库初始化、启动新版本、执行pg_upgrade检查与升级、修改配置、启动新版本以及删除旧版本的步骤。在升级过程中,重点涉及了pg_upgrade工具的使用,以及在升级后的环境变量和端口设置。
摘要由CSDN通过智能技术生成