Created
April 10, 2018 19:15
-
-
Save Franckapik/c0cc7016f1214cadf88303ca740489c5 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| sudo cat /var/log/postgresql/postgresql-9.6-main.log | |
| 2018-04-10 20:34:07.859 CEST [14513] LOG: masque IP « md5 » invalide : Nom ou service inconnu | |
| 2018-04-10 20:34:07.859 CEST [14513] CONTEXTE : ligne 102 du fichier de configuration « /etc/postgresql/9.6/main/pg_hba.conf » | |
| 2018-04-10 20:34:07.860 CEST [14513] FATAL: n'a pas pu charger pg_hba.conf | |
| 2018-04-10 20:34:07.862 CEST [14513] LOG: le système de base de données est arrêté | |
| 2018-04-10 20:53:08.809 CEST [15698] LOG: masque IP « md5 » invalide : Nom ou service inconnu | |
| 2018-04-10 20:53:08.809 CEST [15698] CONTEXTE : ligne 102 du fichier de configuration « /etc/postgresql/9.6/main/pg_hba.conf » |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
hba_conf :
Database administrative login by Unix domain socket
local all postgres peer
TYPE DATABASE USER ADDRESS METHOD
"local" is for Unix domain socket connections only
local all all peer
IPv4 local connections:
host all all 127.0.0.1/32 md5
IPv6 local connections:
host all all ::1/128 md5
Allow replication connections from localhost, by a user with the
replication privilege.
#local replication postgres peer
#host replication postgres 127.0.0.1/32 md5
#host replication postgres ::1/128 md5
#host all all 188.224.6.181 md5
hostssl all all 188.224.6.181 md5