pg_dumpall -U postgres > /path/to/backup.sql
命令备份所有数据库。psql --version
或sudo -u postgres psql -c "SELECT version();"
确认当前版本。sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
。sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
。sudo systemctl stop postgresql
。sudo yum update postgresql-server
。sudo systemctl start postgresql
。sudo yum install postgresql15-server
。sudo /usr/pgsql-15/bin/postgresql-15-setup initdb
。pg_upgrade
(需确保新旧版本兼容):
sudo /usr/pgsql-15/bin/pg_upgrade -c -b /usr/pgsql-14/bin -B /usr/pgsql-15/bin -d /var/lib/pgsql/14/data -D /var/lib/pgsql/15/data
。sudo /usr/pgsql-15/bin/pg_upgrade -b /usr/pgsql-14/bin -B /usr/pgsql-15/bin -d /var/lib/pgsql/14/data -D /var/lib/pgsql/15/data
。sudo -u postgres pg_dumpall -f /path/to/backup.sql
。sudo -u postgres psql -f /path/to/backup.sql postgres
。sudo systemctl restart postgresql-15
。psql -U postgres -c "SELECT version();"
。sudo yum remove postgresql14-server
。postgresql.conf
和pg_hba.conf
等配置文件。