Revision 6195
Added by Aaron Marcuse-Kubitza about 12 years ago
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
schemas/postgresql.Mac.conf: Updated to PostgreSQL 9.1.6's postgresql.conf