Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- vi /etc/postgresql/9.1/main/pg_hba.conf
- #
- # Database and user names containing spaces, commas, quotes and other
- # special characters must be quoted. Quoting one of the keywords
- # "all", "sameuser", "samerole" or "replication" makes the name lose
- # its special character, and just match a database or username with
- # that name.
- #
- # This file is read on server startup and when the postmaster receives
- # a SIGHUP signal. If you edit the file on a running system, you have
- # to SIGHUP the postmaster for the changes to take effect. You can
- # use "pg_ctl reload" to do that.
- # Put your actual configuration here
- # ----------------------------------
- #
- # If you want to allow non-local connections, you need to add more
- # "host" records. In that case you will also need to make PostgreSQL
- # listen on a non-local interface via the listen_addresses
- # configuration parameter, or via the -i or -h command line switches.
- # 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 access to all databases is required during automatic
- # maintenance (custom daily cronjobs, replication, and similar tasks).
- #
- # Database administrative login by Unix domain socket
- local all postgres peer
- # TYPE DATABASE USER ADDRESS METHOD
- # "local" is for Unix domain socket connections only
- local all all peer
- # IPv4 local connections:
- host all all 127.0.0.1/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 peer
- #host replication postgres 127.0.0.1/32 md5
- #host replication postgres ::1/128 md5
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement