EverKB

Knowledge Base Ever

Konfigurirajte PostgreSQL12, da omogočite daljinsko spremljanje

2019-12-19 09:35:00

Oznaka: PostgreSQL,pg_bha.conf,

Kaj je PostgreSQL?

PostgreSQL je močan odprtokodni objektno usmerjeni sistem baz podatkov, ki izvira iz projekta POSTGRES kalifornijske univerze v Berkeleyju leta 1986. Ta projekt ima več kot 30 let zgodovine razvoja.
Ko je PostgreSQL nameščen, bo neposredna povezava pozvala FATAL:no pg_hba.conf entry for host "192.168.0.2",user "postgres",database "postgres",SSL off, kar pomeni: resna napaka, pg_hba.conf nima vnosa gostitelja, uporabnik postgres, baza podatkov je postgres in SSL ni omogočen.

Lokacija datoteke pg_hba.conf je odvisna od platforme in je običajno v podatkovnem imeniku.

vim path_of_yours/data/pg_hba.conf

host    all             all             0.0.0.0/0               trust

Učinkovito po ponovnem zagonu storitve

systemctl restart postgresql

Oznaka

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