Created
October 6, 2012 02:31
-
-
Save coderforhire/3843512 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/etc/postgresql/9.1/main/pg_hba.conf | |
# 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 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/etc/postgresql/9.1/main/postgresql.conf | |
#------------------------------------------------------------------------------ | |
# CONNECTIONS AND AUTHENTICATION | |
#------------------------------------------------------------------------------ | |
# - Connection Settings - | |
#listen_addresses = 'localhost' # what IP address(es) to listen on; | |
# comma-separated list of addresses; | |
# defaults to 'localhost', '*' = all | |
# (change requires restart) | |
port = 5432 # (change requires restart) | |
max_connections = 100 # (change requires restart) | |
# Note: Increasing max_connections costs ~400 bytes of shared memory per | |
# connection slot, plus lock space (see max_locks_per_transaction). | |
#superuser_reserved_connections = 3 # (change requires restart) | |
unix_socket_directory = '/var/run/postgresql' # (change requires restart) | |
#unix_socket_group = '' # (change requires restart) | |
#unix_socket_permissions = 0777 # begin with 0 to use octal notation | |
# (change requires restart) | |
#bonjour = off # advertise server via Bonjour | |
# (change requires restart) | |
#bonjour_name = '' # defaults to the computer name | |
# (change requires restart) | |
# - Security and Authentication - | |
#authentication_timeout = 1min # 1s-600s | |
ssl = true # (change requires restart) | |
#ssl_ciphers = 'ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH' # allowed SSL ciphers | |
# (change requires restart) | |
#ssl_renegotiation_limit = 512MB # amount of data between renegotiations | |
#password_encryption = on | |
#db_user_namespace = off | |
# Kerberos and GSSAPI | |
#krb_server_keyfile = '' | |
#krb_srvname = 'postgres' # (Kerberos only) | |
#krb_caseins_users = off | |
# - TCP Keepalives - | |
# see "man 7 tcp" for details | |
#tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds; | |
# 0 selects the system default | |
#tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds; | |
# 0 selects the system default | |
#tcp_keepalives_count = 0 # TCP_KEEPCNT; | |
# 0 selects the system default |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment