如标题所示,我想将我的
我正在使用
postgresql-10
升级到 postgresql-11
。我正在使用
ubuntu-18.04
。postgresql-10
升级到 postgresql-11
。ubuntu-18.04
。你可以关注这篇博客在Ubuntu上设置PostgreSQL-11。我发现它很容易和简单。
在你的Ubuntu机器上添加PostgreSQL软件包仓库。
echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main 11" | sudo tee /etc/apt/sources.list.d/pgsql.list
添加 PostgreSQL 软件包仓库的 GPG 密钥:
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
更新APT并安装postgresql-11sudo apt update && sudo apt install postgresql-11
将Postgres升级到最新版本(目前为13)或中间版本(例如11),应通过运行以下命令完成:
sudo apt install postgresql-common
sudo sh /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh
sudo -u postgres pg_dumpall > all.sql
// Install latest Postgres. Use `postgresql-11` for v11 instead of `postgresql` for latest.
sudo apt-get install -y postgresql
// The install sets up a cluster, which needs then to be removed for the upgrade.
// Stop and remove the newly installed cluster. Use `11` instead of `13` for v11
sudo pg_dropcluster 13 main --stop
// Upgrade the db. Takes the OLD version and OLD schema as required arguments
sudo pg_upgradecluster 10 main
// Test. Once you are satisfied, remove OLD cluster.
sudo pg_dropcluster 10 main
使用此命令:
sudo apt update && sudo apt install postgresql-11