8000 Added replica confs · pct960/postgres@6ca8c10 · GitHub
[go: up one dir, main page]
Skip to content

Commit 6ca8c10

Browse files
pct960pct960
committed
Added replica confs
1 parent 564d98b commit 6ca8c10

File tree

2 files changed

+21
-21
lines changed

2 files changed

+21
-21
lines changed

‎postgresql.conf.replica1

Lines changed: 10 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -441,22 +441,22 @@ hot_standby = on # "off" disallows queries during recovery
441441

442442
# - Where to Log -
443443

444-
#log_destination = 'stderr' # Valid values are combinations of
444+
log_destination = 'stderr' # Valid values are combinations of
445445
# stderr, csvlog, jsonlog, syslog, and
446446
# eventlog, depending on platform.
447447
# csvlog and jsonlog require
448448
# logging_collector to be on.
449449

450450
# This is used when logging to stderr:
451-
#logging_collector = off # Enable capturing of stderr, jsonlog,
451+
logging_collector = on # Enable capturing of stderr, jsonlog,
452452
# and csvlog into log files. Required
453453
# to be on for csvlogs and jsonlogs.
454454
# (change requires restart)
455455

456456
# These are only used if logging_collector is on:
457457
#log_directory = 'log' # directory where log files are written,
458458
# can be absolute or relative to PGDATA
459-
#log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name pattern,
459+
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name pattern,
460460
# can include strftime() escapes
461461
#log_file_mode = 0600 # creation mode for log files,
462462
# begin with 0 to use octal notation
@@ -486,7 +486,7 @@ hot_standby = on # "off" disallows queries during recovery
486486

487487
# - When to Log -
488488

489-
#log_min_messages = warning # values in order of decreasing detail:
489+
log_min_messages = info # values in order of decreasing detail:
490490
# debug5
491491
# debug4
492492
# debug3
@@ -530,7 +530,7 @@ hot_standby = on # "off" disallows queries during recovery
530530
# 1.0 logs all such statements, 0.0 never logs
531531

532532

533-
#log_transaction_sample_rate = 0.0 # fraction of transactions whose statements
533+
log_transaction_sample_rate = 1.0 # fraction of transactions whose statements
534534
# are logged regardless of their duration; 1.0 logs all
535535
# statements from all transactions, 0.0 never logs
536536

@@ -544,17 +544,17 @@ hot_standby = on # "off" disallows queries during recovery
544544
#debug_print_parse = off
545545
#debug_print_rewritten = off
546546
#debug_print_plan = off
547-
#debug_pretty_print = on
547+
debug_pretty_print = on
548548
#log_autovacuum_min_duration = 10min # log autovacuum activity;
549549
# -1 disables, 0 logs all actions and
550550
# their durations, > 0 logs only
551551
# actions running at least this number
552552
# of milliseconds.
553553
#log_checkpoints = on
554-
#log_connections = off
555-
#log_disconnections = off
556-
#log_duration = off
557-
#log_error_verbosity = default # terse, default, or verbose messages
554+
log_connections = on
555+
log_disconnections = on
556+
log_duration = on
557+
log_error_verbosity = verbose # terse, default, or verbose messages
558558
#log_hostname = off
559559
#log_line_prefix = '%m [%p] ' # special values:
560560
# %a = application name

‎postgresql.conf.replica2

Lines changed: 11 additions & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -441,22 +441,22 @@ hot_standby = on # "off" disallows queries during recovery
441441

442442
# - Where to Log -
443443

444-
#log_destination = 'stderr' # Valid values are combinations of
444+
log_destination = 'stderr' # Valid values are combinations of
445445
# stderr, csvlog, jsonlog, syslog, and
446446
# eventlog, depending on platform.
447447
# csvlog and jsonlog require
448448
# logging_collector to be on.
449449

450450
# This is used when logging to stderr:
451-
#logging_collector = off # Enable capturing of stderr, jsonlog,
451+
logging_collector = on # Enable capturing of stderr, jsonlog,
452452
# and csvlog into log files. Required
453453
# to be on for csvlogs and jsonlogs.
454454
# (change requires restart)
455455

456456
# These are only used if logging_collector is on:
457457
#log_directory = 'log' # directory where log files are written,
458458
# can be absolute or relative to PGDATA
459-
#log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name pattern,
459+
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name pattern,
460460
# can include strftime() escapes
461461
#log_file_mode = 0600 # creation mode for log files,
462462
# begin with 0 to use octal notation
@@ -486,7 +486,7 @@ hot_standby = on # "off" disallows queries during recovery
486486

487487
# - When to Log -
488488

489-
#log_min_messages = warning # values in order of decreasing detail:
489+
log_min_messages = info # values in order of decreasing detail:
490490
# debug5
491491
# debug4
492492
# debug3
@@ -530,7 +530,7 @@ hot_standby = on # "off" disallows queries during recovery
530530
# 1.0 logs all such statements, 0.0 never logs
531531

532532

533-
#log_transaction_sample_rate = 0.0 # fraction of transactions whose statements
533+
log_transaction_sample_rate = 1.0 # fraction of transactions whose statements
534534
# are logged regardless of their duration; 1.0 logs all
535535
# statements from all transactions, 0.0 never logs
536536

@@ -544,17 +544,17 @@ hot_standby = on # "off" disallows queries during recovery
544544
#debug_print_parse = off
545545
#debug_print_rewritten = off
546546
#debug_print_plan = off
547-
#debug_pretty_print = on
547+
debug_pretty_print = on
548548
#log_autovacuum_min_duration = 10min # log autovacuum activity;
549549
# -1 disables, 0 logs all actions and
550550
# their durations, > 0 logs only
551551
# actions running at least this number
552552
# of milliseconds.
553-
#log_checkpoints = on
554-
#log_connections = off
555-
#log_disconnections = off
556-
#log_duration = off
557-
#log_error_verbosity = default # terse, default, or verbose messages
553+
log_checkpoints = on
554+
log_connections = on
555+
log_disconnections = on
556+
log_duration = on
557+
log_error_verbosity = verbose # terse, default, or verbose messages
558558
#log_hostname = off
559559
#log_line_prefix = '%m [%p] ' # special values:
560560
# %a = application name

0 commit comments

Comments
 (0)
0