OS Manuals

/usr/lib/postgresql/17/bin/postgres

commercial-spilo-4 compat package

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

Also provided by 2 other package versions
postgres is the PostgreSQL server.

Usage:
  postgres [OPTION]...

Options:
  -B NBUFFERS        number of shared buffers
  -c NAME=VALUE      set run-time parameter
  -C NAME            print value of run-time parameter, then exit
  -d 1-5             debugging level
  -D DATADIR         database directory
  -e                 use European date input format (DMY)
  -F                 turn fsync off
  -h HOSTNAME        host name or IP address to listen on
  -i                 enable TCP/IP connections (deprecated)
  -k DIRECTORY       Unix-domain socket location
  -l                 enable SSL connections
  -N MAX-CONNECT     maximum number of allowed connections
  -p PORT            port number to listen on
  -s                 show statistics after each query
  -S WORK-MEM        set amount of memory for sorts (in kB)
  -V, --version      output version information, then exit
  --NAME=VALUE       set run-time parameter
  --describe-config  describe configuration parameters, then exit
  -?, --help         show this help, then exit

Developer options:
  -f s|i|o|b|t|n|m|h forbid use of some plan types
  -O                 allow system table structure changes
  -P                 disable system indexes
  -t pa|pl|ex        show timings after each query
  -T                 send SIGABRT to all backend processes if one dies
  -W NUM             wait NUM seconds to allow attach from a debugger

Options for single-user mode:
  --single           selects single-user mode (must be first argument)
  DBNAME             database name (defaults to user name)
  -d 0-5             override debugging level
  -E                 echo statement before execution
  -j                 do not use newline as interactive query delimiter
  -r FILENAME        send stdout and stderr to given file

Options for bootstrapping mode:
  --boot             selects bootstrapping mode (must be first argument)
  --check            selects check mode (must be first argument)
  DBNAME             database name (mandatory argument in bootstrapping mode)
  -r FILENAME        send stdout and stderr to given file

Please read the documentation for the complete list of run-time
configuration settings and how to set them on the command line or in
the configuration file.

Report bugs to <pgsql-bugs@lists.postgresql.org>.
PostgreSQL home page: <https://www.postgresql.org/>
Options (30)
OptionDescriptionSource
-B NBUFFERSnumber of shared buffershelp
-c NAME=VALUEset run-time parameterhelp
-C NAMEprint value of run-time parameter, then exithelp
-d 1-5debugging levelhelp
-D DATADIRdatabase directoryhelp
-euse European date input format (DMY)help
-Fturn fsync offhelp
-h HOSTNAMEhost name or IP address to listen onhelp
-ienable TCP/IP connections (deprecated)help
-k DIRECTORYUnix-domain socket locationhelp
-lenable SSL connectionshelp
-N MAX-CONNECTmaximum number of allowed connectionshelp
-p PORTport number to listen onhelp
-sshow statistics after each queryhelp
-S WORK-MEMset amount of memory for sorts (in kB)help
-V, --versionoutput version information, then exithelp
--NAME VALUEset run-time parameterhelp
--describe-configdescribe configuration parameters, then exithelp
-?, --helpshow this help, then exithelp
-Oallow system table structure changeshelp
-Pdisable system indexeshelp
-t pa|pl|exshow timings after each queryhelp
-Tsend SIGABRT to all backend processes if one dieshelp
-W NUMwait NUM seconds to allow attach from a debuggerhelp
--singleselects single-user mode (must be first argument)help
-Eecho statement before executionhelp
-jdo not use newline as interactive query delimiterhelp
-r FILENAMEsend stdout and stderr to given filehelp
--bootselects bootstrapping mode (must be first argument)help
--checkselects check mode (must be first argument)help

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