Changeset 976 for trunk/packages/sipb-xen-database/server/etc
- Timestamp:
- Oct 1, 2008, 3:13:42 AM (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/packages/sipb-xen-database/server/etc/postgresql/8.3/main/postgresql.conf.invirt
r974 r976 7 7 # name = value 8 8 # 9 # (The '=' is optional.) White space may be used. Comments are introduced 10 # with '#' anywhere on a line. The complete list of option names and 11 # allowed values can be found in the PostgreSQL documentation. The 12 # commented-out settings shown in this file represent the default values. 13 # 14 # Please note that re-commenting a setting is NOT sufficient to revert it 15 # to the default value, unless you restart the postmaster. 16 # 17 # Any option can also be given as a command line switch to the 18 # postmaster, e.g. 'postmaster -c log_connections=on'. Some options 19 # can be changed at run-time with the 'SET' SQL command. 20 # 21 # This file is read on postmaster startup and when the postmaster 22 # receives a SIGHUP. If you edit the file on a running system, you have 23 # to SIGHUP the postmaster for the changes to take effect, or use 24 # "pg_ctl reload". Some settings, such as listen_addresses, require 25 # a postmaster shutdown and restart to take effect. 26 27 28 #--------------------------------------------------------------------------- 9 # (The "=" is optional.) Whitespace may be used. Comments are introduced with 10 # "#" anywhere on a line. The complete list of parameter names and allowed 11 # values can be found in the PostgreSQL documentation. 12 # 13 # The commented-out settings shown in this file represent the default values. 14 # Re-commenting a setting is NOT sufficient to revert it to the default value; 15 # you need to reload the server. 16 # 17 # This file is read on server startup and when the server receives a SIGHUP 18 # signal. If you edit the file on a running system, you have to SIGHUP the 19 # server for the changes to take effect, or use "pg_ctl reload". Some 20 # parameters, which are marked below, require a server shutdown and restart to 21 # take effect. 22 # 23 # Any parameter can also be given as a command-line option to the server, e.g., 24 # "postgres -c log_connections=on". Some paramters can be changed at run time 25 # with the "SET" SQL command. 26 # 27 # Memory units: kB = kilobytes MB = megabytes GB = gigabytes 28 # Time units: ms = milliseconds s = seconds min = minutes h = hours d = days 29 30 31 #------------------------------------------------------------------------------ 29 32 # FILE LOCATIONS 30 #--------------------------------------------------------------------------- 31 32 # The default values of these variables are driven from the -D command line 33 # switch or PGDATA environment variable, represented here as ConfigDir. 34 35 #data_directory = 'ConfigDir' # use data in another directory 33 #------------------------------------------------------------------------------ 34 35 # The default values of these variables are driven from the -D command-line 36 # option or PGDATA environment variable, represented here as ConfigDir. 37 38 data_directory = '/var/lib/postgresql/8.3/main' # use data in another directory 39 # (change requires restart) 36 40 hba_file = '/etc/postgresql/8.3/main/pg_hba.conf' # host-based authentication file 37 ident_file = '/etc/postgresql/8.3/main/pg_ident.conf' # IDENT configuration file 38 39 # If external_pid_file is not explicitly set, no extra pid file is written. 40 external_pid_file = '/var/run/postgresql/8.3-main.pid' # write an extra pid file 41 42 43 #--------------------------------------------------------------------------- 41 # (change requires restart) 42 ident_file = '/etc/postgresql/8.3/main/pg_ident.conf' # ident configuration file 43 # (change requires restart) 44 45 # If external_pid_file is not explicitly set, no extra PID file is written. 46 external_pid_file = '/var/run/postgresql/8.3-main.pid' # write an extra PID file 47 # (change requires restart) 48 49 50 #------------------------------------------------------------------------------ 44 51 # CONNECTIONS AND AUTHENTICATION 45 #--------------------------------------------------------------------------- 52 #------------------------------------------------------------------------------ 46 53 47 54 # - Connection Settings - 48 55 49 listen_addresses = '*' # what IP address(es) to listen on;56 listen_addresses = '*' # what IP address(es) to listen on; 50 57 # comma-separated list of addresses; 51 58 # defaults to 'localhost', '*' = all 52 port = 5432 53 max_connections = 100 54 # note: increasing max_connections costs ~400 bytes of shared memory per 55 # connection slot, plus lock space (see max_locks_per_transaction). You 56 # might also need to raise shared_buffers to support more connections. 57 #superuser_reserved_connections = 2 58 unix_socket_directory = '/var/run/postgresql' 59 #unix_socket_group = '' 60 #unix_socket_permissions = 0777 # octal 59 # (change requires restart) 60 port = 5432 # (change requires restart) 61 max_connections = 100 # (change requires restart) 62 # Note: Increasing max_connections costs ~400 bytes of shared memory per 63 # connection slot, plus lock space (see max_locks_per_transaction). You might 64 # also need to raise shared_buffers to support more connections. 65 #superuser_reserved_connections = 3 # (change requires restart) 66 unix_socket_directory = '/var/run/postgresql' # (change requires restart) 67 #unix_socket_group = '' # (change requires restart) 68 #unix_socket_permissions = 0777 # begin with 0 to use octal notation 69 # (change requires restart) 61 70 #bonjour_name = '' # defaults to the computer name 62 63 # - Security & Authentication - 64 65 #authentication_timeout = 60 # 1-600, in seconds 66 ssl = true 71 # (change requires restart) 72 73 # - Security and Authentication - 74 75 #authentication_timeout = 1min # 1s-600s 76 ssl = true # (change requires restart) 77 #ssl_ciphers = 'ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH' # allowed SSL ciphers 78 # (change requires restart) 67 79 #password_encryption = on 68 80 #db_user_namespace = off 69 81 70 # Kerberos 71 #krb_server_keyfile = '' 72 #krb_srvname = 'postgres' 82 # Kerberos and GSSAPI 83 #krb_server_keyfile = '' # (change requires restart) 84 #krb_srvname = 'postgres' # (change requires restart, Kerberos only) 73 85 #krb_server_hostname = '' # empty string matches any keytab entry 74 #krb_caseins_users = off 86 # (change requires restart, Kerberos only) 87 #krb_caseins_users = off # (change requires restart) 88 #krb_realm = '' # (change requires restart) 75 89 76 90 # - TCP Keepalives - 77 # see 'man 7 tcp'for details91 # see "man 7 tcp" for details 78 92 79 93 #tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds; … … 85 99 86 100 87 #--------------------------------------------------------------------------- 101 #------------------------------------------------------------------------------ 88 102 # RESOURCE USAGE (except WAL) 89 #--------------------------------------------------------------------------- 103 #------------------------------------------------------------------------------ 90 104 91 105 # - Memory - 92 106 93 shared_buffers = 1000 # min 16 or max_connections*2, 8KB each 94 #temp_buffers = 1000 # min 100, 8KB each 107 shared_buffers = 24MB # min 128kB or max_connections*16kB 108 # (change requires restart) 109 #temp_buffers = 8MB # min 800kB 95 110 #max_prepared_transactions = 5 # can be 0 or more 96 # note: increasing max_prepared_transactions costs ~600 bytes of shared memory 111 # (change requires restart) 112 # Note: Increasing max_prepared_transactions costs ~600 bytes of shared memory 97 113 # per transaction slot, plus lock space (see max_locks_per_transaction). 98 #work_mem = 1 024 # min 64, size in KB99 #maintenance_work_mem = 16 384 # min 1024, size in KB100 #max_stack_depth = 2 048 # min 100, size in KB114 #work_mem = 1MB # min 64kB 115 #maintenance_work_mem = 16MB # min 1MB 116 #max_stack_depth = 2MB # min 100kB 101 117 102 118 # - Free Space Map - 103 119 104 #max_fsm_pages = 20000 # min max_fsm_relations*16, 6 bytes each 120 max_fsm_pages = 153600 # min max_fsm_relations*16, 6 bytes each 121 # (change requires restart) 105 122 #max_fsm_relations = 1000 # min 100, ~70 bytes each 123 # (change requires restart) 106 124 107 125 # - Kernel Resource Usage - 108 126 109 127 #max_files_per_process = 1000 # min 25 110 #preload_libraries = '' 128 # (change requires restart) 129 #shared_preload_libraries = '' # (change requires restart) 111 130 112 131 # - Cost-Based Vacuum Delay - … … 116 135 #vacuum_cost_page_miss = 10 # 0-10000 credits 117 136 #vacuum_cost_page_dirty = 20 # 0-10000 credits 118 #vacuum_cost_limit = 200 # 0-10000 credits 119 120 # - Background writer - 121 122 #bgwriter_delay = 200 # 10-10000 milliseconds between rounds 123 #bgwriter_lru_percent = 1.0 # 0-100% of LRU buffers scanned/round 124 #bgwriter_lru_maxpages = 5 # 0-1000 buffers max written/round 125 #bgwriter_all_percent = 0.333 # 0-100% of all buffers scanned/round 126 #bgwriter_all_maxpages = 5 # 0-1000 buffers max written/round 127 128 129 #--------------------------------------------------------------------------- 137 #vacuum_cost_limit = 200 # 1-10000 credits 138 139 # - Background Writer - 140 141 #bgwriter_delay = 200ms # 10-10000ms between rounds 142 #bgwriter_lru_maxpages = 100 # 0-1000 max buffers written/round 143 #bgwriter_lru_multiplier = 2.0 # 0-10.0 multipler on buffers scanned/round 144 145 146 #------------------------------------------------------------------------------ 130 147 # WRITE AHEAD LOG 131 #--------------------------------------------------------------------------- 148 #------------------------------------------------------------------------------ 132 149 133 150 # - Settings - 134 151 135 152 #fsync = on # turns forced synchronization on or off 153 #synchronous_commit = on # immediate fsync at commit 136 154 #wal_sync_method = fsync # the default is the first option 137 155 # supported by the operating system: … … 142 160 # open_sync 143 161 #full_page_writes = on # recover from partial page writes 144 #wal_buffers = 8 # min 4, 8KB each 162 #wal_buffers = 64kB # min 32kB 163 # (change requires restart) 164 #wal_writer_delay = 200ms # 1-10000 milliseconds 165 145 166 #commit_delay = 0 # range 0-100000, in microseconds 146 167 #commit_siblings = 5 # range 1-1000 … … 149 170 150 171 #checkpoint_segments = 3 # in logfile segments, min 1, 16MB each 151 #checkpoint_timeout = 300 # range 30-3600, in seconds 152 #checkpoint_warning = 30 # in seconds, 0 is off 172 #checkpoint_timeout = 5min # range 30s-1h 173 #checkpoint_completion_target = 0.5 # checkpoint target duration, 0.0 - 1.0 174 #checkpoint_warning = 30s # 0 is off 153 175 154 176 # - Archiving - 155 177 156 #archive_command = '' # command to use to archive a logfile 157 # segment 158 159 160 #--------------------------------------------------------------------------- 178 #archive_mode = off # allows archiving to be done 179 # (change requires restart) 180 #archive_command = '' # command to use to archive a logfile segment 181 #archive_timeout = 0 # force a logfile segment switch after this 182 # time; 0 is off 183 184 185 #------------------------------------------------------------------------------ 161 186 # QUERY TUNING 162 #--------------------------------------------------------------------------- 187 #------------------------------------------------------------------------------ 163 188 164 189 # - Planner Method Configuration - … … 176 201 # - Planner Cost Constants - 177 202 178 # effective_cache_size = 1000 # typically 8KB each179 #random_page_cost = 4 # units are one sequential page fetch180 # cost 181 #cpu_ tuple_cost = 0.01 # (same)182 #cpu_ index_tuple_cost = 0.001 # (same)183 # cpu_operator_cost = 0.0025 # (same)203 #seq_page_cost = 1.0 # measured on an arbitrary scale 204 #random_page_cost = 4.0 # same scale as above 205 #cpu_tuple_cost = 0.01 # same scale as above 206 #cpu_index_tuple_cost = 0.005 # same scale as above 207 #cpu_operator_cost = 0.0025 # same scale as above 208 #effective_cache_size = 128MB 184 209 185 210 # - Genetic Query Optimizer - … … 198 223 #from_collapse_limit = 8 199 224 #join_collapse_limit = 8 # 1 disables collapsing of explicit 200 # JOIN s201 202 203 #--------------------------------------------------------------------------- 225 # JOIN clauses 226 227 228 #------------------------------------------------------------------------------ 204 229 # ERROR REPORTING AND LOGGING 205 #--------------------------------------------------------------------------- 230 #------------------------------------------------------------------------------ 206 231 207 232 # - Where to Log - 208 233 209 #log_destination = 'stderr' # Valid values are combinations of 210 # stderr, syslog and eventlog, 211 # depending on platform. 234 #log_destination = 'stderr' # Valid values are combinations of 235 # stderr, csvlog, syslog and eventlog, 236 # depending on platform. csvlog 237 # requires logging_collector to be on. 212 238 213 239 # This is used when logging to stderr: 214 #redirect_stderr = off # Enable capturing of stderr into log 215 # files 216 217 # These are only used if redirect_stderr is on: 218 #log_directory = 'pg_log' # Directory where log files are written 219 # Can be absolute or relative to PGDATA 220 #log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # Log file name pattern. 221 # Can include strftime() escapes 222 #log_truncate_on_rotation = off # If on, any existing log file of the same 223 # name as the new log file will be 224 # truncated rather than appended to. But 225 # such truncation only occurs on 240 #logging_collector = off # Enable capturing of stderr and csvlog 241 # into log files. Required to be on for 242 # csvlogs. 243 # (change requires restart) 244 245 # These are only used if logging_collector is on: 246 #log_directory = 'pg_log' # directory where log files are written, 247 # can be absolute or relative to PGDATA 248 #log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name pattern, 249 # can include strftime() escapes 250 #log_truncate_on_rotation = off # If on, an existing log file of the 251 # same name as the new log file will be 252 # truncated rather than appended to. 253 # But such truncation only occurs on 226 254 # time-driven rotation, not on restarts 227 # or size-driven rotation. Default is255 # or size-driven rotation. Default is 228 256 # off, meaning append to existing files 229 257 # in all cases. 230 #log_rotation_age = 1440 # Automatic rotation of logfiles will 231 # happen after so many minutes. 0 to 232 # disable. 233 #log_rotation_size = 10240 # Automatic rotation of logfiles will 234 # happen after so many kilobytes of log 235 # output. 0 to disable. 258 #log_rotation_age = 1d # Automatic rotation of logfiles will 259 # happen after that time. 0 to disable. 260 #log_rotation_size = 10MB # Automatic rotation of logfiles will 261 # happen after that much log output. 262 # 0 to disable. 236 263 237 264 # These are relevant when logging to syslog: … … 242 269 # - When to Log - 243 270 244 #client_min_messages = notice # Values,in order of decreasing detail:271 #client_min_messages = notice # values in order of decreasing detail: 245 272 # debug5 246 273 # debug4 … … 253 280 # error 254 281 255 #log_min_messages = notice # Values,in order of decreasing detail:282 #log_min_messages = notice # values in order of decreasing detail: 256 283 # debug5 257 284 # debug4 … … 269 296 #log_error_verbosity = default # terse, default, or verbose messages 270 297 271 #log_min_error_statement = panic # Values in order of increasing severity:298 #log_min_error_statement = error # values in order of decreasing detail: 272 299 # debug5 273 300 # debug4 … … 279 306 # warning 280 307 # error 281 # panic(off) 282 308 # log 309 # fatal 310 # panic (effectively off) 311 283 312 #log_min_duration_statement = -1 # -1 is disabled, 0 logs all statements 284 # and their durations, in milliseconds. 285 286 #silent_mode = off # DO NOT USE without syslog or 287 # redirect_stderr 313 # and their durations, > 0 logs only 314 # statements running at least this time. 315 316 #silent_mode = off # DO NOT USE without syslog or 317 # logging_collector 318 # (change requires restart) 288 319 289 320 # - What to Log - … … 293 324 #debug_print_plan = off 294 325 #debug_pretty_print = off 326 #log_checkpoints = off 295 327 #log_connections = off 296 328 #log_disconnections = off 297 329 #log_duration = off 298 log_line_prefix = '%t ' # Special values: 330 #log_hostname = off 331 log_line_prefix = '%t ' # special values: 299 332 # %u = user name 300 333 # %d = database name 301 334 # %r = remote host and port 302 335 # %h = remote host 303 # %p = PID304 # %t = timestamp (no milliseconds)336 # %p = process ID 337 # %t = timestamp without milliseconds 305 338 # %m = timestamp with milliseconds 306 339 # %i = command tag 307 # %c = session id340 # %c = session ID 308 341 # %l = session line number 309 342 # %s = session start timestamp 310 # %x = transaction id 311 # %q = stop here in non-session 343 # %v = virtual transaction ID 344 # %x = transaction ID (0 if none) 345 # %q = stop here in non-session 312 346 # processes 313 347 # %% = '%' 314 348 # e.g. '<%u%%%d> ' 315 #log_statement = 'none' # none, mod, ddl, all 316 #log_hostname = off 317 318 319 #--------------------------------------------------------------------------- 349 #log_lock_waits = off # log lock waits >= deadlock_timeout 350 #log_statement = 'none' # none, ddl, mod, all 351 #log_temp_files = -1 # log temporary files equal or larger 352 # than specified size; 353 # -1 disables, 0 logs all temp files 354 #log_timezone = unknown # actually, defaults to TZ environment 355 # setting 356 357 358 #------------------------------------------------------------------------------ 320 359 # RUNTIME STATISTICS 321 #--------------------------------------------------------------------------- 360 #------------------------------------------------------------------------------ 361 362 # - Query/Index Statistics Collector - 363 364 #track_activities = on 365 #track_counts = on 366 #update_process_title = on 367 322 368 323 369 # - Statistics Monitoring - … … 328 374 #log_statement_stats = off 329 375 330 # - Query/Index Statistics Collector - 331 332 #stats_start_collector = on 333 #stats_command_string = off 334 #stats_block_level = off 335 stats_row_level = on 336 #stats_reset_on_server_start = off 337 338 339 #--------------------------------------------------------------------------- 376 377 #------------------------------------------------------------------------------ 340 378 # AUTOVACUUM PARAMETERS 341 #--------------------------------------------------------------------------- 342 343 autovacuum = on # enable autovacuum subprocess? 344 #autovacuum_naptime = 60 # time between autovacuum runs, in secs 345 #autovacuum_vacuum_threshold = 1000 # min # of tuple updates before 379 #------------------------------------------------------------------------------ 380 381 #autovacuum = on # Enable autovacuum subprocess? 'on' 382 # requires track_counts to also be on. 383 #log_autovacuum_min_duration = -1 # -1 disables, 0 logs all actions and 384 # their durations, > 0 logs only 385 # actions running at least that time. 386 #autovacuum_max_workers = 3 # max number of autovacuum subprocesses 387 #autovacuum_naptime = 1min # time between autovacuum runs 388 #autovacuum_vacuum_threshold = 50 # min number of row updates before 346 389 # vacuum 347 #autovacuum_analyze_threshold = 50 0 # min # of tupleupdates before390 #autovacuum_analyze_threshold = 50 # min number of row updates before 348 391 # analyze 349 #autovacuum_vacuum_scale_factor = 0. 4 # fraction of rel size before350 # vacuum 351 #autovacuum_ analyze_scale_factor = 0.2 # fraction of rel size before352 # analyze353 #autovacuum_vacuum_cost_delay = -1 # default vacuum cost delay for354 # autovac , -1 means use392 #autovacuum_vacuum_scale_factor = 0.2 # fraction of table size before vacuum 393 #autovacuum_analyze_scale_factor = 0.1 # fraction of table size before analyze 394 #autovacuum_freeze_max_age = 200000000 # maximum XID age before forced vacuum 395 # (change requires restart) 396 #autovacuum_vacuum_cost_delay = 20 # default vacuum cost delay for 397 # autovacuum, -1 means use 355 398 # vacuum_cost_delay 356 #autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for 357 # autovac , -1 means use399 #autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for 400 # autovacuum, -1 means use 358 401 # vacuum_cost_limit 359 402 360 403 361 #--------------------------------------------------------------------------- 404 #------------------------------------------------------------------------------ 362 405 # CLIENT CONNECTION DEFAULTS 363 #--------------------------------------------------------------------------- 406 #------------------------------------------------------------------------------ 364 407 365 408 # - Statement Behavior - 366 409 367 #search_path = '$user,public' # schema names 368 #default_tablespace = '' # a tablespace name, '' uses 369 # the default 410 #search_path = '"$user",public' # schema names 411 #default_tablespace = '' # a tablespace name, '' uses the default 412 #temp_tablespaces = '' # a list of tablespace names, '' uses 413 # only default tablespace 370 414 #check_function_bodies = on 371 415 #default_transaction_isolation = 'read committed' 372 416 #default_transaction_read_only = off 373 #statement_timeout = 0 # 0 is disabled, in milliseconds 417 #session_replication_role = 'origin' 418 #statement_timeout = 0 # 0 is disabled 419 #vacuum_freeze_min_age = 100000000 420 #xmlbinary = 'base64' 421 #xmloption = 'content' 374 422 375 423 # - Locale and Formatting - 376 424 377 #datestyle = 'iso, mdy' 378 #timezone = unknown # actually, defaults to TZ 379 # environment setting 380 #australian_timezones = off 425 datestyle = 'iso, mdy' 426 #timezone = unknown # actually, defaults to TZ environment 427 # setting 428 #timezone_abbreviations = 'Default' # Select the set of available time zone 429 # abbreviations. Currently, there are 430 # Default 431 # Australia 432 # India 433 # You can create your own file in 434 # share/timezonesets/. 381 435 #extra_float_digits = 0 # min -15, max 2 382 436 #client_encoding = sql_ascii # actually, defaults to database 383 437 # encoding 384 438 385 # These settings are initialized by initdb -- they might be changed386 lc_messages = 'C' # locale for system error message 439 # These settings are initialized by initdb, but they can be changed. 440 lc_messages = 'C' # locale for system error message 387 441 # strings 388 442 lc_monetary = 'C' # locale for monetary formatting … … 390 444 lc_time = 'C' # locale for time formatting 391 445 446 # default configuration for text search 447 default_text_search_config = 'pg_catalog.english' 448 392 449 # - Other Defaults - 393 450 394 451 #explain_pretty_print = on 395 452 #dynamic_library_path = '$libdir' 396 397 398 #--------------------------------------------------------------------------- 453 #local_preload_libraries = '' 454 455 456 #------------------------------------------------------------------------------ 399 457 # LOCK MANAGEMENT 400 #--------------------------------------------------------------------------- 401 402 #deadlock_timeout = 1 000 # in milliseconds458 #------------------------------------------------------------------------------ 459 460 #deadlock_timeout = 1s 403 461 #max_locks_per_transaction = 64 # min 10 404 # note: each lock table slot uses ~220 bytes of shared memory, and there are 462 # (change requires restart) 463 # Note: Each lock table slot uses ~270 bytes of shared memory, and there are 405 464 # max_locks_per_transaction * (max_connections + max_prepared_transactions) 406 465 # lock table slots. 407 466 408 467 409 #--------------------------------------------------------------------------- 468 #------------------------------------------------------------------------------ 410 469 # VERSION/PLATFORM COMPATIBILITY 411 #--------------------------------------------------------------------------- 412 413 # - Previous Postgre sVersions -470 #------------------------------------------------------------------------------ 471 472 # - Previous PostgreSQL Versions - 414 473 415 474 #add_missing_from = off 475 #array_nulls = on 416 476 #backslash_quote = safe_encoding # on, off, or safe_encoding 417 477 #default_with_oids = off 418 #escape_string_warning = o ff478 #escape_string_warning = on 419 479 #regex_flavor = advanced # advanced, extended, or basic 420 480 #sql_inheritance = on 421 422 # - Other Platforms & Clients - 481 #standard_conforming_strings = off 482 #synchronize_seqscans = on 483 484 # - Other Platforms and Clients - 423 485 424 486 #transform_null_equals = off 425 487 426 488 427 #--------------------------------------------------------------------------- 489 #------------------------------------------------------------------------------ 428 490 # CUSTOMIZED OPTIONS 429 #--------------------------------------------------------------------------- 491 #------------------------------------------------------------------------------ 430 492 431 493 #custom_variable_classes = '' # list of custom variable class names
Note: See TracChangeset
for help on using the changeset viewer.
