Pg hba.conf

De BrapciWiki
Revisão de 21h13min de 5 de outubro de 2021 por Renefgj (discussão | contribs) (Criou página com '# DO NOT DISABLE! # If you change this first entry you will need to make sure that the # database superuser can access the database using some other method. # Noninteractive a...')
(dif) ← Edição anterior | Revisão atual (dif) | Versão posterior → (dif)
Ir para navegação Ir para pesquisar
  1. DO NOT DISABLE!
  2. If you change this first entry you will need to make sure that the
  3. database superuser can access the database using some other method.
  4. Noninteractive access to all databases is required during automatic
  5. maintenance (custom daily cronjobs, replication, and similar tasks).
  6. Database administrative login by Unix domain socket

local all postgres peer

  1. TYPE DATABASE USER ADDRESS METHOD
  1. "local" is for Unix domain socket connections only

local all all peer

  1. IPv4 local connections:

host all all 127.0.0.1/32 trust

  1. IPv6 local connections:

host all all ::1/128 trust

  1. Allow replication connections from localhost, by a user with the
  2. replication privilege.
  3. local replication all peer
  4. host replication all 127.0.0.1/32 md5
  5. host replication all ::1/128 md5