pg_hba.conf

# PostgreSQL Client Authentication Configuration File
# ===================================================
#
# Refer to the "Client Authentication" section in the PostgreSQL
# documentation for a complete description of this file.

# TYPE  DATABASE        USER            ADDRESS                 METHOD

local   all             postgres                                ident

local   all             vagrant                                 ident

local   all             all                                     md5

host    all             all             127.0.0.1/32            md5

host    all             all             ::1/128                 md5

host    all             all             192.168.248.1/24        md5

# "local" is for Unix domain socket connections only
local   all             all                                     peer

postgresql.conf

# PostgreSQL configuration file
# This file was automatically generated and dropped off by chef!
# Please refer to the PostgreSQL documentation for details on
# configuration settings.

data_directory = '/var/lib/postgresql/9.3/main'
datestyle = 'iso, mdy'
default_text_search_config = 'pg_catalog.english'
external_pid_file = '/var/run/postgresql/9.3-main.pid'
hba_file = '/etc/postgresql/9.3/main/pg_hba.conf'
ident_file = '/etc/postgresql/9.3/main/pg_ident.conf'
listen_addresses = '*'
max_connections = 100
port = 5432
shared_buffers = '24MB'
ssl = on
ssl_cert_file = '/etc/ssl/certs/ssl-cert-snakeoil.pem'
ssl_key_file = '/etc/ssl/private/ssl-cert-snakeoil.key'
unix_socket_directories = '/var/run/postgresql'

# Temporary logging added by MMK
log_line_prefix = '%t %c %u %d ' # time sessionid user db
log_statement = 'all'