- bash-4.1$ psql
psql: 无法联接到服务器: 没有那个文件或目录
服务器是否在本地运行并且在 Unix 域套接字
"/var/run/postgresql/.s.PGSQL.5432"上准备接受联接?
(psql: could not connect to server: 没有那个文件或目录
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?)
问题原因：postgresql service stop
解决方法：service postgresql-9.6 start
- psql: could not connect to server: Connection refused
Is the server running on host "192.168.1.232" and accepting
TCP/IP connections on port 5432?
解决方法：
#vi postgresql.conf
修改
#listen_addresses = 'localhost'
为
listen_addresses = '*'
- psql: FATAL: no pg_hba.conf entry for host "192.168.1.223", user "test", database "test", SSL off
解决方法：
#vi pg_hba.conf
添加
local database user password
host database user 0.0.0.0/0 password
host database user ::1/0 password
- pg_ctl: directory "/home/postgres/pgdata" is not a database cluster directory
./bin/initdb -D ~/pgdata/
- ERROR: permission denied for relation #{table_name}
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO #{table_user};
