PSQLException: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "ambari", database "ambari", SSL off
2023-09-11 14:18:41 时间
On your Postgres server, you will need to update your pg_hba.conf file to allow access for the ambari user on the ambari database coming from 127.0.0.1.
Here is the location of our pg_hba.conf file: /data/pghadoop/pg_hba.conf
If its not there, run: find / -name pg_hba.conf
Here is Postgres documentation for configuring this file: http://www.postgresql.org/docs/9.5/static/auth-pg-hba-conf.html
This is what our pg_hba.conf file has for the ambari user:(设置ambari用户的任何IP均有权限)
local all ambari trust host all ambari 0.0.0.0/0 trust host all ambari ::/0 trust
Once you have made these changes, you will need to restart the Postgres server:
/etc/init.d/postgresql restart
Let me know if you have any other questions.
https://community.hortonworks.com/questions/31673/psqlexception-fatal-no-pg-hbaconf-entry-for-host-1.html
相关文章
- mvc+entity framework database first,生成的model每次更新一个表会更新所有的model
- Do Visual Studio Database Project *.refactorlog Files Belong in Source Control?
- pip is configured with locations that require TLS/SSL, however the ssl module in Python is not avail
- 第八十六章 SQL命令 USE DATABASE
- Database JDBC Developer's Guide
- 【Database】MySQL各版本的区别
- 【Database】关于SQL Server
- Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Fail
- CREATE DATABASE - 创建新数据库
- PySe-016-Requests 访问 HTTPS 网站报错解决方法:SSLCertVerificationError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1056)
- Oracle Database 12c - Global Data Services
- 关于alter database open resetlogs及incarnation的一点理解
- 对PostgreSQL中tablespace 与 database, table的理解
- Oracle RAC Database 11.1.0.6监听故障案例
- 数据库中的Schema和Database的区别
- Database returned an invalid value in QuerySet.datetimes(). Are time zone definitions for your datab
- Beyond MySQL --Branching the popular database--转载
- The model backing the context has changed since the database was created.
- IIS 报错 Cannot open database "test4" requested by the login. The login failed. Login failed for user 'IIS APPPOOLtest1'.
- azkaban 报错:javax.net.ssl.SSLException: Unrecognized SSL message, plaintext connection?
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'