postgres初始化数据库

最新推荐文章于 2025-06-10 17:14:19 发布

转载最新推荐文章于 2025-06-10 17:14:19 发布 · 2.8k 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://juejin.im/post/5b2cae02e51d45587c51c889

文章标签：

#数据库

本文介绍如何使用initdb命令初始化PostgreSQL数据库目录，并提供了一个简单的示例。此外，还提供了initdb命令的详细选项说明，包括设置默认编码、认证方式等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

使用initdb将一个目录初始化为postgres的数据库目录

postgres@me:/usr/local/pgsql$ ./bin/initdb --help
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
      --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

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.

复制代码

最简单的示例(使用-D来将一个文件夹初始化为数据库文件夹):

postgres@me:/usr/local/pgsql$ ./bin/initdb -D ./data
复制代码

初始化完成了并且还提示我们使用./bin/pg_ctl -D ./data/ -l logfile start这个命令来启动数据库服务器

转载于:https://juejin.im/post/5b2cae02e51d45587c51c889