# local all postgres trust # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: host all all ::1/128 trust # Passwored hosts host all all 0.0.0.0/0 password # md5 hosts host all all 0.0.0.0/0 md5 # Trusted hosts # User custom # User custom, group based # e.g. { type: host, database: replication, user: postgres, groups: ["cl_postgres-master", "cl_postgres-standby"], method: 'trust', comment: 'replication connections allowed from slaves' } ### replication connections allowed from slaves - cl_pg-audit-trail02-master host replication postgres trust ### replication connections allowed from slaves - cl_pg-audit-trail02-slave host replication postgres trust ### all connections allowed from pgpool cluster - cl_pgpool-audit-trail02 host all all trust host all all trust