我们知道pg_upgrade和pg_dump/pg_restore可以实现大版本升级数据库,那么小版本如何升级,比如从9.6.3到9.6.5?
原理:用新版本的软件程序启动,指定老的的数据目录
安装pgsql9.6.3
mkdir -p /usr/local/pgsql/pgsql9.6.3/{data,arch}
groupadd dba
useradd -g dba -G root postgres -d /usr/local/pgsql
tar xf postgresql-9.6.3.tar.gz
chmod -R 755 /usr/local/pgsql
chown -R postgres:dba /usr/local/pgsql
chmod -R 700 /usr/local/pgsql/pgsql9.6.3/data/
./configure --prefix=/usr/local/pgsql/pgsql9.6.3/
make world && make install-world
cd /usr/local/pgsql/pgsql9.6.3/bin
./initdb -D /usr/local/pgsql/pgsql9.6.3/data -U postgres -E UTF8 -W
vim pg_hba.conf
host all all 0.0.0.0/0 md5
vim postgresql.conf
listen_addresses = '*'
wal_level = replica
port = 5432
max_connections = 300
shared