initdb
Table of Contents
initdb
Return to PostgreSQL or PostgreSQL CLI commands
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
--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
Less commonly used options
- -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
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.
initdb.txt · Last modified: 2024/04/28 03:19 by 127.0.0.1