diff options
Diffstat (limited to 'zarb-ml/mageia-sysadm/attachments/20101029/534f63e7')
| -rw-r--r-- | zarb-ml/mageia-sysadm/attachments/20101029/534f63e7/attachment-0001.html | 761 | ||||
| -rw-r--r-- | zarb-ml/mageia-sysadm/attachments/20101029/534f63e7/attachment.html | 762 |
2 files changed, 1523 insertions, 0 deletions
diff --git a/zarb-ml/mageia-sysadm/attachments/20101029/534f63e7/attachment-0001.html b/zarb-ml/mageia-sysadm/attachments/20101029/534f63e7/attachment-0001.html new file mode 100644 index 000000000..a1d38ab04 --- /dev/null +++ b/zarb-ml/mageia-sysadm/attachments/20101029/534f63e7/attachment-0001.html @@ -0,0 +1,761 @@ +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" +"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> +<html xmlns="http://www.w3.org/1999/xhtml"> +<head><meta http-equiv="content-type" content="text/html; charset=utf-8" /> +<title>[55] - add postgresql config</title> +</head> +<body> + +<style type="text/css"><!-- +#msg dl.meta { border: 1px #006 solid; background: #369; padding: 6px; color: #fff; } +#msg dl.meta dt { float: left; width: 6em; font-weight: bold; } +#msg dt:after { content:':';} +#msg dl, #msg dt, #msg ul, #msg li, #header, #footer, #logmsg { font-family: verdana,arial,helvetica,sans-serif; font-size: 10pt; } +#msg dl a { font-weight: bold} +#msg dl a:link { color:#fc3; } +#msg dl a:active { color:#ff0; } +#msg dl a:visited { color:#cc6; } +h3 { font-family: verdana,arial,helvetica,sans-serif; font-size: 10pt; font-weight: bold; } +#msg pre { overflow: auto; background: #ffc; border: 1px #fa0 solid; padding: 6px; } +#logmsg { background: #ffc; border: 1px #fa0 solid; padding: 1em 1em 0 1em; } +#logmsg p, #logmsg pre, #logmsg blockquote { margin: 0 0 1em 0; } +#logmsg p, #logmsg li, #logmsg dt, #logmsg dd { line-height: 14pt; } +#logmsg h1, #logmsg h2, #logmsg h3, #logmsg h4, #logmsg h5, #logmsg h6 { margin: .5em 0; } +#logmsg h1:first-child, #logmsg h2:first-child, #logmsg h3:first-child, #logmsg h4:first-child, #logmsg h5:first-child, #logmsg h6:first-child { margin-top: 0; } +#logmsg ul, #logmsg ol { padding: 0; list-style-position: inside; margin: 0 0 0 1em; } +#logmsg ul { text-indent: -1em; padding-left: 1em; }#logmsg ol { text-indent: -1.5em; padding-left: 1.5em; } +#logmsg > ul, #logmsg > ol { margin: 0 0 1em 0; } +#logmsg pre { background: #eee; padding: 1em; } +#logmsg blockquote { border: 1px solid #fa0; border-left-width: 10px; padding: 1em 1em 0 1em; background: white;} +#logmsg dl { margin: 0; } +#logmsg dt { font-weight: bold; } +#logmsg dd { margin: 0; padding: 0 0 0.5em 0; } +#logmsg dd:before { content:'\00bb';} +#logmsg table { border-spacing: 0px; border-collapse: collapse; border-top: 4px solid #fa0; border-bottom: 1px solid #fa0; background: #fff; } +#logmsg table th { text-align: left; font-weight: normal; padding: 0.2em 0.5em; border-top: 1px dotted #fa0; } +#logmsg table td { text-align: right; border-top: 1px dotted #fa0; padding: 0.2em 0.5em; } +#logmsg table thead th { text-align: center; border-bottom: 1px solid #fa0; } +#logmsg table th.Corner { text-align: left; } +#logmsg hr { border: none 0; border-top: 2px dashed #fa0; height: 1px; } +#header, #footer { color: #fff; background: #636; border: 1px #300 solid; padding: 6px; } +#patch { width: 100%; } +#patch h4 {font-family: verdana,arial,helvetica,sans-serif;font-size:10pt;padding:8px;background:#369;color:#fff;margin:0;} +#patch .propset h4, #patch .binary h4 {margin:0;} +#patch pre {padding:0;line-height:1.2em;margin:0;} +#patch .diff {width:100%;background:#eee;padding: 0 0 10px 0;overflow:auto;} +#patch .propset .diff, #patch .binary .diff {padding:10px 0;} +#patch span {display:block;padding:0 10px;} +#patch .modfile, #patch .addfile, #patch .delfile, #patch .propset, #patch .binary, #patch .copfile {border:1px solid #ccc;margin:10px 0;} +#patch ins {background:#dfd;text-decoration:none;display:block;padding:0 10px;} +#patch del {background:#fdd;text-decoration:none;display:block;padding:0 10px;} +#patch .lines, .info {color:#888;background:#fff;} +--></style> +<div id="msg"> +<dl class="meta"> +<dt>Revision</dt> <dd>55</dd> +<dt>Author</dt> <dd>nanardon</dd> +<dt>Date</dt> <dd>2010-10-29 01:41:31 +0200 (Fri, 29 Oct 2010)</dd> +</dl> + +<h3>Log Message</h3> +<pre>- add postgresql config</pre> + +<h3>Modified Paths</h3> +<ul> +<li><a href="#puppetmanifestsnodespp">puppet/manifests/nodes.pp</a></li> +</ul> + +<h3>Added Paths</h3> +<ul> +<li>puppet/modules/postgresql/</li> +<li>puppet/modules/postgresql/manifests/</li> +<li><a href="#puppetmodulespostgresqlmanifestsinitpp">puppet/modules/postgresql/manifests/init.pp</a></li> +<li>puppet/modules/postgresql/templates/</li> +<li><a href="#puppetmodulespostgresqltemplatespg_hbaconf">puppet/modules/postgresql/templates/pg_hba.conf</a></li> +<li><a href="#puppetmodulespostgresqltemplatespostgresqlconf">puppet/modules/postgresql/templates/postgresql.conf</a></li> +</ul> + +</div> +<div id="patch"> +<h3>Diff</h3> +<a id="puppetmanifestsnodespp"></a> +<div class="modfile"><h4>Modified: puppet/manifests/nodes.pp (54 => 55)</h4> +<pre class="diff"><span> +<span class="info">--- puppet/manifests/nodes.pp 2010-10-28 23:27:31 UTC (rev 54) ++++ puppet/manifests/nodes.pp 2010-10-28 23:41:31 UTC (rev 55) +</span><span class="lines">@@ -68,6 +68,7 @@ +</span><span class="cx"> # +</span><span class="cx"> include default_mageia_server +</span><span class="cx"> include bind::bind_master +</span><ins>+ include postgresl +</ins><span class="cx"> bind::zone_master { "mageia.org": } +</span><span class="cx"> bind::zone_master { "mageia.fr": } +</span><span class="cx"> timezone::timezone { "Europe/Paris": } +</span></span></pre></div> +<a id="puppetmodulespostgresqlmanifestsinitpp"></a> +<div class="addfile"><h4>Added: puppet/modules/postgresql/manifests/init.pp (0 => 55)</h4> +<pre class="diff"><span> +<span class="info">--- puppet/modules/postgresql/manifests/init.pp (rev 0) ++++ puppet/modules/postgresql/manifests/init.pp 2010-10-28 23:41:31 UTC (rev 55) +</span><span class="lines">@@ -0,0 +1,29 @@ +</span><ins>+class postgresql { ++ package { postgresql9.0-server: ++ ensure => installed ++ } ++ ++ service { postgresql: ++ restart => "/etc/rc.d/init.d/postgresql reload" ++ } ++ ++ file { '/var/lib/pgsql/data/postgresql.conf': ++ ensure => present, ++ owner => postgres, ++ group => postgres, ++ mode => 644, ++ require => Package["postgresql9.0-server"], ++ content => "", ++ notify => [Service['postgreql']] ++ } ++ ++ file { '/var/lib/pgsql/data/pg_hba.conf': ++ ensure => present, ++ owner => postgres, ++ group => postgres, ++ mode => 644, ++ require => Package["postgresql9.0-server"], ++ content => "", ++ notify => [Service['postgresql']] ++ } ++} +</ins></span></pre></div> +<a id="puppetmodulespostgresqltemplatespg_hbaconf"></a> +<div class="addfile"><h4>Added: puppet/modules/postgresql/templates/pg_hba.conf (0 => 55)</h4> +<pre class="diff"><span> +<span class="info">--- puppet/modules/postgresql/templates/pg_hba.conf (rev 0) ++++ puppet/modules/postgresql/templates/pg_hba.conf 2010-10-28 23:41:31 UTC (rev 55) +</span><span class="lines">@@ -0,0 +1,84 @@ +</span><ins>+# PostgreSQL Client Authentication Configuration File ++# =================================================== ++# ++# Refer to the "Client Authentication" section in the PostgreSQL ++# documentation for a complete description of this file. A short ++# synopsis follows. ++# ++# This file controls: which hosts are allowed to connect, how clients ++# are authenticated, which PostgreSQL user names they can use, which ++# databases they can access. Records take one of these forms: ++# ++# local DATABASE USER METHOD [OPTIONS] ++# host DATABASE USER CIDR-ADDRESS METHOD [OPTIONS] ++# hostssl DATABASE USER CIDR-ADDRESS METHOD [OPTIONS] ++# hostnossl DATABASE USER CIDR-ADDRESS METHOD [OPTIONS] ++# ++# (The uppercase items must be replaced by actual values.) ++# ++# The first field is the connection type: "local" is a Unix-domain ++# socket, "host" is either a plain or SSL-encrypted TCP/IP socket, ++# "hostssl" is an SSL-encrypted TCP/IP socket, and "hostnossl" is a ++# plain TCP/IP socket. ++# ++# DATABASE can be "all", "sameuser", "samerole", "replication", a ++# database name, or a comma-separated list thereof. ++# ++# USER can be "all", a user name, a group name prefixed with "+", or a ++# comma-separated list thereof. In both the DATABASE and USER fields ++# you can also write a file name prefixed with "@" to include names ++# from a separate file. ++# ++# CIDR-ADDRESS specifies the set of hosts the record matches. It is ++# made up of an IP address and a CIDR mask that is an integer (between ++# 0 and 32 (IPv4) or 128 (IPv6) inclusive) that specifies the number ++# of significant bits in the mask. Alternatively, you can write an IP ++# address and netmask in separate columns to specify the set of hosts. ++# Instead of a CIDR-address, you can write "samehost" to match any of ++# the server's own IP addresses, or "samenet" to match any address in ++# any subnet that the server is directly connected to. ++# ++# METHOD can be "trust", "reject", "md5", "password", "gss", "sspi", ++# "krb5", "ident", "pam", "ldap", "radius" or "cert". Note that ++# "password" sends passwords in clear text; "md5" is preferred since ++# it sends encrypted passwords. ++# ++# OPTIONS are a set of options for the authentication in the format ++# NAME=VALUE. The available options depend on the different ++# authentication methods -- refer to the "Client Authentication" ++# section in the documentation for a list of which options are ++# available for which authentication methods. ++# ++# Database and user names containing spaces, commas, quotes and other ++# special characters must be quoted. Quoting one of the keywords ++# "all", "sameuser", "samerole" or "replication" makes the name lose ++# its special character, and just match a database or username with ++# that name. ++# ++# This file is read on server startup and when the postmaster receives ++# a SIGHUP signal. If you edit the file on a running system, you have ++# to SIGHUP the postmaster for the changes to take effect. You can ++# use "pg_ctl reload" to do that. ++ ++# Put your actual configuration here ++# ---------------------------------- ++# ++# If you want to allow non-local connections, you need to add more ++# "host" records. In that case you will also need to make PostgreSQL ++# listen on a non-local interface via the listen_addresses ++# configuration parameter, or via the -i or -h command line switches. ++ ++# CAUTION: Configuring the system for local "trust" authentication ++# allows any local user to connect as any PostgreSQL user, including ++# the database superuser. If you do not trust all your local users, ++# use another authentication method. ++ ++ ++# TYPE DATABASE USER CIDR-ADDRESS METHOD ++ ++# "local" is for Unix domain socket connections only ++local all all trust ++# IPv4 local connections: ++host all all 127.0.0.1/32 trust ++# IPv6 local connections: ++host all all ::1/128 trust +</ins></span></pre></div> +<a id="puppetmodulespostgresqltemplatespostgresqlconf"></a> +<div class="addfile"><h4>Added: puppet/modules/postgresql/templates/postgresql.conf (0 => 55)</h4> +<pre class="diff"><span> +<span class="info">--- puppet/modules/postgresql/templates/postgresql.conf (rev 0) ++++ puppet/modules/postgresql/templates/postgresql.conf 2010-10-28 23:41:31 UTC (rev 55) +</span><span class="lines">@@ -0,0 +1,528 @@ +</span><ins>+# ----------------------------- ++# PostgreSQL configuration file ++# ----------------------------- ++# ++# This file consists of lines of the form: ++# ++# name = value ++# ++# (The "=" is optional.) Whitespace may be used. Comments are introduced with ++# "#" anywhere on a line. The complete list of parameter names and allowed ++# values can be found in the PostgreSQL documentation. ++# ++# The commented-out settings shown in this file represent the default values. ++# Re-commenting a setting is NOT sufficient to revert it to the default value; ++# you need to reload the server. ++# ++# This file is read on server startup and when the server receives a SIGHUP ++# signal. If you edit the file on a running system, you have to SIGHUP the ++# server for the changes to take effect, or use "pg_ctl reload". Some ++# parameters, which are marked below, require a server shutdown and restart to ++# take effect. ++# ++# Any parameter can also be given as a command-line option to the server, e.g., ++# "postgres -c log_connections=on". Some parameters can be changed at run time ++# with the "SET" SQL command. ++# ++# Memory units: kB = kilobytes Time units: ms = milliseconds ++# MB = megabytes s = seconds ++# GB = gigabytes min = minutes ++# h = hours ++# d = days ++ ++ ++#------------------------------------------------------------------------------ ++# FILE LOCATIONS ++#------------------------------------------------------------------------------ ++ ++# The default values of these variables are driven from the -D command-line ++# option or PGDATA environment variable, represented here as ConfigDir. ++ ++#data_directory = 'ConfigDir' # use data in another directory ++ # (change requires restart) ++#hba_file = 'ConfigDir/pg_hba.conf' # host-based authentication file ++ # (change requires restart) ++#ident_file = 'ConfigDir/pg_ident.conf' # ident configuration file ++ # (change requires restart) ++ ++# If external_pid_file is not explicitly set, no extra PID file is written. ++#external_pid_file = '(none)' # write an extra PID file ++ # (change requires restart) ++ ++ ++#------------------------------------------------------------------------------ ++# CONNECTIONS AND AUTHENTICATION ++#------------------------------------------------------------------------------ ++ ++# - Connection Settings - ++ ++#listen_addresses = 'localhost' # what IP address(es) to listen on; ++ # comma-separated list of addresses; ++ # defaults to 'localhost', '*' = all ++ # (change requires restart) ++#port = 5432 # (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_directory = '' # (change requires restart) ++#unix_socket_group = '' # (change requires restart) ++#unix_socket_permissions = 0777 # begin with 0 to use octal notation ++ # (change requires restart) ++#bonjour = off # advertise server via Bonjour ++ # (change requires restart) ++#bonjour_name = '' # defaults to the computer name ++ # (change requires restart) ++ ++# - Security and Authentication - ++ ++#authentication_timeout = 1min # 1s-600s ++#ssl = off # (change requires restart) ++#ssl_ciphers = 'ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH' # allowed SSL ciphers ++ # (change requires restart) ++#ssl_renegotiation_limit = 512MB # amount of data between renegotiations ++#password_encryption = on ++#db_user_namespace = off ++ ++# Kerberos and GSSAPI ++#krb_server_keyfile = '' ++#krb_srvname = 'postgres' # (Kerberos only) ++#krb_caseins_users = off ++ ++# - TCP Keepalives - ++# see "man 7 tcp" for details ++ ++#tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds; ++ # 0 selects the system default ++#tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds; ++ # 0 selects the system default ++#tcp_keepalives_count = 0 # TCP_KEEPCNT; ++ # 0 selects the system default ++ ++ ++#------------------------------------------------------------------------------ ++# RESOURCE USAGE (except WAL) ++#------------------------------------------------------------------------------ ++ ++# - Memory - ++ ++shared_buffers = 24MB # min 128kB ++ # (change requires restart) ++#temp_buffers = 8MB # min 800kB ++#max_prepared_transactions = 0 # zero disables the feature ++ # (change requires restart) ++# Note: Increasing max_prepared_transactions costs ~600 bytes of shared memory ++# per transaction slot, plus lock space (see max_locks_per_transaction). ++# It is not advisable to set max_prepared_transactions nonzero unless you ++# actively intend to use prepared transactions. ++#work_mem = 1MB # min 64kB ++#maintenance_work_mem = 16MB # min 1MB ++#max_stack_depth = 2MB # min 100kB ++ ++# - Kernel Resource Usage - ++ ++#max_files_per_process = 1000 # min 25 ++ # (change requires restart) ++#shared_preload_libraries = '' # (change requires restart) ++ ++# - Cost-Based Vacuum Delay - ++ ++#vacuum_cost_delay = 0ms # 0-100 milliseconds ++#vacuum_cost_page_hit = 1 # 0-10000 credits ++#vacuum_cost_page_miss = 10 # 0-10000 credits ++#vacuum_cost_page_dirty = 20 # 0-10000 credits ++#vacuum_cost_limit = 200 # 1-10000 credits ++ ++# - Background Writer - ++ ++#bgwriter_delay = 200ms # 10-10000ms between rounds ++#bgwriter_lru_maxpages = 100 # 0-1000 max buffers written/round ++#bgwriter_lru_multiplier = 2.0 # 0-10.0 multipler on buffers scanned/round ++ ++# - Asynchronous Behavior - ++ ++#effective_io_concurrency = 1 # 1-1000. 0 disables prefetching ++ ++ ++#------------------------------------------------------------------------------ ++# WRITE AHEAD LOG ++#------------------------------------------------------------------------------ ++ ++# - Settings - ++ ++#wal_level = minimal # minimal, archive, or hot_standby ++ # (change requires restart) ++#fsync = on # turns forced synchronization on or off ++#synchronous_commit = on # immediate fsync at commit ++#wal_sync_method = fsync # the default is the first option ++ # supported by the operating system: ++ # open_datasync ++ # fdatasync ++ # fsync ++ # fsync_writethrough ++ # open_sync ++#full_page_writes = on # recover from partial page writes ++#wal_buffers = 64kB # min 32kB ++ # (change requires restart) ++#wal_writer_delay = 200ms # 1-10000 milliseconds ++ ++#commit_delay = 0 # range 0-100000, in microseconds ++#commit_siblings = 5 # range 1-1000 ++ ++# - Checkpoints - ++ ++#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 ++ ++# - Archiving - ++ ++#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 ++ ++# - Streaming Replication - ++ ++#max_wal_senders = 0 # max number of walsender processes ++ # (change requires restart) ++#wal_sender_delay = 200ms # walsender cycle time, 1-10000 milliseconds ++#wal_keep_segments = 0 # in logfile segments, 16MB each; 0 disables ++#vacuum_defer_cleanup_age = 0 # number of xacts by which cleanup is delayed ++ ++# - Standby Servers - ++ ++#hot_standby = off # "on" allows queries during recovery ++ # (change requires restart) ++#max_standby_archive_delay = 30s # max delay before canceling queries ++ # when reading WAL from archive; ++ # -1 allows indefinite delay ++#max_standby_streaming_delay = 30s # max delay before canceling queries ++ # when reading streaming WAL; ++ # -1 allows indefinite delay ++ ++ ++#------------------------------------------------------------------------------ ++# QUERY TUNING ++#------------------------------------------------------------------------------ ++ ++# - Planner Method Configuration - ++ ++#enable_bitmapscan = on ++#enable_hashagg = on ++#enable_hashjoin = on ++#enable_indexscan = on ++#enable_material = on ++#enable_mergejoin = on ++#enable_nestloop = on ++#enable_seqscan = on ++#enable_sort = on ++#enable_tidscan = on ++ ++# - Planner Cost Constants - ++ ++#seq_page_cost = 1.0 # measured on an arbitrary scale ++#random_page_cost = 4.0 # same scale as above ++#cpu_tuple_cost = 0.01 # same scale as above ++#cpu_index_tuple_cost = 0.005 # same scale as above ++#cpu_operator_cost = 0.0025 # same scale as above ++#effective_cache_size = 128MB ++ ++# - Genetic Query Optimizer - ++ ++#geqo = on ++#geqo_threshold = 12 ++#geqo_effort = 5 # range 1-10 ++#geqo_pool_size = 0 # selects default based on effort ++#geqo_generations = 0 # selects default based on effort ++#geqo_selection_bias = 2.0 # range 1.5-2.0 ++#geqo_seed = 0.0 # range 0.0-1.0 ++ ++# - Other Planner Options - ++ ++#default_statistics_target = 100 # range 1-10000 ++#constraint_exclusion = partition # on, off, or partition ++#cursor_tuple_fraction = 0.1 # range 0.0-1.0 ++#from_collapse_limit = 8 ++#join_collapse_limit = 8 # 1 disables collapsing of explicit ++ # JOIN clauses ++ ++ ++#------------------------------------------------------------------------------ ++# ERROR REPORTING AND LOGGING ++#------------------------------------------------------------------------------ ++ ++# - Where to Log - ++ ++#log_destination = 'stderr' # Valid values are combinations of ++ # stderr, csvlog, syslog, and eventlog, ++ # depending on platform. csvlog ++ # requires logging_collector to be on. ++ ++# This is used when logging to stderr: ++#logging_collector = off # Enable capturing of stderr and csvlog ++ # into log files. Required to be on for ++ # csvlogs. ++ # (change requires restart) ++ ++# These are only used if logging_collector is on: ++#log_directory = 'pg_log' # directory where log files are written, ++ # can be absolute or relative to PGDATA ++#log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name pattern, ++ # can include strftime() escapes ++#log_truncate_on_rotation = off # If on, an existing log file of the ++ # same name as the new log file will be ++ # truncated rather than appended to. ++ # But such truncation only occurs on ++ # time-driven rotation, not on restarts ++ # or size-driven rotation. Default is ++ # off, meaning append to existing files ++ # in all cases. ++#log_rotation_age = 1d # Automatic rotation of logfiles will ++ # happen after that time. 0 disables. ++#log_rotation_size = 10MB # Automatic rotation of logfiles will ++ # happen after that much log output. ++ # 0 disables. ++ ++# These are relevant when logging to syslog: ++#syslog_facility = 'LOCAL0' ++#syslog_ident = 'postgres' ++ ++#silent_mode = off # Run server silently. ++ # DO NOT USE without syslog or ++ # logging_collector ++ # (change requires restart) ++ ++ ++# - When to Log - ++ ++#client_min_messages = notice # values in order of decreasing detail: ++ # debug5 ++ # debug4 ++ # debug3 ++ # debug2 ++ # debug1 ++ # log ++ # notice ++ # warning ++ # error ++ ++#log_min_messages = warning # values in order of decreasing detail: ++ # debug5 ++ # debug4 ++ # debug3 ++ # debug2 ++ # debug1 ++ # info ++ # notice ++ # warning ++ # error ++ # log ++ # fatal ++ # panic ++ ++#log_min_error_statement = error # values in order of decreasing detail: ++ # debug5 ++ # debug4 ++ # debug3 ++ # debug2 ++ # debug1 ++ # info ++ # notice ++ # warning ++ # error ++ # log ++ # fatal ++ # panic (effectively off) ++ ++#log_min_duration_statement = -1 # -1 is disabled, 0 logs all statements ++ # and their durations, > 0 logs only ++ # statements running at least this number ++ # of milliseconds ++ ++ ++# - What to Log - ++ ++#debug_print_parse = off ++#debug_print_rewritten = off ++#debug_print_plan = off ++#debug_pretty_print = on ++#log_checkpoints = off ++#log_connections = off ++#log_disconnections = off ++#log_duration = off ++#log_error_verbosity = default # terse, default, or verbose messages ++#log_hostname = off ++#log_line_prefix = '' # special values: ++ # %a = application name ++ # %u = user name ++ # %d = database name ++ # %r = remote host and port ++ # %h = remote host ++ # %p = process ID ++ # %t = timestamp without milliseconds ++ # %m = timestamp with milliseconds ++ # %i = command tag ++ # %e = SQL state ++ # %c = session ID ++ # %l = session line number ++ # %s = session start timestamp ++ # %v = virtual transaction ID ++ # %x = transaction ID (0 if none) ++ # %q = stop here in non-session ++ # processes ++ # %% = '%' ++ # e.g. '<%u%%%d> ' ++#log_lock_waits = off # log lock waits >= deadlock_timeout ++#log_statement = 'none' # none, ddl, mod, all ++#log_temp_files = -1 # log temporary files equal or larger ++ # than the specified size in kilobytes; ++ # -1 disables, 0 logs all temp files ++#log_timezone = unknown # actually, defaults to TZ environment ++ # setting ++ ++ ++#------------------------------------------------------------------------------ ++# RUNTIME STATISTICS ++#------------------------------------------------------------------------------ ++ ++# - Query/Index Statistics Collector - ++ ++#track_activities = on ++#track_counts = on ++#track_functions = none # none, pl, all ++#track_activity_query_size = 1024 # (change requires restart) ++#update_process_title = on ++#stats_temp_directory = 'pg_stat_tmp' ++ ++ ++# - Statistics Monitoring - ++ ++#log_parser_stats = off ++#log_planner_stats = off ++#log_executor_stats = off ++#log_statement_stats = off ++ ++ ++#------------------------------------------------------------------------------ ++# AUTOVACUUM PARAMETERS ++#------------------------------------------------------------------------------ ++ ++#autovacuum = on # Enable autovacuum subprocess? 'on' ++ # requires track_counts to also be on. ++#log_autovacuum_min_duration = -1 # -1 disables, 0 logs all actions and ++ # their durations, > 0 logs only ++ # actions running at least this number ++ # of milliseconds. ++#autovacuum_max_workers = 3 # max number of autovacuum subprocesses ++ # (change requires restart) ++#autovacuum_naptime = 1min # time between autovacuum runs ++#autovacuum_vacuum_threshold = 50 # min number of row updates before ++ # vacuum ++#autovacuum_analyze_threshold = 50 # min number of row updates before ++ # analyze ++#autovacuum_vacuum_scale_factor = 0.2 # fraction of table size before vacuum ++#autovacuum_analyze_scale_factor = 0.1 # fraction of table size before analyze ++#autovacuum_freeze_max_age = 200000000 # maximum XID age before forced vacuum ++ # (change requires restart) ++#autovacuum_vacuum_cost_delay = 20ms # default vacuum cost delay for ++ # autovacuum, in milliseconds; ++ # -1 means use vacuum_cost_delay ++#autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for ++ # autovacuum, -1 means use ++ # vacuum_cost_limit ++ ++ ++#------------------------------------------------------------------------------ ++# CLIENT CONNECTION DEFAULTS ++#------------------------------------------------------------------------------ ++ ++# - Statement Behavior - ++ ++#search_path = '"$user",public' # schema names ++#default_tablespace = '' # a tablespace name, '' uses the default ++#temp_tablespaces = '' # a list of tablespace names, '' uses ++ # only default tablespace ++#check_function_bodies = on ++#default_transaction_isolation = 'read committed' ++#default_transaction_read_only = 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 ++#xmlbinary = 'base64' ++#xmloption = 'content' ++ ++# - Locale and Formatting - ++ ++datestyle = 'iso, mdy' ++#intervalstyle = 'postgres' ++#timezone = unknown # actually, defaults to TZ environment ++ # setting ++#timezone_abbreviations = 'Default' # Select the set of available time zone ++ # abbreviations. Currently, there are ++ # Default ++ # Australia ++ # India ++ # You can create your own file in ++ # share/timezonesets/. ++#extra_float_digits = 0 # min -15, max 3 ++#client_encoding = sql_ascii # actually, defaults to database ++ # encoding ++ ++# These settings are initialized by initdb, but they can be changed. ++lc_messages = 'C' # locale for system error message ++ # strings ++lc_monetary = 'C' # locale for monetary formatting ++lc_numeric = 'C' # locale for number formatting ++lc_time = 'C' # locale for time formatting ++ ++# default configuration for text search ++default_text_search_config = 'pg_catalog.english' ++ ++# - Other Defaults - ++ ++#dynamic_library_path = '$libdir' ++#local_preload_libraries = '' ++ ++ ++#------------------------------------------------------------------------------ ++# LOCK MANAGEMENT ++#------------------------------------------------------------------------------ ++ ++#deadlock_timeout = 1s ++#max_locks_per_transaction = 64 # min 10 ++ # (change requires restart) ++# Note: Each lock table slot uses ~270 bytes of shared memory, and there are ++# max_locks_per_transaction * (max_connections + max_prepared_transactions) ++# lock table slots. ++ ++ ++#------------------------------------------------------------------------------ ++# VERSION/PLATFORM COMPATIBILITY ++#------------------------------------------------------------------------------ ++ ++# - Previous PostgreSQL Versions - ++ ++#array_nulls = on ++#backslash_quote = safe_encoding # on, off, or safe_encoding ++#default_with_oids = off ++#escape_string_warning = on ++#lo_compat_privileges = off ++#sql_inheritance = on ++#standard_conforming_strings = off ++#synchronize_seqscans = on ++ ++# - Other Platforms and Clients - ++ ++#transform_null_equals = off ++ ++ ++#------------------------------------------------------------------------------ ++# CUSTOMIZED OPTIONS ++#------------------------------------------------------------------------------ ++ ++#custom_variable_classes = '' # list of custom variable class names +</ins></span></pre> +</div> +</div> + +</body> +</html> diff --git a/zarb-ml/mageia-sysadm/attachments/20101029/534f63e7/attachment.html b/zarb-ml/mageia-sysadm/attachments/20101029/534f63e7/attachment.html new file mode 100644 index 000000000..d7d4317b7 --- /dev/null +++ b/zarb-ml/mageia-sysadm/attachments/20101029/534f63e7/attachment.html @@ -0,0 +1,762 @@ +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" +"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> +<html xmlns="http://www.w3.org/1999/xhtml"> +<head><meta http-equiv="content-type" content="text/html; charset=utf-8" /> +<title>[55] - add postgresql config</title> +</head> +<body> + +<style type="text/css"><!-- +#msg dl.meta { border: 1px #006 solid; background: #369; padding: 6px; color: #fff; } +#msg dl.meta dt { float: left; width: 6em; font-weight: bold; } +#msg dt:after { content:':';} +#msg dl, #msg dt, #msg ul, #msg li, #header, #footer, #logmsg { font-family: verdana,arial,helvetica,sans-serif; font-size: 10pt; } +#msg dl a { font-weight: bold} +#msg dl a:link { color:#fc3; } +#msg dl a:active { color:#ff0; } +#msg dl a:visited { color:#cc6; } +h3 { font-family: verdana,arial,helvetica,sans-serif; font-size: 10pt; font-weight: bold; } +#msg pre { overflow: auto; background: #ffc; border: 1px #fa0 solid; padding: 6px; } +#logmsg { background: #ffc; border: 1px #fa0 solid; padding: 1em 1em 0 1em; } +#logmsg p, #logmsg pre, #logmsg blockquote { margin: 0 0 1em 0; } +#logmsg p, #logmsg li, #logmsg dt, #logmsg dd { line-height: 14pt; } +#logmsg h1, #logmsg h2, #logmsg h3, #logmsg h4, #logmsg h5, #logmsg h6 { margin: .5em 0; } +#logmsg h1:first-child, #logmsg h2:first-child, #logmsg h3:first-child, #logmsg h4:first-child, #logmsg h5:first-child, #logmsg h6:first-child { margin-top: 0; } +#logmsg ul, #logmsg ol { padding: 0; list-style-position: inside; margin: 0 0 0 1em; } +#logmsg ul { text-indent: -1em; padding-left: 1em; }#logmsg ol { text-indent: -1.5em; padding-left: 1.5em; } +#logmsg > ul, #logmsg > ol { margin: 0 0 1em 0; } +#logmsg pre { background: #eee; padding: 1em; } +#logmsg blockquote { border: 1px solid #fa0; border-left-width: 10px; padding: 1em 1em 0 1em; background: white;} +#logmsg dl { margin: 0; } +#logmsg dt { font-weight: bold; } +#logmsg dd { margin: 0; padding: 0 0 0.5em 0; } +#logmsg dd:before { content:'\00bb';} +#logmsg table { border-spacing: 0px; border-collapse: collapse; border-top: 4px solid #fa0; border-bottom: 1px solid #fa0; background: #fff; } +#logmsg table th { text-align: left; font-weight: normal; padding: 0.2em 0.5em; border-top: 1px dotted #fa0; } +#logmsg table td { text-align: right; border-top: 1px dotted #fa0; padding: 0.2em 0.5em; } +#logmsg table thead th { text-align: center; border-bottom: 1px solid #fa0; } +#logmsg table th.Corner { text-align: left; } +#logmsg hr { border: none 0; border-top: 2px dashed #fa0; height: 1px; } +#header, #footer { color: #fff; background: #636; border: 1px #300 solid; padding: 6px; } +#patch { width: 100%; } +#patch h4 {font-family: verdana,arial,helvetica,sans-serif;font-size:10pt;padding:8px;background:#369;color:#fff;margin:0;} +#patch .propset h4, #patch .binary h4 {margin:0;} +#patch pre {padding:0;line-height:1.2em;margin:0;} +#patch .diff {width:100%;background:#eee;padding: 0 0 10px 0;overflow:auto;} +#patch .propset .diff, #patch .binary .diff {padding:10px 0;} +#patch span {display:block;padding:0 10px;} +#patch .modfile, #patch .addfile, #patch .delfile, #patch .propset, #patch .binary, #patch .copfile {border:1px solid #ccc;margin:10px 0;} +#patch ins {background:#dfd;text-decoration:none;display:block;padding:0 10px;} +#patch del {background:#fdd;text-decoration:none;display:block;padding:0 10px;} +#patch .lines, .info {color:#888;background:#fff;} +--></style> +<div id="msg"> +<dl class="meta"> +<dt>Revision</dt> <dd>55</dd> +<dt>Author</dt> <dd>nanardon</dd> +<dt>Date</dt> <dd>2010-10-29 01:41:31 +0200 (Fri, 29 Oct 2010)</dd> +</dl> + +<h3>Log Message</h3> +<pre>- add postgresql config</pre> + +<h3>Modified Paths</h3> +<ul> +<li><a href="#puppetmanifestsnodespp">puppet/manifests/nodes.pp</a></li> +</ul> + +<h3>Added Paths</h3> +<ul> +<li>puppet/modules/postgresql/</li> +<li>puppet/modules/postgresql/manifests/</li> +<li><a href="#puppetmodulespostgresqlmanifestsinitpp">puppet/modules/postgresql/manifests/init.pp</a></li> +<li>puppet/modules/postgresql/templates/</li> +<li><a href="#puppetmodulespostgresqltemplatespg_hbaconf">puppet/modules/postgresql/templates/pg_hba.conf</a></li> +<li><a href="#puppetmodulespostgresqltemplatespostgresqlconf">puppet/modules/postgresql/templates/postgresql.conf</a></li> +</ul> + +</div> +<div id="patch"> +<h3>Diff</h3> +<a id="puppetmanifestsnodespp"></a> +<div class="modfile"><h4>Modified: puppet/manifests/nodes.pp (54 => 55)</h4> +<pre class="diff"><span> +<span class="info">--- puppet/manifests/nodes.pp 2010-10-28 23:27:31 UTC (rev 54) ++++ puppet/manifests/nodes.pp 2010-10-28 23:41:31 UTC (rev 55) +</span><span class="lines">@@ -68,6 +68,7 @@ +</span><span class="cx"> # +</span><span class="cx"> include default_mageia_server +</span><span class="cx"> include bind::bind_master +</span><ins>+ include postgresl +</ins><span class="cx"> bind::zone_master { "mageia.org": } +</span><span class="cx"> bind::zone_master { "mageia.fr": } +</span><span class="cx"> timezone::timezone { "Europe/Paris": } +</span></span></pre></div> +<a id="puppetmodulespostgresqlmanifestsinitpp"></a> +<div class="addfile"><h4>Added: puppet/modules/postgresql/manifests/init.pp (0 => 55)</h4> +<pre class="diff"><span> +<span class="info">--- puppet/modules/postgresql/manifests/init.pp (rev 0) ++++ puppet/modules/postgresql/manifests/init.pp 2010-10-28 23:41:31 UTC (rev 55) +</span><span class="lines">@@ -0,0 +1,29 @@ +</span><ins>+class postgresql { ++ package { postgresql9.0-server: ++ ensure => installed ++ } ++ ++ service { postgresql: ++ restart => "/etc/rc.d/init.d/postgresql reload" ++ } ++ ++ file { '/var/lib/pgsql/data/postgresql.conf': ++ ensure => present, ++ owner => postgres, ++ group => postgres, ++ mode => 644, ++ require => Package["postgresql9.0-server"], ++ content => "", ++ notify => [Service['postgreql']] ++ } ++ ++ file { '/var/lib/pgsql/data/pg_hba.conf': ++ ensure => present, ++ owner => postgres, ++ group => postgres, ++ mode => 644, ++ require => Package["postgresql9.0-server"], ++ content => "", ++ notify => [Service['postgresql']] ++ } ++} +</ins></span></pre></div> +<a id="puppetmodulespostgresqltemplatespg_hbaconf"></a> +<div class="addfile"><h4>Added: puppet/modules/postgresql/templates/pg_hba.conf (0 => 55)</h4> +<pre class="diff"><span> +<span class="info">--- puppet/modules/postgresql/templates/pg_hba.conf (rev 0) ++++ puppet/modules/postgresql/templates/pg_hba.conf 2010-10-28 23:41:31 UTC (rev 55) +</span><span class="lines">@@ -0,0 +1,84 @@ +</span><ins>+# PostgreSQL Client Authentication Configuration File ++# =================================================== ++# ++# Refer to the "Client Authentication" section in the PostgreSQL ++# documentation for a complete description of this file. A short ++# synopsis follows. ++# ++# This file controls: which hosts are allowed to connect, how clients ++# are authenticated, which PostgreSQL user names they can use, which ++# databases they can access. Records take one of these forms: ++# ++# local DATABASE USER METHOD [OPTIONS] ++# host DATABASE USER CIDR-ADDRESS METHOD [OPTIONS] ++# hostssl DATABASE USER CIDR-ADDRESS METHOD [OPTIONS] ++# hostnossl DATABASE USER CIDR-ADDRESS METHOD [OPTIONS] ++# ++# (The uppercase items must be replaced by actual values.) ++# ++# The first field is the connection type: "local" is a Unix-domain ++# socket, "host" is either a plain or SSL-encrypted TCP/IP socket, ++# "hostssl" is an SSL-encrypted TCP/IP socket, and "hostnossl" is a ++# plain TCP/IP socket. ++# ++# DATABASE can be "all", "sameuser", "samerole", "replication", a ++# database name, or a comma-separated list thereof. ++# ++# USER can be "all", a user name, a group name prefixed with "+", or a ++# comma-separated list thereof. In both the DATABASE and USER fields ++# you can also write a file name prefixed with "@" to include names ++# from a separate file. ++# ++# CIDR-ADDRESS specifies the set of hosts the record matches. It is ++# made up of an IP address and a CIDR mask that is an integer (between ++# 0 and 32 (IPv4) or 128 (IPv6) inclusive) that specifies the number ++# of significant bits in the mask. Alternatively, you can write an IP ++# address and netmask in separate columns to specify the set of hosts. ++# Instead of a CIDR-address, you can write "samehost" to match any of ++# the server's own IP addresses, or "samenet" to match any address in ++# any subnet that the server is directly connected to. ++# ++# METHOD can be "trust", "reject", "md5", "password", "gss", "sspi", ++# "krb5", "ident", "pam", "ldap", "radius" or "cert". Note that ++# "password" sends passwords in clear text; "md5" is preferred since ++# it sends encrypted passwords. ++# ++# OPTIONS are a set of options for the authentication in the format ++# NAME=VALUE. The available options depend on the different ++# authentication methods -- refer to the "Client Authentication" ++# section in the documentation for a list of which options are ++# available for which authentication methods. ++# ++# Database and user names containing spaces, commas, quotes and other ++# special characters must be quoted. Quoting one of the keywords ++# "all", "sameuser", "samerole" or "replication" makes the name lose ++# its special character, and just match a database or username with ++# that name. ++# ++# This file is read on server startup and when the postmaster receives ++# a SIGHUP signal. If you edit the file on a running system, you have ++# to SIGHUP the postmaster for the changes to take effect. You can ++# use "pg_ctl reload" to do that. ++ ++# Put your actual configuration here ++# ---------------------------------- ++# ++# If you want to allow non-local connections, you need to add more ++# "host" records. In that case you will also need to make PostgreSQL ++# listen on a non-local interface via the listen_addresses ++# configuration parameter, or via the -i or -h command line switches. ++ ++# CAUTION: Configuring the system for local "trust" authentication ++# allows any local user to connect as any PostgreSQL user, including ++# the database superuser. If you do not trust all your local users, ++# use another authentication method. ++ ++ ++# TYPE DATABASE USER CIDR-ADDRESS METHOD ++ ++# "local" is for Unix domain socket connections only ++local all all trust ++# IPv4 local connections: ++host all all 127.0.0.1/32 trust ++# IPv6 local connections: ++host all all ::1/128 trust +</ins></span></pre></div> +<a id="puppetmodulespostgresqltemplatespostgresqlconf"></a> +<div class="addfile"><h4>Added: puppet/modules/postgresql/templates/postgresql.conf (0 => 55)</h4> +<pre class="diff"><span> +<span class="info">--- puppet/modules/postgresql/templates/postgresql.conf (rev 0) ++++ puppet/modules/postgresql/templates/postgresql.conf 2010-10-28 23:41:31 UTC (rev 55) +</span><span class="lines">@@ -0,0 +1,528 @@ +</span><ins>+# ----------------------------- ++# PostgreSQL configuration file ++# ----------------------------- ++# ++# This file consists of lines of the form: ++# ++# name = value ++# ++# (The "=" is optional.) Whitespace may be used. Comments are introduced with ++# "#" anywhere on a line. The complete list of parameter names and allowed ++# values can be found in the PostgreSQL documentation. ++# ++# The commented-out settings shown in this file represent the default values. ++# Re-commenting a setting is NOT sufficient to revert it to the default value; ++# you need to reload the server. ++# ++# This file is read on server startup and when the server receives a SIGHUP ++# signal. If you edit the file on a running system, you have to SIGHUP the ++# server for the changes to take effect, or use "pg_ctl reload". Some ++# parameters, which are marked below, require a server shutdown and restart to ++# take effect. ++# ++# Any parameter can also be given as a command-line option to the server, e.g., ++# "postgres -c log_connections=on". Some parameters can be changed at run time ++# with the "SET" SQL command. ++# ++# Memory units: kB = kilobytes Time units: ms = milliseconds ++# MB = megabytes s = seconds ++# GB = gigabytes min = minutes ++# h = hours ++# d = days ++ ++ ++#------------------------------------------------------------------------------ ++# FILE LOCATIONS ++#------------------------------------------------------------------------------ ++ ++# The default values of these variables are driven from the -D command-line ++# option or PGDATA environment variable, represented here as ConfigDir. ++ ++#data_directory = 'ConfigDir' # use data in another directory ++ # (change requires restart) ++#hba_file = 'ConfigDir/pg_hba.conf' # host-based authentication file ++ # (change requires restart) ++#ident_file = 'ConfigDir/pg_ident.conf' # ident configuration file ++ # (change requires restart) ++ ++# If external_pid_file is not explicitly set, no extra PID file is written. ++#external_pid_file = '(none)' # write an extra PID file ++ # (change requires restart) ++ ++ ++#------------------------------------------------------------------------------ ++# CONNECTIONS AND AUTHENTICATION ++#------------------------------------------------------------------------------ ++ ++# - Connection Settings - ++ ++#listen_addresses = 'localhost' # what IP address(es) to listen on; ++ # comma-separated list of addresses; ++ # defaults to 'localhost', '*' = all ++ # (change requires restart) ++#port = 5432 # (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_directory = '' # (change requires restart) ++#unix_socket_group = '' # (change requires restart) ++#unix_socket_permissions = 0777 # begin with 0 to use octal notation ++ # (change requires restart) ++#bonjour = off # advertise server via Bonjour ++ # (change requires restart) ++#bonjour_name = '' # defaults to the computer name ++ # (change requires restart) ++ ++# - Security and Authentication - ++ ++#authentication_timeout = 1min # 1s-600s ++#ssl = off # (change requires restart) ++#ssl_ciphers = 'ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH' # allowed SSL ciphers ++ # (change requires restart) ++#ssl_renegotiation_limit = 512MB # amount of data between renegotiations ++#password_encryption = on ++#db_user_namespace = off ++ ++# Kerberos and GSSAPI ++#krb_server_keyfile = '' ++#krb_srvname = 'postgres' # (Kerberos only) ++#krb_caseins_users = off ++ ++# - TCP Keepalives - ++# see "man 7 tcp" for details ++ ++#tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds; ++ # 0 selects the system default ++#tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds; ++ # 0 selects the system default ++#tcp_keepalives_count = 0 # TCP_KEEPCNT; ++ # 0 selects the system default ++ ++ ++#------------------------------------------------------------------------------ ++# RESOURCE USAGE (except WAL) ++#------------------------------------------------------------------------------ ++ ++# - Memory - ++ ++shared_buffers = 24MB # min 128kB ++ # (change requires restart) ++#temp_buffers = 8MB # min 800kB ++#max_prepared_transactions = 0 # zero disables the feature ++ # (change requires restart) ++# Note: Increasing max_prepared_transactions costs ~600 bytes of shared memory ++# per transaction slot, plus lock space (see max_locks_per_transaction). ++# It is not advisable to set max_prepared_transactions nonzero unless you ++# actively intend to use prepared transactions. ++#work_mem = 1MB # min 64kB ++#maintenance_work_mem = 16MB # min 1MB ++#max_stack_depth = 2MB # min 100kB ++ ++# - Kernel Resource Usage - ++ ++#max_files_per_process = 1000 # min 25 ++ # (change requires restart) ++#shared_preload_libraries = '' # (change requires restart) ++ ++# - Cost-Based Vacuum Delay - ++ ++#vacuum_cost_delay = 0ms # 0-100 milliseconds ++#vacuum_cost_page_hit = 1 # 0-10000 credits ++#vacuum_cost_page_miss = 10 # 0-10000 credits ++#vacuum_cost_page_dirty = 20 # 0-10000 credits ++#vacuum_cost_limit = 200 # 1-10000 credits ++ ++# - Background Writer - ++ ++#bgwriter_delay = 200ms # 10-10000ms between rounds ++#bgwriter_lru_maxpages = 100 # 0-1000 max buffers written/round ++#bgwriter_lru_multiplier = 2.0 # 0-10.0 multipler on buffers scanned/round ++ ++# - Asynchronous Behavior - ++ ++#effective_io_concurrency = 1 # 1-1000. 0 disables prefetching ++ ++ ++#------------------------------------------------------------------------------ ++# WRITE AHEAD LOG ++#------------------------------------------------------------------------------ ++ ++# - Settings - ++ ++#wal_level = minimal # minimal, archive, or hot_standby ++ # (change requires restart) ++#fsync = on # turns forced synchronization on or off ++#synchronous_commit = on # immediate fsync at commit ++#wal_sync_method = fsync # the default is the first option ++ # supported by the operating system: ++ # open_datasync ++ # fdatasync ++ # fsync ++ # fsync_writethrough ++ # open_sync ++#full_page_writes = on # recover from partial page writes ++#wal_buffers = 64kB # min 32kB ++ # (change requires restart) ++#wal_writer_delay = 200ms # 1-10000 milliseconds ++ ++#commit_delay = 0 # range 0-100000, in microseconds ++#commit_siblings = 5 # range 1-1000 ++ ++# - Checkpoints - ++ ++#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 ++ ++# - Archiving - ++ ++#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 ++ ++# - Streaming Replication - ++ ++#max_wal_senders = 0 # max number of walsender processes ++ # (change requires restart) ++#wal_sender_delay = 200ms # walsender cycle time, 1-10000 milliseconds ++#wal_keep_segments = 0 # in logfile segments, 16MB each; 0 disables ++#vacuum_defer_cleanup_age = 0 # number of xacts by which cleanup is delayed ++ ++# - Standby Servers - ++ ++#hot_standby = off # "on" allows queries during recovery ++ # (change requires restart) ++#max_standby_archive_delay = 30s # max delay before canceling queries ++ # when reading WAL from archive; ++ # -1 allows indefinite delay ++#max_standby_streaming_delay = 30s # max delay before canceling queries ++ # when reading streaming WAL; ++ # -1 allows indefinite delay ++ ++ ++#------------------------------------------------------------------------------ ++# QUERY TUNING ++#------------------------------------------------------------------------------ ++ ++# - Planner Method Configuration - ++ ++#enable_bitmapscan = on ++#enable_hashagg = on ++#enable_hashjoin = on ++#enable_indexscan = on ++#enable_material = on ++#enable_mergejoin = on ++#enable_nestloop = on ++#enable_seqscan = on ++#enable_sort = on ++#enable_tidscan = on ++ ++# - Planner Cost Constants - ++ ++#seq_page_cost = 1.0 # measured on an arbitrary scale ++#random_page_cost = 4.0 # same scale as above ++#cpu_tuple_cost = 0.01 # same scale as above ++#cpu_index_tuple_cost = 0.005 # same scale as above ++#cpu_operator_cost = 0.0025 # same scale as above ++#effective_cache_size = 128MB ++ ++# - Genetic Query Optimizer - ++ ++#geqo = on ++#geqo_threshold = 12 ++#geqo_effort = 5 # range 1-10 ++#geqo_pool_size = 0 # selects default based on effort ++#geqo_generations = 0 # selects default based on effort ++#geqo_selection_bias = 2.0 # range 1.5-2.0 ++#geqo_seed = 0.0 # range 0.0-1.0 ++ ++# - Other Planner Options - ++ ++#default_statistics_target = 100 # range 1-10000 ++#constraint_exclusion = partition # on, off, or partition ++#cursor_tuple_fraction = 0.1 # range 0.0-1.0 ++#from_collapse_limit = 8 ++#join_collapse_limit = 8 # 1 disables collapsing of explicit ++ # JOIN clauses ++ ++ ++#------------------------------------------------------------------------------ ++# ERROR REPORTING AND LOGGING ++#------------------------------------------------------------------------------ ++ ++# - Where to Log - ++ ++#log_destination = 'stderr' # Valid values are combinations of ++ # stderr, csvlog, syslog, and eventlog, ++ # depending on platform. csvlog ++ # requires logging_collector to be on. ++ ++# This is used when logging to stderr: ++#logging_collector = off # Enable capturing of stderr and csvlog ++ # into log files. Required to be on for ++ # csvlogs. ++ # (change requires restart) ++ ++# These are only used if logging_collector is on: ++#log_directory = 'pg_log' # directory where log files are written, ++ # can be absolute or relative to PGDATA ++#log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name pattern, ++ # can include strftime() escapes ++#log_truncate_on_rotation = off # If on, an existing log file of the ++ # same name as the new log file will be ++ # truncated rather than appended to. ++ # But such truncation only occurs on ++ # time-driven rotation, not on restarts ++ # or size-driven rotation. Default is ++ # off, meaning append to existing files ++ # in all cases. ++#log_rotation_age = 1d # Automatic rotation of logfiles will ++ # happen after that time. 0 disables. ++#log_rotation_size = 10MB # Automatic rotation of logfiles will ++ # happen after that much log output. ++ # 0 disables. ++ ++# These are relevant when logging to syslog: ++#syslog_facility = 'LOCAL0' ++#syslog_ident = 'postgres' ++ ++#silent_mode = off # Run server silently. ++ # DO NOT USE without syslog or ++ # logging_collector ++ # (change requires restart) ++ ++ ++# - When to Log - ++ ++#client_min_messages = notice # values in order of decreasing detail: ++ # debug5 ++ # debug4 ++ # debug3 ++ # debug2 ++ # debug1 ++ # log ++ # notice ++ # warning ++ # error ++ ++#log_min_messages = warning # values in order of decreasing detail: ++ # debug5 ++ # debug4 ++ # debug3 ++ # debug2 ++ # debug1 ++ # info ++ # notice ++ # warning ++ # error ++ # log ++ # fatal ++ # panic ++ ++#log_min_error_statement = error # values in order of decreasing detail: ++ # debug5 ++ # debug4 ++ # debug3 ++ # debug2 ++ # debug1 ++ # info ++ # notice ++ # warning ++ # error ++ # log ++ # fatal ++ # panic (effectively off) ++ ++#log_min_duration_statement = -1 # -1 is disabled, 0 logs all statements ++ # and their durations, > 0 logs only ++ # statements running at least this number ++ # of milliseconds ++ ++ ++# - What to Log - ++ ++#debug_print_parse = off ++#debug_print_rewritten = off ++#debug_print_plan = off ++#debug_pretty_print = on ++#log_checkpoints = off ++#log_connections = off ++#log_disconnections = off ++#log_duration = off ++#log_error_verbosity = default # terse, default, or verbose messages ++#log_hostname = off ++#log_line_prefix = '' # special values: ++ # %a = application name ++ # %u = user name ++ # %d = database name ++ # %r = remote host and port ++ # %h = remote host ++ # %p = process ID ++ # %t = timestamp without milliseconds ++ # %m = timestamp with milliseconds ++ # %i = command tag ++ # %e = SQL state ++ # %c = session ID ++ # %l = session line number ++ # %s = session start timestamp ++ # %v = virtual transaction ID ++ # %x = transaction ID (0 if none) ++ # %q = stop here in non-session ++ # processes ++ # %% = '%' ++ # e.g. '<%u%%%d> ' ++#log_lock_waits = off # log lock waits >= deadlock_timeout ++#log_statement = 'none' # none, ddl, mod, all ++#log_temp_files = -1 # log temporary files equal or larger ++ # than the specified size in kilobytes; ++ # -1 disables, 0 logs all temp files ++#log_timezone = unknown # actually, defaults to TZ environment ++ # setting ++ ++ ++#------------------------------------------------------------------------------ ++# RUNTIME STATISTICS ++#------------------------------------------------------------------------------ ++ ++# - Query/Index Statistics Collector - ++ ++#track_activities = on ++#track_counts = on ++#track_functions = none # none, pl, all ++#track_activity_query_size = 1024 # (change requires restart) ++#update_process_title = on ++#stats_temp_directory = 'pg_stat_tmp' ++ ++ ++# - Statistics Monitoring - ++ ++#log_parser_stats = off ++#log_planner_stats = off ++#log_executor_stats = off ++#log_statement_stats = off ++ ++ ++#------------------------------------------------------------------------------ ++# AUTOVACUUM PARAMETERS ++#------------------------------------------------------------------------------ ++ ++#autovacuum = on # Enable autovacuum subprocess? 'on' ++ # requires track_counts to also be on. ++#log_autovacuum_min_duration = -1 # -1 disables, 0 logs all actions and ++ # their durations, > 0 logs only ++ # actions running at least this number ++ # of milliseconds. ++#autovacuum_max_workers = 3 # max number of autovacuum subprocesses ++ # (change requires restart) ++#autovacuum_naptime = 1min # time between autovacuum runs ++#autovacuum_vacuum_threshold = 50 # min number of row updates before ++ # vacuum ++#autovacuum_analyze_threshold = 50 # min number of row updates before ++ # analyze ++#autovacuum_vacuum_scale_factor = 0.2 # fraction of table size before vacuum ++#autovacuum_analyze_scale_factor = 0.1 # fraction of table size before analyze ++#autovacuum_freeze_max_age = 200000000 # maximum XID age before forced vacuum ++ # (change requires restart) ++#autovacuum_vacuum_cost_delay = 20ms # default vacuum cost delay for ++ # autovacuum, in milliseconds; ++ # -1 means use vacuum_cost_delay ++#autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for ++ # autovacuum, -1 means use ++ # vacuum_cost_limit ++ ++ ++#------------------------------------------------------------------------------ ++# CLIENT CONNECTION DEFAULTS ++#------------------------------------------------------------------------------ ++ ++# - Statement Behavior - ++ ++#search_path = '"$user",public' # schema names ++#default_tablespace = '' # a tablespace name, '' uses the default ++#temp_tablespaces = '' # a list of tablespace names, '' uses ++ # only default tablespace ++#check_function_bodies = on ++#default_transaction_isolation = 'read committed' ++#default_transaction_read_only = 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 ++#xmlbinary = 'base64' ++#xmloption = 'content' ++ ++# - Locale and Formatting - ++ ++datestyle = 'iso, mdy' ++#intervalstyle = 'postgres' ++#timezone = unknown # actually, defaults to TZ environment ++ # setting ++#timezone_abbreviations = 'Default' # Select the set of available time zone ++ # abbreviations. Currently, there are ++ # Default ++ # Australia ++ # India ++ # You can create your own file in ++ # share/timezonesets/. ++#extra_float_digits = 0 # min -15, max 3 ++#client_encoding = sql_ascii # actually, defaults to database ++ # encoding ++ ++# These settings are initialized by initdb, but they can be changed. ++lc_messages = 'C' # locale for system error message ++ # strings ++lc_monetary = 'C' # locale for monetary formatting ++lc_numeric = 'C' # locale for number formatting ++lc_time = 'C' # locale for time formatting ++ ++# default configuration for text search ++default_text_search_config = 'pg_catalog.english' ++ ++# - Other Defaults - ++ ++#dynamic_library_path = '$libdir' ++#local_preload_libraries = '' ++ ++ ++#------------------------------------------------------------------------------ ++# LOCK MANAGEMENT ++#------------------------------------------------------------------------------ ++ ++#deadlock_timeout = 1s ++#max_locks_per_transaction = 64 # min 10 ++ # (change requires restart) ++# Note: Each lock table slot uses ~270 bytes of shared memory, and there are ++# max_locks_per_transaction * (max_connections + max_prepared_transactions) ++# lock table slots. ++ ++ ++#------------------------------------------------------------------------------ ++# VERSION/PLATFORM COMPATIBILITY ++#------------------------------------------------------------------------------ ++ ++# - Previous PostgreSQL Versions - ++ ++#array_nulls = on ++#backslash_quote = safe_encoding # on, off, or safe_encoding ++#default_with_oids = off ++#escape_string_warning = on ++#lo_compat_privileges = off ++#sql_inheritance = on ++#standard_conforming_strings = off ++#synchronize_seqscans = on ++ ++# - Other Platforms and Clients - ++ ++#transform_null_equals = off ++ ++ ++#------------------------------------------------------------------------------ ++# CUSTOMIZED OPTIONS ++#------------------------------------------------------------------------------ ++ ++#custom_variable_classes = '' # list of custom variable class names +</ins></span></pre> +</div> +</div> + +</body> +</html> + |