postgresql远程连接报错psql.bin: FATAL: no pg_hba.conf entry for host "xxxx", user "postgres", database "xxxx", SSL off

 

postgresql远程连接报错

qsds@myhost:~> export PATH=$PATH:/data/10postgresql/9.6/bin
qsds@myhost:~> psql -p 5555 -h xxxx -U postgres qrdb
psql.bin: FATAL: no pg_hba.conf entry for host "xxxx", user "postgres", database "qrdb", SSL off

 

解决办法：

在pg_hba.conf添加

host     all             all             0.0.0.0/0               md5

1：如果data目录属主是postgres，切换用户后重启

myhost:/data/10postgresql/9.6/data # su - postgres

postgres@myhost:~/bin> pg_ctl restart -D /data/10postgresql/9.6/data/
waiting for server to shut down.... done
server stopped
server starting
postgres@myhost:~/bin> 2022-08-23 10:05:07 CST LOG: redirecting log output to logging collector process
2022-08-23 10:05:07 CST HINT: Future log output will appear in directory "pg_log".

postgres@myhost:~/bin>

 2：如果data目录不是，则需要先修改data文件夹属主和属组

myhost:/data/10postgresql/9.6 # chown -R postgres:postgres data
myhost:/data/10postgresql/9.6 # chmod -R 0700 data