↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / 20devel
Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1
Historical version. PostgreSQL 8.1 has reached end of support. See the current manual.

17.16. Short Options

For convenience there are also single letter command-line option switches available for some parameters. They are described in Table 17-1.

Table 17-1. Short option key

Short optionEquivalent
-B xshared_buffers = x
-d xlog_min_messages = DEBUGx
-Ffsync = off
-h xlisten_addresses = x
-ilisten_addresses = '*'
-k xunix_socket_directory = x
-lssl = on
-N xmax_connections = x
-p xport = x
-fb, -fh, -fi, -fm, -fn, -fs, -ft[a] enable_bitmapscan = off, enable_hashjoin = off, enable_indexscan = off, enable_mergejoin = off, enable_nestloop = off, enable_seqscan = off, enable_tidscan = off
-s[a]log_statement_stats = on
-S x[a] work_mem = x
-tpa, -tpl, -te[a]log_parser_stats = on, log_planner_stats = on, log_executor_stats = on
Notes:
a. For historical reasons, these options must be passed to the individual server process via the -o postmaster option, for example,

$ postmaster -o '-S 1024 -s'

or via PGOPTIONS from the client side, as explained above.

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.