Return to PostgreSQL or PostgreSQL CLI commands

initdb --help

initdb initializes a PostgreSQL database cluster.

initdb [OPTION]… [DATADIR]

• -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

       --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
       --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

• -d, –debug generate lots of debugging output

• -k, –data-checksums use data page checksums

• -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

• -s, –show show internal settings

• -S, –sync-only only sync data directory

• -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.