一尘不染

如何在Mac OS X上启动PostgreSQL server?

javascript

最终更新:

我忘记运行initdb命令了。


通过运行此命令

ps auxwww | grep 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

我仍然得到相同的“服务器正在运行吗?” 信息。


阅读 81

收藏
2022-07-14

共1个答案

一尘不染

如果要手动启动和停止 PostgreSQL(通过Homebrew安装),最简单的方法是:

brew services start postgresql

brew services stop postgresql

如果您有特定版本,请确保为该版本添加后缀。例如:

brew services start postgresql@10
2022-07-14