在 Mac 上使用 Homebrew 的 PostgreSQL

Question

首先我使用 homebrew 并安装 postgresql，然后我收到了这条成功消息:

==> Summary 🍺 /usr/local/Cellar/postgresql/9.2.2: 2819 files, 39M, built in 68 seconds

然后我需要运行这个命令:

initdb `brew --prefix`/var/postgres -E utf8

但这是我收到的消息:我该怎么办？同样在 OSX 10.8.2 上运行

The files belonging to this database system will be owned by user "JonyIve". This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8". The default text search configuration will be set to "english".

initdb: directory "/usr/local/var/postgres" exists but is not empty If you want to create a new database system, either remove or empty the directory "/usr/local/var/postgres" or run initdb with an argument other than "/usr/local/var/postgres".

Answer 1

假设这是一个新安装而不是重新安装，我认为解决您的问题很简单:

initdb `brew --prefix`/var/postgres/data -E utf8

通常，数据目录称为“数据”，位于 postgresql 主目录下。这允许共享日志文件访问等的可能性。