Pg hba.conf

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).
7. 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