commands.sh

pg_upgrade

all

Upgrade a PostgreSQL database cluster to a new major version.

More info →

Options (10)

-c, --checkboolean

Check clusters before upgrading

Example: pg_upgrade {{[-c|--check]}} {{[-b|--old-bindir]}} {{path/to/old_bin}} {{[-B|--new-bindir]}} {{path/to/new_bin}} {{[-d|--old-datadir]}} {{path/to/old_data}} {{[-D|--new-datadir]}} {{path/to/new_data}}
-b, --old-bindirboolean

Check clusters before upgrading

Example: pg_upgrade {{[-c|--check]}} {{[-b|--old-bindir]}} {{path/to/old_bin}} {{[-B|--new-bindir]}} {{path/to/new_bin}} {{[-d|--old-datadir]}} {{path/to/old_data}} {{[-D|--new-datadir]}} {{path/to/new_data}}
-B, --new-bindirboolean

Check clusters before upgrading

Example: pg_upgrade {{[-c|--check]}} {{[-b|--old-bindir]}} {{path/to/old_bin}} {{[-B|--new-bindir]}} {{path/to/new_bin}} {{[-d|--old-datadir]}} {{path/to/old_data}} {{[-D|--new-datadir]}} {{path/to/new_data}}
-d, --old-datadirboolean

Check clusters before upgrading

Example: pg_upgrade {{[-c|--check]}} {{[-b|--old-bindir]}} {{path/to/old_bin}} {{[-B|--new-bindir]}} {{path/to/new_bin}} {{[-d|--old-datadir]}} {{path/to/old_data}} {{[-D|--new-datadir]}} {{path/to/new_data}}
-D, --new-datadirboolean

Check clusters before upgrading

Example: pg_upgrade {{[-c|--check]}} {{[-b|--old-bindir]}} {{path/to/old_bin}} {{[-B|--new-bindir]}} {{path/to/new_bin}} {{[-d|--old-datadir]}} {{path/to/old_data}} {{[-D|--new-datadir]}} {{path/to/new_data}}
-j, --jobsboolean

Use multiple parallel jobs during the upgrade

Example: pg_upgrade {{[-j|--jobs]}} {{njobs}} {{[-b|--old-bindir]}} {{path/to/old_bin}} {{[-B|--new-bindir]}} {{path/to/new_bin}} {{[-d|--old-datadir]}} {{path/to/old_data}} {{[-D|--new-datadir]}} {{path/to/new_data}}
-p, --old-portboolean

Specify the old and new PostgreSQL ports

Example: pg_upgrade {{[-p|--old-port]}} {{port}} {{[-P|--new-port]}} {{port}} {{[-b|--old-bindir]}} {{path/to/old_bin}} {{[-B|--new-bindir]}} {{path/to/new_bin}} {{[-d|--old-datadir]}} {{path/to/old_data}} {{[-D|--new-datadir]}} {{path/to/new_data}}
-P, --new-portboolean

Specify the old and new PostgreSQL ports

Example: pg_upgrade {{[-p|--old-port]}} {{port}} {{[-P|--new-port]}} {{port}} {{[-b|--old-bindir]}} {{path/to/old_bin}} {{[-B|--new-bindir]}} {{path/to/new_bin}} {{[-d|--old-datadir]}} {{path/to/old_data}} {{[-D|--new-datadir]}} {{path/to/new_data}}
-k, --linkboolean

Use hard links instead of copying files to the new cluster

Example: pg_upgrade {{[-k|--link]}} {{[-b|--old-bindir]}} {{path/to/old_bin}} {{[-B|--new-bindir]}} {{path/to/new_bin}} {{[-d|--old-datadir]}} {{path/to/old_data}} {{[-D|--new-datadir]}} {{path/to/new_data}}
--helpboolean

Display help

Example: pg_upgrade {{[-?|--help]}}

Examples (6)

Check clusters before upgrading

pg_upgrade [-c|--check] [-b|--old-bindir] path/to/old_bin [-B|--new-bindir] path/to/new_bin [-d|--old-datadir] path/to/old_data [-D|--new-datadir] path/to/new_data

Perform the actual upgrade

pg_upgrade [-b|--old-bindir] path/to/old_bin [-B|--new-bindir] path/to/new_bin [-d|--old-datadir] path/to/old_data [-D|--new-datadir] path/to/new_data

Use multiple parallel jobs during the upgrade

pg_upgrade [-j|--jobs] njobs [-b|--old-bindir] path/to/old_bin [-B|--new-bindir] path/to/new_bin [-d|--old-datadir] path/to/old_data [-D|--new-datadir] path/to/new_data

Specify the old and new PostgreSQL ports

pg_upgrade [-p|--old-port] port [-P|--new-port] port [-b|--old-bindir] path/to/old_bin [-B|--new-bindir] path/to/new_bin [-d|--old-datadir] path/to/old_data [-D|--new-datadir] path/to/new_data

Use hard links instead of copying files to the new cluster

pg_upgrade [-k|--link] [-b|--old-bindir] path/to/old_bin [-B|--new-bindir] path/to/new_bin [-d|--old-datadir] path/to/old_data [-D|--new-datadir] path/to/new_data

Display help

pg_upgrade [-?|--help]
made by @shridhargupta | data from tldr-pages