java mac postgresql_如何在Mac OS X上启动PostgreSQL服务器？ - How to start PostgreSQL server on Mac OS X?...

问题：

FINAL UPDATE: 最终更新：

I had forgotten to run the initdb command. 我忘了运行initdb命令。

< /FINAL UPDATE> FINAL UPDATE>

by running this command 通过运行此命令

ps auxwww | grep postgres

I see that postgres is not running 我看到postgres没有运行

> ps auxwww | grep postgres

remcat 1789 0.0 0.0 2434892 480 s000 R+ 11:28PM 0:00.00 grep postgres

this raises the question: How do I start the postgresql server? 这引出了一个问题：如何启动postgresql服务器？

update: 更新：

>pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start

server starting

sh: /usr/local/var/postgres/server.log: No such file or directory

update 2: 更新2：

The touch was not successful so I did this instead: 触摸不成功所以我这样做了：

> mkdir /usr/local/var/postgres

> vi /usr/local/var/postgres/server.log

> ls /usr/local/var/postgres/

server.log

But when I try to start rails server, I still see this: 但是当我尝试启动rails服务器时，我仍然看到：

Is the server running on host "localhost" and accepting

TCP/IP connections on port 5432?

update 3: 更新3：

> pg_ctl -D /usr/local/var/postgres status

pg_ctl: no server running

update 4: 更新4：

I found that there WAS NO pg_hba.conf (only pg_hba.conf.sample) so I modified the sample and renamed it (to remover the .sample). 我发现没有pg_hba.conf(只有pg_hba.conf.sample)所以我修改了样本并将其重命名(以移除.sample)。 Here are the contents: 以下是内容：

# IPv4 local connections:

host all all 127.0.0.1/32 trust

# IPv6 local connections:

host all all ::1/128 trust

but I don't understand this: 但我不明白这个：

> pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start

server starting

> pg_ctl -D /usr/local/var/postgres status

pg_ctl: no server running

also: 也：

sudo find / -name postgresql.conf

find: /dev/fd/3: Not a directory

find: /dev/fd/4: Not a directory

update 5: 更新5：

sudo pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start

Password:

pg_ctl: cannot be run as root

Please log in (using, e.g., "su") as the (unprivileged) user that will own the server process.

update 6: 更新6：

this seems odd: 这看起来很奇怪：

> egrep 'listen|port' /usr/local/var/postgres/postgresql.conf

egrep: /usr/local/var/postgres/postgresql.conf: No such file or directory

though, I did do this: 不过，我这样做了：

>sudo find / -name "*postgresql.conf*"

find: /dev/fd/3: Not a directory

find: /dev/fd/4: Not a directory

/usr/local/Cellar/postgresql/9.0.4/share/postgresql/postgresql.conf.sample

/usr/share/postgresql/postgresql.conf.sample

so I did this: 所以我这样做了：

egrep 'listen|port' /usr/local/Cellar/postgresql/9.0.4/share/postgresql/postgresql.conf.sample

#listen_addresses = 'localhost' # what IP address(es) to listen on;

#port = 5432 # (change requires restart)

# supported by the operating system:

# %r = remote host and port

so I tried this: 所以我试过这个：

> cp /usr/local/Cellar/postgresql/9.0.4/share/postgresql/postgresql.conf.sample /usr/local/Cellar/postgresql/9.0.4/share/postgresql/postgresql.conf

> cp /usr/share/postgresql/postgresql.conf.sample /usr/share/postgresql/postgresql.conf

still getting the same "Is the server running?" 仍然是相同的“服务器正在运行吗？” message. 信息。

解决方案：参考一：

https://stackoom.com/question/XSo0/如何在Mac-OS-X上启动PostgreSQL服务器

参考二：

https://oldbug.net/q/XSo0/How-to-start-PostgreSQL-server-on-Mac-OS-X