postgresql 无法启动 Postgres
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/8327680/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Can't get Postgres started
提问by fivetwentysix
brew install postgresql
brew 安装 postgresql
Initialize...
初始化...
[~] initdb
The files belonging to this database system will be owned by user "pma".
This user must also own the server process.
The database cluster will be initialized with locales
COLLATE: C
CTYPE: UTF-8
MESSAGES: C
MONETARY: C
NUMERIC: C
TIME: C
The default database encoding has accordingly been set to UTF8.
initdb: could not find suitable text search configuration for locale UTF-8
The default text search configuration will be set to "simple".
creating directory /Users/pma/.pgdata ... ok
creating subdirectories ... ok
selecting default max_connections ... 20
selecting default shared_buffers ... 1600kB
creating configuration files ... ok
creating template1 database in /Users/pma/.pgdata/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating collations ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
loading PL/pgSQL server-side language ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok
WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the -A option the
next time you run initdb.
Success. You can now start the database server using:
postgres -D /Users/pma/.pgdata
or
pg_ctl -D /Users/pma/.pgdata -l logfile start
Start...
开始...
[~] pg_ctl start
server starting
[~] LOG: database system was shut down at 2011-11-30 22:41:57 HKT
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
So far so good... Createdb....
到目前为止一切顺利... Createdb ....
[~] createdb test
createdb: could not connect to database postgres: could not connect to server: Permission denied
Is the server running locally and accepting
connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?
... now what?
... 怎么办？
回答by wildplasser
Could be the unixdomain socket is located somewhere else, eg /tmp
可能是 unixdomain 套接字位于其他地方，例如 /tmp
Try using a -h flag with either localhost or /tmp :
尝试在 localhost 或 /tmp 中使用 -h 标志：
- createdb -h localhost test, or
- createdb -h /tmp test
- createdb -h localhost 测试，或
- createdb -h /tmp 测试
(the -h / --hostname flag normally takes a hostname as argument, but it will accept a directoryname too, specifying the location of the unix-domain socket)
（-h / --hostname 标志通常将主机名作为参数，但它也会接受目录名，指定 unix 域套接字的位置）
回答by Tao Starbow
Note for installing postgres with brew on mountain lion in June 2015: plsq and createdb are looking for the socket in /var/pgsql_socket, but postgres is creating it in /tmp. "plsq -h localhost" works fine, but to make a permanent fix:
2015 年 6 月在山狮上使用 brew 安装 postgres 的注意事项：plsq 和 createdb 正在 /var/pgsql_socket 中寻找套接字，但 postgres 正在 /tmp 中创建它。“plsq -h localhost”工作正常，但要进行永久修复：
sudo mkdir /var/pgsql_socket
sudo chown <user> /var/pgsql_socket
sudo mkdir /var/pgsql_socket
sudo chown <user> /var/pgsql_socket
Then edit /usr/local/var/postgres/postgresql.conf, and set unix_socket_directories = '/var/pgsql_socket'
然后编辑/usr/local/var/postgres/postgresql.conf，并设置unix_socket_directories = '/var/pgsql_socket'
回答by heldt
Do you have the right permissions for you user to create a database? If not you can create/alter user by:
您是否拥有用户创建数据库的正确权限？如果没有，您可以通过以下方式创建/更改用户：
Create user
创建用户
> su postgres
> createuser
... Set user permission.
Also check your pg_hba.conf that you have the right permissions for your user.
还要检查您的 pg_hba.conf 是否对您的用户具有正确的权限。
