postgresql-setup man page
postgresql-setup — manual page for postgresql-setup 5.0
Script is aimed to help sysadmin with basic database cluster administration. Usually, "postgresql-setup --initdb" and "postgresql-setup --upgrade" is enough, however there are other options described below.
For more info and howto/when use this script please look at the documentation file /usr/share/doc/postgresql/README.rpm-dist.
Available operation mode
- Initialize new PostgreSQL database cluster. This is usually the first action you perform after PostgreSQL server installation.
- Upgrade database cluster for new major version of PostgreSQL server. See the --upgrade-from option for more info.
- The UNIT_NAME is used to select proper unit configuration (unit == service or initscript name on non-systemd systems). For example, if you want to work with unit called 'postgresql@com_example.service', you should use 'postgresql@com_example' (without trailing .service string). When no UNIT_NAME is explicitly passed, the 'postgresql' string is used by default.
- port where the initialized server will listen for connections
- Specify absolute path to DB data directory, only use with --new-systemd-unit.
- Pre-generate system'd configuration in drop-in directory if the unit is not yet configured, requires non-default --unit specified and explicit --datadir and --port.
- Select proper unit name to upgrade from. This has similar semantics as --unit option.
- Print list of available IDs of upgrade scenarios to standard output.
- Specify id "old" postgresql stack to upgrade from. List of available IDs can be listed by --upgrade-ids. Default is 'postgresql'.
- Options carried by this variable are passed to subsequent call of `initdb` binary (see man initdb(1)). This variable is used also during 'upgrade' mode because the new cluster is actually re-initialized from the old one.
- Options in this variable are passed next to the subsequent call of `pg_upgrade`. For more info about possible options please look at man pg_upgrade(1).
- Set to '1' if you want to see very verbose shell debugging output.
Built against PostgreSQL version 9.6.1.
October 2016 postgresql-setup 5.0 User Commands