Project

General

Profile

« Previous | Next » 

Revision 6195

schemas/postgresql.Mac.conf: Updated to PostgreSQL 9.1.6's postgresql.conf

View differences:

postgresql.Mac.conf
62 62
					# (change requires restart)
63 63
#port = 5432				# (change requires restart)
64 64
max_connections = 100			# (change requires restart)
65
# Note:  Increasing max_connections costs ~400 bytes of shared memory per 
65
# Note:  Increasing max_connections costs ~400 bytes of shared memory per
66 66
# connection slot, plus lock space (see max_locks_per_transaction).
67 67
#superuser_reserved_connections = 3	# (change requires restart)
68
unix_socket_directory = '/tmp'		# (change requires restart)
69 68
#unix_socket_directory = ''		# (change requires restart)
70 69
#unix_socket_group = ''			# (change requires restart)
71 70
#unix_socket_permissions = 0777		# begin with 0 to use octal notation
......
78 77
# - Security and Authentication -
79 78

  
80 79
#authentication_timeout = 1min		# 1s-600s
81
ssl = off				# (change requires restart)
80
#ssl = off				# (change requires restart)
82 81
#ssl_ciphers = 'ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH'	# allowed SSL ciphers
83 82
					# (change requires restart)
84 83
#ssl_renegotiation_limit = 512MB	# amount of data between renegotiations
......
166 165
# <http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server#synchronous_commit>
167 166
#####
168 167
synchronous_commit = off		# immediate fsync at commit
169
#wal_sync_method = fsync		# the default is the first option 
168
#wal_sync_method = fsync		# the default is the first option
170 169
					# supported by the operating system:
171 170
					#   open_datasync
172 171
					#   fdatasync (default on Linux)
......
174 173
					#   fsync_writethrough
175 174
					#   open_sync
176 175
#full_page_writes = on			# recover from partial page writes
177
#wal_buffers = 64kB			# min 32kB
176
#wal_buffers = -1			# min 32kB, -1 sets based on shared_buffers
178 177
					# (change requires restart)
179 178
#wal_writer_delay = 200ms		# 1-10000 milliseconds
180 179

  
......
198 197
#archive_timeout = 0		# force a logfile segment switch after this
199 198
				# number of seconds; 0 disables
200 199

  
201
# - Streaming Replication -
202 200

  
201
#------------------------------------------------------------------------------
202
# REPLICATION
203
#------------------------------------------------------------------------------
204

  
205
# - Master Server -
206

  
207
# These settings are ignored on a standby server
208

  
203 209
#max_wal_senders = 0		# max number of walsender processes
204 210
				# (change requires restart)
205
#wal_sender_delay = 200ms	# walsender cycle time, 1-10000 milliseconds
211
#wal_sender_delay = 1s		# walsender cycle time, 1-10000 milliseconds
206 212
#wal_keep_segments = 0		# in logfile segments, 16MB each; 0 disables
207 213
#vacuum_defer_cleanup_age = 0	# number of xacts by which cleanup is delayed
214
#replication_timeout = 60s	# in milliseconds; 0 disables
215
#synchronous_standby_names = ''	# standby servers that provide sync rep
216
				# comma-separated list of application_name
217
				# from standby(s); '*' = all
208 218

  
209 219
# - Standby Servers -
210 220

  
221
# These settings are ignored on a master server
222

  
211 223
#hot_standby = off			# "on" allows queries during recovery
212 224
					# (change requires restart)
213 225
#max_standby_archive_delay = 30s	# max delay before canceling queries
......
216 228
#max_standby_streaming_delay = 30s	# max delay before canceling queries
217 229
					# when reading streaming WAL;
218 230
					# -1 allows indefinite delay
231
#wal_receiver_status_interval = 10s	# send replies at least this often
232
					# 0 disables
233
#hot_standby_feedback = off		# send info from standby to prevent
234
					# query conflicts
219 235

  
220 236

  
221 237
#------------------------------------------------------------------------------
......
261 277
#constraint_exclusion = partition	# on, off, or partition
262 278
#cursor_tuple_fraction = 0.1		# range 0.0-1.0
263 279
#from_collapse_limit = 8
264
#join_collapse_limit = 8		# 1 disables collapsing of explicit 
280
#join_collapse_limit = 8		# 1 disables collapsing of explicit
265 281
					# JOIN clauses
266 282

  
267 283

  
......
287 303
					# can be absolute or relative to PGDATA
288 304
#log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'	# log file name pattern,
289 305
					# can include strftime() escapes
290
#log_truncate_on_rotation = off		# If on, an existing log file of the
306
#log_file_mode = 0600			# creation mode for log files,
307
					# begin with 0 to use octal notation
308
#log_truncate_on_rotation = off		# If on, an existing log file with the
291 309
					# same name as the new log file will be
292 310
					# truncated rather than appended to.
293 311
					# But such truncation only occurs on
......
297 315
					# in all cases.
298 316
#log_rotation_age = 1d			# Automatic rotation of logfiles will
299 317
					# happen after that time.  0 disables.
300
#log_rotation_size = 10MB		# Automatic rotation of logfiles will 
318
#log_rotation_size = 10MB		# Automatic rotation of logfiles will
301 319
					# happen after that much log output.
302 320
					# 0 disables.
303 321

  
......
395 413
#log_temp_files = -1			# log temporary files equal or larger
396 414
					# than the specified size in kilobytes;
397 415
					# -1 disables, 0 logs all temp files
398
#log_timezone = unknown			# actually, defaults to TZ environment
399
					# setting
416
#log_timezone = '(defaults to server environment setting)'
400 417

  
401 418

  
402 419
#------------------------------------------------------------------------------
......
425 442
# AUTOVACUUM PARAMETERS
426 443
#------------------------------------------------------------------------------
427 444

  
428
#autovacuum = on			# Enable autovacuum subprocess?  'on' 
445
#autovacuum = on			# Enable autovacuum subprocess?  'on'
429 446
					# requires track_counts to also be on.
430 447
#log_autovacuum_min_duration = -1	# -1 disables, 0 logs all actions and
431 448
					# their durations, > 0 logs only
......
436 453
#autovacuum_naptime = 1min		# time between autovacuum runs
437 454
#autovacuum_vacuum_threshold = 50	# min number of row updates before
438 455
					# vacuum
439
#autovacuum_analyze_threshold = 50	# min number of row updates before 
456
#autovacuum_analyze_threshold = 50	# min number of row updates before
440 457
					# analyze
441 458
#autovacuum_vacuum_scale_factor = 0.2	# fraction of table size before vacuum
442 459
#autovacuum_analyze_scale_factor = 0.1	# fraction of table size before analyze
......
463 480
#check_function_bodies = on
464 481
#default_transaction_isolation = 'read committed'
465 482
#default_transaction_read_only = off
483
#default_transaction_deferrable = off
466 484
#session_replication_role = 'origin'
467 485
#statement_timeout = 0			# in milliseconds, 0 is disabled
468 486
#vacuum_freeze_min_age = 50000000
......
475 493

  
476 494
datestyle = 'iso, mdy'
477 495
#intervalstyle = 'postgres'
478
#timezone = unknown			# actually, defaults to TZ environment
479
					# setting
496
#timezone = '(defaults to server environment setting)'
480 497
#timezone_abbreviations = 'Default'     # Select the set of available time zone
481 498
					# abbreviations.  Currently, there are
482 499
					#   Default
......
514 531
# Note:  Each lock table slot uses ~270 bytes of shared memory, and there are
515 532
# max_locks_per_transaction * (max_connections + max_prepared_transactions)
516 533
# lock table slots.
534
#max_pred_locks_per_transaction = 64	# min 10
535
					# (change requires restart)
517 536

  
518

  
519 537
#------------------------------------------------------------------------------
520 538
# VERSION/PLATFORM COMPATIBILITY
521 539
#------------------------------------------------------------------------------
......
527 545
#default_with_oids = off
528 546
#escape_string_warning = on
529 547
#lo_compat_privileges = off
548
#quote_all_identifiers = off
530 549
#sql_inheritance = on
531
#standard_conforming_strings = off
550
#standard_conforming_strings = on
532 551
#synchronize_seqscans = on
533 552

  
534 553
# - Other Platforms and Clients -
......
537 556

  
538 557

  
539 558
#------------------------------------------------------------------------------
559
# ERROR HANDLING
560
#------------------------------------------------------------------------------
561

  
562
#exit_on_error = off				# terminate session on any error?
563
#restart_after_crash = on			# reinitialize after backend crash?
564

  
565

  
566
#------------------------------------------------------------------------------
540 567
# CUSTOMIZED OPTIONS
541 568
#------------------------------------------------------------------------------
542 569

  

Also available in: Unified diff