我无法在Mac OS X上重新启动postgres服务器。我该怎么解决?
尝试了两种方法:
使用pg_ctl restart命令,返回以下内容:
尝试了两种方法:
使用pg_ctl restart命令,返回以下内容:
pg_ctl: PID file "usr/local/var/postgres:/postmaster.pid" does not exist
Is server running?
starting server anyway
pg_ctl: could not read file "usr/local/var/postgres:/postmaster.opts"
服务器没有重新启动
执行pg_ctl -D /usr/local/var/postgres restart的结果是:
pg_ctl: PID file "/usr/local/var/postgres/postmaster.pid" does not exist
Is server running?
starting server anyway
server starting
LOG: could not bind IPv4 socket: Address already in use
HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
LOG: could not bind IPv6 socket: Address already in use
HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
WARNING: could not create listen socket for "*"
FATAL: could not create any TCP/IP sockets
ps aux | grep postgres
命令查找并杀死它们,然后尝试启动您的服务器。 - Hedde van der Heide