pg_dumpall
命令备份所有数据库,如sudo -u postgres pg_dumpall > /path/to/backup.sql
。sudo -u postgres psql -c "SELECT version();"
查看当前版本。sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt update
sudo apt install postgresql-<小版本号>
。sudo systemctl restart postgresql
。sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt update
sudo apt install postgresql-15
。sudo systemctl stop postgresql
。sudo /usr/lib/postgresql/15/bin/pg_ctl initdb -D /var/lib/postgresql/15/main/
。sudo -u postgres /usr/lib/postgresql/15/bin/pg_upgrade --old-bindir /usr/lib/postgresql/14/bin --new-bindir /usr/lib/postgresql/15/bin --old-datadir /var/lib/postgresql/14/main --new-datadir /var/lib/postgresql/15/main --check
。sudo -u postgres /usr/lib/postgresql/15/bin/pg_upgrade --old-bindir /usr/lib/postgresql/14/bin --new-bindir /usr/lib/postgresql/15/bin --old-datadir /var/lib/postgresql/14/main --new-datadir /var/lib/postgresql/15/main --link
。sudo -u postgres /usr/lib/postgresql/15/bin/vacuumdb --all --analyze-in-stages
。sudo -u postgres pg_dumpall -f /path/to/backup.sql
。sudo systemctl start postgresql@15-main
。sudo -u postgres psql -p <新端口> -c "SELECT version();"
。/var/log/postgresql/postgresql-<版本>-main.log
。