CmdID

CmdID / Commands

pg_upgrade

Upgrade a PostgreSQL database cluster to a new major version. tldr-pages

On several platforms

Opens CmdID with your command. It is read in your browser and sent nowhere.

Several platforms

from tldr-pages, CC BY 4.0

Check clusters before upgrading

pg_upgrade --check --old-bindir path/to/old_bin --new-bindir path/to/new_bin --old-datadir path/to/old_data --new-datadir path/to/new_dataIdentify

Perform the actual upgrade

pg_upgrade --old-bindir path/to/old_bin --new-bindir path/to/new_bin --old-datadir path/to/old_data --new-datadir path/to/new_dataIdentify

Use multiple parallel jobs during the upgrade

pg_upgrade --jobs njobs --old-bindir path/to/old_bin --new-bindir path/to/new_bin --old-datadir path/to/old_data --new-datadir path/to/new_dataIdentify

Specify the old and new PostgreSQL ports

pg_upgrade --old-port port --new-port port --old-bindir path/to/old_bin --new-bindir path/to/new_bin --old-datadir path/to/old_data --new-datadir path/to/new_dataIdentify

Use hard links instead of copying files to the new cluster

pg_upgrade --link --old-bindir path/to/old_bin --new-bindir path/to/new_bin --old-datadir path/to/old_data --new-datadir path/to/new_dataIdentify

Display help

pg_upgrade --helpIdentify