Postgres数据库本地安装/运行

Question

$ createdb geo
createdb: could not connect to database postgres: could not connect to server: No such file or directory
    Is the server running locally and accepting
    connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?

$ postgres -D /usr/local/var/postgres
FATAL:  lock file "postmaster.pid" already exists
HINT:  Is another postmaster (PID 221) running in data directory "/usr/local/var/postgres"?

$ pg_ctl -D /usr/local/var/postgres -l logfile start
pg_ctl: another server might be running; trying to start server anyway
server starting

$ kill -9 221
$ pg_ctl -D /usr/local/var/postgres stop
waiting for server to shut down.... done
server stopped

$ pg_ctl -D /usr/local/var/postgres start
pg_ctl: another server might be running; trying to start server anyway
server starting
FATAL:  lock file "postmaster.pid" already exists
HINT:  Is another postmaster (PID 1436) running in data directory "/usr/local/var/postgres"?

另一个尝试：

$ cd /usr/local/var/postgres
$ mv postmaster.pid postmaster.backup
$ pg_ctl -D /usr/local/var/postgres start
server starting

$ 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.
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 "localhost"
FATAL:  could not create any TCP/IP sockets

有没有人用美洲狮成功做到这一点？如果是的话，我错过了什么？感谢您对此问题的帮助！

Answer 1

此消息：

createdb：无法连接到数据库postgres：无法连接到服务器：没有这样的文件或目录是本地运行并接受Unix域套接字“/var/pgsql_socket/.s.pgsql.5432”上的连接的服务器吗？

指示PostgreSQL服务器不使用/var/pgsql_socket作为其Unix域套接字目录，该目录是服务器和客户端之间的会合点。这是很常见的，因为只有Apple随OSX服务器提供的PostgreSQL才使用该路径。顺便提一下，这就是为什么Apple提供的createdb命令尝试连接到Apple配置的服务器。

如果使用brew，我建议应用superuser.com上的答案：我应该如何在我的Mac上设置PATH变量，以便找到Hombrew安装的工具？

您提到的postgres+postgis教程的作者很久以前就改变了它的path并且忘记在他的文章中提到它了。

完成后，createdb命令应该返回/usr/local/bin/psql这是自制版本，而不是最初的/usr/bin/psql这是Apple版本。