我忘记运行initdb命令了。
initdb
通过运行此命令
ps auxwww | grep postgres
我看到它postgres没有运行
postgres
> ps auxwww | grep postgres remcat 1789 0.0 0.0 2434892 480 s000 R+ 11:28PM 0:00.00 grep postgres
这就提出了一个问题:
如何启动 PostgreSQL 服务器?
更新:
> 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
更新 2:
触摸不成功,所以我这样做了:
> mkdir /usr/local/var/postgres > vi /usr/local/var/postgres/server.log > ls /usr/local/var/postgres/ server.log
但是当我尝试启动 Ruby on Rails 服务器时,我仍然看到:
服务器是否在主机“localhost”上运行并接受端口 5432 上的 TCP/IP 连接?
更新 3:
> pg_ctl -D /usr/local/var/postgres status pg_ctl: no server running
更新 4:
我发现没有任何 pg_hba.conf文件(只有文件pg_hba.conf.sample),所以我修改了示例并将其重命名(以删除 .sample)。以下是内容:
# IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: host all all ::1/128 trust
但我不明白这一点:
> 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
还:
sudo find / -name postgresql.conf find: /dev/fd/3: Not a directory find: /dev/fd/4: Not a directory
更新 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.
更新 6:
这似乎很奇怪:
> egrep 'listen|port' /usr/local/var/postgres/postgresql.conf egrep: /usr/local/var/postgres/postgresql.conf: No such file or directory
虽然,我确实这样做了:
>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
所以我这样做了:
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
所以我尝试了这个:
> 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
我仍然得到相同的“服务器正在运行吗?” 信息。
如果要手动启动和停止 PostgreSQL(通过Homebrew安装),最简单的方法是:
brew services start postgresql
和
brew services stop postgresql
如果您有特定版本,请确保为该版本添加后缀。例如:
brew services start postgresql@10