# (change requires restart)

# If external_pid_file is not explicitly set, no extra PID file is written.

					# (change requires restart)

listen_addresses = '*'		# what IP address(es) to listen on;

					# comma-separated list of addresses;

					# (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_group = ''			# (change requires restart)

#unix_socket_permissions = 0777		# begin with 0 to use octal notation

					# (change requires restart)

#authentication_timeout = 1min		# 1s-600s

#ssl = off				# (change requires restart)

					# (change requires restart)

#ssl_renegotiation_limit = 512MB	# amount of data between renegotiations

#password_encryption = on

#db_user_namespace = off

# Set to slightly less than SHMMAX = 1.4GB

shared_buffers = 1400MB			# min 128kB

					# (change requires restart)

#temp_buffers = 8MB			# min 800kB

#max_prepared_transactions = 0		# zero disables the feature

#maintenance_work_mem = 16MB		# min 1MB

#max_stack_depth = 2MB			# min 100kB

# - Kernel Resource Usage -

#max_files_per_process = 1000		# min 25

# - Cost-Based Vacuum Delay -

#vacuum_cost_page_hit = 1		# 0-10000 credits

#vacuum_cost_page_miss = 10		# 0-10000 credits

#vacuum_cost_page_dirty = 20		# 0-10000 credits

# - Asynchronous Behavior -

#------------------------------------------------------------------------------

# <http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server#synchronous_commit>

#####

synchronous_commit = off		# immediate fsync at commit

#wal_sync_method = fsync		# the default is the first option

					# supported by the operating system:

					#   open_datasync

checkpoint_segments = 32		# in logfile segments, min 1, 16MB each

#checkpoint_segments = 3		# in logfile segments, min 1, 16MB each

#checkpoint_timeout = 5min		# range 30s-1h

#checkpoint_completion_target = 0.5	# checkpoint target duration, 0.0 - 1.0

#checkpoint_warning = 30s		# 0 disables

#archive_mode = off		# allows archiving to be done

				# (change requires restart)

#archive_command = ''		# command to use to archive a logfile segment

#archive_timeout = 0		# force a logfile segment switch after this

				# number of seconds; 0 disables

# REPLICATION

#------------------------------------------------------------------------------

#max_wal_senders = 0		# max number of walsender processes

				# (change requires restart)

#wal_keep_segments = 0		# in logfile segments, 16MB each; 0 disables

#synchronous_standby_names = ''	# standby servers that provide sync rep

				# comma-separated list of application_name

				# from standby(s); '*' = all

# - Standby Servers -

#hot_standby = off			# "on" allows queries during recovery

					# (change requires restart)

					# 0 disables

#hot_standby_feedback = off		# send info from standby to prevent

					# query conflicts

#------------------------------------------------------------------------------

#enable_hashagg = on

#enable_hashjoin = on

#enable_indexscan = on

#enable_material = on

#enable_mergejoin = on

#enable_nestloop = on

# - Where to Log -

					# stderr, csvlog, syslog, and eventlog,

					# depending on platform.  csvlog

					# requires logging_collector to be on.

# This is used when logging to stderr:

					# into log files. Required to be on for

					# csvlogs.

					# (change requires restart)

#syslog_facility = 'LOCAL0'

#syslog_ident = 'postgres'

# - When to Log -

#client_min_messages = notice		# values in order of decreasing detail:

#log_duration = off

#log_error_verbosity = default		# terse, default, or verbose messages

#log_hostname = off

					#   %a = application name

					#   %u = user name

					#   %d = database name

#log_temp_files = -1			# log temporary files equal or larger

					# than the specified size in kilobytes;

					# -1 disables, 0 logs all temp files

#------------------------------------------------------------------------------

#track_activities = on

#track_counts = on

#track_functions = none			# none, pl, all

#track_activity_query_size = 1024 	# (change requires restart)

#update_process_title = on

#autovacuum = on			# Enable autovacuum subprocess?  'on'

					# requires track_counts to also be on.

log_autovacuum_min_duration = 0	# -1 disables, 0 logs all actions and

					# their durations, > 0 logs only

					# actions running at least this number

					# of milliseconds.

#default_transaction_deferrable = off

#session_replication_role = 'origin'

#statement_timeout = 0			# in milliseconds, 0 is disabled

#vacuum_freeze_min_age = 50000000

#vacuum_freeze_table_age = 150000000

#bytea_output = 'hex'			# hex, escape

datestyle = 'iso, mdy'

#intervalstyle = 'postgres'

#timezone_abbreviations = 'Default'     # Select the set of available time zone

					# abbreviations.  Currently, there are

					#   Default

					# encoding

# These settings are initialized by initdb, but they can be changed.

					# strings

# default configuration for text search

default_text_search_config = 'pg_catalog.english'

#max_pred_locks_per_transaction = 64	# min 10

					# (change requires restart)

#------------------------------------------------------------------------------

# VERSION/PLATFORM COMPATIBILITY

#------------------------------------------------------------------------------

# ERROR HANDLING

#------------------------------------------------------------------------------

#------------------------------------------------------------------------------

# CUSTOMIZED OPTIONS

#------------------------------------------------------------------------------

# listen on a non-local interface via the listen_addresses

# configuration parameter, or via the -i or -h command line switches.

# Database administrative login by UNIX sockets

host    all         postgres    127.0.0.1/32          md5

host    all         postgres    ::1/128               md5

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only

# IPv4 local connections:

# IPv6 local connections:

# Allow replication connections from localhost, by a user with the

# replication privilege.

local   template1,vegbien  public_           trust

host    template1,vegbien  public_ 0.0.0.0/0 trust

remote := $(remote_user)@$(remote_host):$(remote_basepath)/$(localDirName)/

# DB

asAdmin := sudo -E -u $(postgres)

psqlOpts := --set ON_ERROR_STOP=1 --quiet

psqlAsAdmin := $(asAdmin) psql -U postgres $(psqlOpts)

asBien := sudo -E -u bien

pgVersion = "$$(env minor=1 bin/pg_version)"

define pg_ctl-Linux

$(asAdmin) /etc/init.d/postgresql $(1)

endef

define macUsePostgresLib

sudo mv $(libDest) $(libDest).old||sudo rm -f $(libDest)

sudo ln -s $(macPostgresDir)/lib/$(1) $(libDest)

macPostgresLibs := $(macPostgresLibs:%=%.dylib)

define pg_ctl-Darwin

sleep 2

endef