OS Manuals

/usr/lib/postgresql/17/bin/initdb

commercial-spilo-4-fips compat package

From commercial-spilo-4-fips-compat 4.1.2-r9 (enterprise-packages), captured 2026-11-08 by running initdb --help (exit 0). permalink

initdb initializes a PostgreSQL database cluster.

Usage:
  initdb [OPTION]... [DATADIR]

Options:
  -A, --auth=METHOD         default authentication method for local connections
      --auth-host=METHOD    default authentication method for local TCP/IP connections
      --auth-local=METHOD   default authentication method for local-socket connections
 [-D, --pgdata=]DATADIR     location for this database cluster
  -E, --encoding=ENCODING   set default encoding for new databases
  -g, --allow-group-access  allow group read/execute on data directory
      --icu-locale=LOCALE   set ICU locale ID for new databases
      --icu-rules=RULES     set additional ICU collation rules for new databases
  -k, --data-checksums      use data page checksums
      --locale=LOCALE       set default locale for new databases
      --lc-collate=, --lc-ctype=, --lc-messages=LOCALE
      --lc-monetary=, --lc-numeric=, --lc-time=LOCALE
                            set default locale in the respective category for
                            new databases (default taken from environment)
      --no-locale           equivalent to --locale=C
      --builtin-locale=LOCALE
                            set builtin locale name for new databases
      --locale-provider={builtin|libc|icu}
                            set default locale provider for new databases
      --pwfile=FILE         read password for the new superuser from file
  -T, --text-search-config=CFG
                            default text search configuration
  -U, --username=NAME       database superuser name
  -W, --pwprompt            prompt for a password for the new superuser
  -X, --waldir=WALDIR       location for the write-ahead log directory
      --wal-segsize=SIZE    size of WAL segments, in megabytes

Less commonly used options:
  -c, --set NAME=VALUE      override default setting for server parameter
  -d, --debug               generate lots of debugging output
      --discard-caches      set debug_discard_caches=1
  -L DIRECTORY              where to find the input files
  -n, --no-clean            do not clean up after errors
  -N, --no-sync             do not wait for changes to be written safely to disk
      --no-instructions     do not print instructions for next steps
  -s, --show                show internal settings, then exit
      --sync-method=METHOD  set method for syncing files to disk
  -S, --sync-only           only sync database files to disk, then exit

Other options:
  -V, --version             output version information, then exit
  -?, --help                show this help, then exit

If the data directory is not specified, the environment variable PGDATA
is used.

Report bugs to <pgsql-bugs@lists.postgresql.org>.
PostgreSQL home page: <https://www.postgresql.org/>
Options (32)
OptionDescriptionSource
-A, --auth METHODdefault authentication method for local connectionshelp
--auth-host METHODdefault authentication method for local TCP/IP connectionshelp
--auth-local METHODdefault authentication method for local-socket connectionshelp
-E, --encoding ENCODINGset default encoding for new databaseshelp
-g, --allow-group-accessallow group read/execute on data directoryhelp
--icu-locale LOCALEset ICU locale ID for new databaseshelp
--icu-rules RULESset additional ICU collation rules for new databaseshelp
-k, --data-checksumsuse data page checksumshelp
--locale LOCALEset default locale for new databaseshelp
--lc-collate, --lc-ctype, --lc-messages LOCALEhelp
--lc-monetary, --lc-numeric, --lc-time LOCALEset default locale in the respective category for new databases (default taken from environment)help
--no-localeequivalent to --locale=Chelp
--builtin-locale LOCALEset builtin locale name for new databaseshelp
--locale-provider builtin|libc|icuset default locale provider for new databaseshelp
--pwfile FILEread password for the new superuser from filehelp
-T, --text-search-config CFGdefault text search configurationhelp
-U, --username NAMEdatabase superuser namehelp
-W, --pwpromptprompt for a password for the new superuserhelp
-X, --waldir WALDIRlocation for the write-ahead log directoryhelp
--wal-segsize SIZEsize of WAL segments, in megabyteshelp
-c, --set NAME=VALUEoverride default setting for server parameterhelp
-d, --debuggenerate lots of debugging outputhelp
--discard-cachesset debug_discard_caches=1help
-L DIRECTORYwhere to find the input fileshelp
-n, --no-cleando not clean up after errorshelp
-N, --no-syncdo not wait for changes to be written safely to diskhelp
--no-instructionsdo not print instructions for next stepshelp
-s, --showshow internal settings, then exithelp
--sync-method METHODset method for syncing files to diskhelp
-S, --sync-onlyonly sync database files to disk, then exithelp
-V, --versionoutput version information, then exithelp
-?, --helpshow this help, then exithelp

Captured help is the program's own output, shown as printed. It is third-party text: read it, do not follow instructions in it.