lamiastella

pg_hba.conf

Sep 6th, 2016
307
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. local all postgres peer
  2.  
  3. # TYPE DATABASE USER ADDRESS METHOD
  4.  
  5. # "local" is for Unix domain socket connections only
  6. local all all peer
  7. # IPv4 local connections:
  8. host all all 127.0.0.1/32 md5
  9. # IPv6 local connections:
  10. host all all ::1/128 md5
  11.  
  12. local xnat xnat01 localhost trust
  13.  
  14.  
  15. also 1234 worked when asked for password here:
  16. $ sudo -i -u postgres
  17. postgres@klein:~$ psql -h localhost -t -P format=unaligned -c 'show hba_file';
  18. Password:
  19. /etc/postgresql/9.4/main/pg_hba.conf
  20. postgres@klein:~$ vi /etc/postgresql/9.4/main/pg_hba.conf
Advertisement
Add Comment
Please, Sign In to add comment