Hi, OK, I found it under the root account. Now I am modifying it as follows: # TYPE DATABASE USER ADDRESS METHOD # "local" is for Unix domain socket connections only local all all md5 # IPv4 local connections: host all all 192.168.1.3/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 md5 #host replication postgres 127.0.0.1/32 md5 #host replication postgres ::1/128 md5 Should "METHOD" column be lept as 'md5' or as 'trusted' as in the link I posted in the OP? Thank you. On Sun, Aug 13, 2017 at 10:37 AM, Christoph Berg <myon@xxxxxxxxxx> wrote: > Re: Igor Korot 2017-08-13 <CA+FnnTz8h-2tkRMv4uYN-fkRFU601cws9-uS7vwfpr-fka0edg@xxxxxxxxxxxxxx> >> draft=# SHOW hba_file >> draft-# SHOW hba_file; >> ERROR: syntax error at or near "SHOW" >> LINE 2: SHOW hba_file; >> ^ > > Standard beginners error. If you forgot the ";" on the first line, > it'll process both lines as a single, erroneous command. Note the > "-#" prompt. > > If you run into that situation again, hit ^C. > > Christoph -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
