EverKB

Knowledge Base Ever

Konfigurirajte PostgreSQL12 kako biste omogućili daljinsko nadgledanje

2019-12-19 09:35:00

oznaka: PostgreSQL,pg_bha.conf,

Što je PostgreSQL?

PostgreSQL je moćan objektno orijentirani podatkovni sustav otvorenog koda, nastao iz projekta POSTGRES Sveučilišta u Berkeleyu u Kaliforniji 1986. Ovaj projekt ima više od 30 godina povijesti razvoja.
Kada je PostgreSQL instaliran, izravna veza će zatražiti FATAL:no pg_hba.conf entry for host "192.168.0.2",user "postgres",database "postgres",SSL off, što znači: ozbiljna greška, pg_hba.conf nema unos domaćina, korisnik postgres, baza podataka je postgres, a SSL nije omogućen.

Lokacija datoteke pg_hba.conf ovisi o platformi i obično se nalazi u direktoriju podataka.

vim path_of_yours/data/pg_hba.conf

host    all             all             0.0.0.0/0               trust

Na snazi ​​je nakon ponovnog pokretanja usluge

systemctl restart postgresql

oznaka

CentOS7 CentOS PHP Linux Python Python3 MySQL MariaDB YUM JavaScript HTML mysql_native_password PHP7 CSS Redis MySQL8 caching_sha2_password width DATE_ADD ip command pg_bha.conf SQL Server Tcp BBR Compiling Apache Frameworks MySQL-python scrollbar Apache2.4 Elasticsearch libpython3.7m.so.1.0 PHPStorm ss5-3.8.9 VIM CURLOPT_POSTFIELDS NodeJs show substr Bluetooth Failed to build these modules: _ctypes Minimal ISO Wi-Fi date sub INTERVAL PECL SQL Date Funcitons Tag Cloud CodeIgniter font-size root apache httpd dual network interfaces Laravel ss5 vertical-align CURLFille horiz-align node.js ShadowsocksR SUBDATE BarManager exec mb_substr PyCharm WebStorm date add IntelliJIDEA PEAR SOCKS5 Proxy Server Tag Chrome find remi Apache du jQuery PHP5.5 src V2Ray cURL hide nginx Shadowsocks-Python availability eth0 MariaDB10.4 PostgreSQL sub folder Web Server date Install MongoDB pdo_sqlsrv SOCKS5 Symfony File Upload mssql-tools register_shutdown_function Zend Framework ADDDATE DevExpress JetBrain php-fpm sqlsrv unixODBC-devel height network interface Shadowsocks-Libev Aura error_get_last Port 80 string Web Development data INDENTIFIED BY password policy requirements SOCKS SVN Fedora Media Writer msodbcsql Redis5 absolute Deepin jemalloc SQLAlchemy toggle convert FuelPHP mysqlclient Shadowsocks at-symbol Error Control Operator margin PHPUnit Framework ss5.passwd vps daemon process IIS password SOCKET sudoers center Fatal Errors MongoDB4 WiFi .htaccess DATE_SUB Phalcon SQL Server 2017 TestCase Compiling PHP frequency conflict set_error_handler apr Elasticsearch7.3 PHPUnit ss5.conf Vincent Garreau daemon HTTP particles.js Slim Sudo Failed to build these modules: _uuid MongoDB