From: <rm...@hy...> - 2007-11-27 16:09:57
|
Author: rmorgan Date: 2007-11-27 08:09:53 -0800 (Tue, 27 Nov 2007) New Revision: 26 Modified: trunk/x86-linux/conf/pg_hba.conf trunk/x86-linux/conf/pg_ident.conf trunk/x86-linux/conf/postgresql.conf trunk/x86-linux/pgsql.tar.gz Log: Update to 8.2.5. Modified: trunk/x86-linux/conf/pg_hba.conf =================================================================== --- trunk/x86-linux/conf/pg_hba.conf 2007-11-27 16:09:15 UTC (rev 25) +++ trunk/x86-linux/conf/pg_hba.conf 2007-11-27 16:09:53 UTC (rev 26) @@ -1,62 +1,75 @@ # PostgreSQL Client Authentication Configuration File # =================================================== # -# Refer to the PostgreSQL Administrator's Guide, chapter "Client -# Authentication" for a complete description. A short synopsis -# follows. +# 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 seven forms: +# databases they can access. Records take one of these forms: # # local DATABASE USER METHOD [OPTION] -# host DATABASE USER IP-ADDRESS IP-MASK METHOD [OPTION] -# hostssl DATABASE USER IP-ADDRESS IP-MASK METHOD [OPTION] -# hostnossl DATABASE USER IP-ADDRESS IP-MASK METHOD [OPTION] -# host DATABASE USER IP-ADDRESS/CIDR-MASK METHOD [OPTION] -# hostssl DATABASE USER IP-ADDRESS/CIDR-MASK METHOD [OPTION] -# hostnossl DATABASE USER IP-ADDRESS/CIDR-MASK METHOD [OPTION] +# host DATABASE USER CIDR-ADDRESS METHOD [OPTION] +# hostssl DATABASE USER CIDR-ADDRESS METHOD [OPTION] +# hostnossl DATABASE USER CIDR-ADDRESS METHOD [OPTION] # -# (The uppercase quantities should be replaced by actual values.) +# (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", "samegroup", a database name (or -# a comma-separated list thereof), or a file name prefixed with "@". -# USER can be "all", an actual user name or a group name prefixed with -# "+" or a list containing either. IP-ADDRESS and IP-MASK specify the -# set of hosts the record matches. CIDR-MASK is an integer between 0 -# and 32 (IPv6) or 128(IPv6) inclusive, that specifies the number of -# significant bits in the mask, so an IPv4 CIDR-MASK of 8 is equivalent -# to an IP-MASK of 255.0.0.0, and an IPv6 CIDR-MASK of 64 is equivalent -# to an IP-MASK of ffff:ffff:ffff:ffff::. METHOD can be "trust", "reject", -# "md5", "crypt", "password", "krb4", "krb5", "ident", or "pam". Note -# that "password" uses clear-text passwords; "md5" is preferred for -# encrypted passwords. OPTION is the ident map or the name of the PAM -# service. # +# DATABASE can be "all", "sameuser", "samerole", 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. +# +# METHOD can be "trust", "reject", "md5", "crypt", "password", +# "krb5", "ident", "pam" or "ldap". Note that "password" sends passwords +# in clear text; "md5" is preferred since it sends encrypted passwords. +# +# OPTION is the ident map or the name of the PAM service, depending on METHOD. +# +# Database and user names containing spaces, commas, quotes and other special +# characters must be quoted. Quoting one of the keywords "all", "sameuser" or +# "samerole" 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, or use -# "pg_ctl reload". +# to SIGHUP the postmaster for the changes to take effect. You can use +# "pg_ctl reload" to do that. # Put your actual configuration here # ---------------------------------- # -# CAUTION: The default configuration allows any local user to connect -# using any PostgreSQL user name, including the superuser, over either -# Unix-domain sockets or TCP/IP. If you are on a multiple-user -# machine, the default configuration is probably too liberal for you. -# Change it to use something other than "trust" authentication. +# 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. # -# If you want to allow non-local connections, you need to add more -# "host" records. Also, remember TCP/IP connections are only enabled -# if you enable "tcpip_socket" in postgresql.conf. -# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD +# 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. -local all all trust -# IPv4-style local connections: -host all all 127.0.0.1 255.255.255.255 trust -# IPv6-style local connections: -host all all ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff trust + +# 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 Modified: trunk/x86-linux/conf/pg_ident.conf =================================================================== --- trunk/x86-linux/conf/pg_ident.conf 2007-11-27 16:09:15 UTC (rev 25) +++ trunk/x86-linux/conf/pg_ident.conf 2007-11-27 16:09:53 UTC (rev 26) @@ -11,18 +11,19 @@ # # MAPNAME IDENT-USERNAME PG-USERNAME # -# (The uppercase quantities should be replaced by actual values.) +# (The uppercase quantities must be replaced by actual values.) +# # MAPNAME is the (otherwise freely chosen) map name that was used in # pg_hba.conf. IDENT-USERNAME is the detected user name of the -# client. PG-USERNAME is the request PostgreSQL user name. The +# client. PG-USERNAME is the requested PostgreSQL user name. The # existence of a record specifies that IDENT-USERNAME may connect as # PG-USERNAME. Multiple maps may be specified in this file and used # by pg_hba.conf. # # 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, or use -# "pg_ctl reload". +# to SIGHUP the postmaster for the changes to take effect. You can use +# "pg_ctl reload" to do that. # Put your actual configuration here # ---------------------------------- Modified: trunk/x86-linux/conf/postgresql.conf =================================================================== --- trunk/x86-linux/conf/postgresql.conf 2007-11-27 16:09:15 UTC (rev 25) +++ trunk/x86-linux/conf/postgresql.conf 2007-11-27 16:09:53 UTC (rev 26) @@ -6,23 +6,26 @@ # # name = value # -# (The '=' is optional.) White space may be used. Comments are introduced -# with '#' anywhere on a line. The complete list of option names and -# allowed values can be found in the PostgreSQL documentation. The +# (The '=' is optional.) White space may be used. Comments are introduced +# with '#' anywhere on a line. The complete list of option names and +# allowed values can be found in the PostgreSQL documentation. The # commented-out settings shown in this file represent the default values. # # Please note that re-commenting a setting is NOT sufficient to revert it -# to the default value, unless you restart the postmaster. +# to the default value, unless you restart the server. # -# Any option can also be given as a command line switch to the -# postmaster, e.g. 'postmaster -c log_connections=on'. Some options -# can be changed at run-time with the 'SET' SQL command. +# Any option can also be given as a command line switch to the server, +# e.g., 'postgres -c log_connections=on'. Some options can be changed at +# run-time with the 'SET' SQL command. # -# This file is read on postmaster startup and when the postmaster -# receives a SIGHUP. If you edit the file on a running system, you have -# to SIGHUP the postmaster for the changes to take effect, or use -# "pg_ctl reload". Some settings, such as listen_address, require -# a postmaster shutdown and restart to take effect. +# This file is read on server startup and when the server receives a +# SIGHUP. 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 +# settings, which are marked below, require a server shutdown and restart +# to take effect. +# +# Memory units: kB = kilobytes MB = megabytes GB = gigabytes +# Time units: ms = milliseconds s = seconds min = minutes h = hours d = days #--------------------------------------------------------------------------- @@ -33,11 +36,15 @@ # switch 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 -#ident_file = 'ConfigDir/pg_ident.conf # IDENT configuration 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 +# 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) #--------------------------------------------------------------------------- @@ -49,29 +56,33 @@ #listen_addresses = 'localhost' # what IP address(es) to listen on; # comma-separated list of addresses; # defaults to 'localhost', '*' = all -port = @@@PGPORT@@@ -max_connections = 100 -# note: increasing max_connections costs ~400 bytes of shared memory per + # (change requires restart) +port = @@@PGPORT@@@ # (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). You # might also need to raise shared_buffers to support more connections. -#superuser_reserved_connections = 2 -#unix_socket_directory = '' -#unix_socket_group = '' +#superuser_reserved_connections = 3 # (change requires restart) +#unix_socket_directory = '' # (change requires restart) +#unix_socket_group = '' # (change requires restart) #unix_socket_permissions = 0777 # octal + # (change requires restart) #bonjour_name = '' # defaults to the computer name + # (change requires restart) # - Security & Authentication - -#authentication_timeout = 60 # 1-600, in seconds -#ssl = off +#authentication_timeout = 1min # 1s-600s +#ssl = off # (change requires restart) #password_encryption = on #db_user_namespace = off # Kerberos -#krb_server_keyfile = '' -#krb_srvname = 'postgres' +#krb_server_keyfile = '' # (change requires restart) +#krb_srvname = 'postgres' # (change requires restart) #krb_server_hostname = '' # empty string matches any keytab entry -#krb_caseins_users = off + # (change requires restart) +#krb_caseins_users = off # (change requires restart) # - TCP Keepalives - # see 'man 7 tcp' for details @@ -90,24 +101,29 @@ # - Memory - -shared_buffers = 10000 # min 16 or max_connections*2, 8KB each -#temp_buffers = 1000 # min 100, 8KB each +shared_buffers = 64MB # min 128kB or max_connections*16kB + # (change requires restart) +#temp_buffers = 8MB # min 800kB #max_prepared_transactions = 5 # can be 0 or more -# note: increasing max_prepared_transactions costs ~600 bytes of shared memory + # (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). -work_mem = 2048 # min 64, size in KB -#maintenance_work_mem = 16384 # min 1024, size in KB -#max_stack_depth = 2048 # min 100, size in KB +work_mem = 2MB # min 64kB +maintenance_work_mem = 32MB # min 1MB +#max_stack_depth = 2MB # min 100kB # - Free Space Map - -#max_fsm_pages = 20000 # min max_fsm_relations*16, 6 bytes each +max_fsm_pages = 204800 # min max_fsm_relations*16, 6 bytes each + # (change requires restart) #max_fsm_relations = 1000 # min 100, ~70 bytes each + # (change requires restart) # - Kernel Resource Usage - #max_files_per_process = 1000 # min 25 -#preload_libraries = '' + # (change requires restart) +#shared_preload_libraries = '' # (change requires restart) # - Cost-Based Vacuum Delay - @@ -119,7 +135,7 @@ # - Background writer - -#bgwriter_delay = 200 # 10-10000 milliseconds between rounds +#bgwriter_delay = 200ms # 10-10000ms between rounds #bgwriter_lru_percent = 1.0 # 0-100% of LRU buffers scanned/round #bgwriter_lru_maxpages = 5 # 0-1000 buffers max written/round #bgwriter_all_percent = 0.333 # 0-100% of all buffers scanned/round @@ -132,7 +148,7 @@ # - Settings - -fsync = off # turns forced synchronization on or off +fsync = on # turns forced synchronization on or off #wal_sync_method = fsync # the default is the first option # supported by the operating system: # open_datasync @@ -141,20 +157,22 @@ # fsync_writethrough # open_sync #full_page_writes = on # recover from partial page writes -#wal_buffers = 8 # min 4, 8KB each +#wal_buffers = 64kB # min 32kB + # (change requires restart) commit_delay = 100000 # range 0-100000, in microseconds #commit_siblings = 5 # range 1-1000 # - Checkpoints - checkpoint_segments = 10 # in logfile segments, min 1, 16MB each -#checkpoint_timeout = 300 # range 30-3600, in seconds -#checkpoint_warning = 30 # in seconds, 0 is off +#checkpoint_timeout = 5min # range 30s-1h +#checkpoint_warning = 30s # 0 is off # - Archiving - -#archive_command = '' # command to use to archive a logfile - # segment +#archive_command = '' # command to use to archive a logfile segment +#archive_timeout = 0 # force a logfile segment switch after this + # many seconds; 0 is off #--------------------------------------------------------------------------- @@ -175,12 +193,12 @@ # - Planner Cost Constants - -#effective_cache_size = 1000 # typically 8KB each -#random_page_cost = 4 # units are one sequential page fetch - # cost -#cpu_tuple_cost = 0.01 # (same) -#cpu_index_tuple_cost = 0.001 # (same) -#cpu_operator_cost = 0.0025 # (same) +#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 - @@ -213,6 +231,7 @@ # This is used when logging to stderr: #redirect_stderr = off # Enable capturing of stderr into log # files + # (change requires restart) # These are only used if redirect_stderr is on: #log_directory = 'pg_log' # Directory where log files are written @@ -227,11 +246,11 @@ # or size-driven rotation. Default is # off, meaning append to existing files # in all cases. -#log_rotation_age = 1440 # Automatic rotation of logfiles will - # happen after so many minutes. 0 to +#log_rotation_age = 1d # Automatic rotation of logfiles will + # happen after that time. 0 to # disable. -#log_rotation_size = 10240 # Automatic rotation of logfiles will - # happen after so many kilobytes of log +#log_rotation_size = 10MB # Automatic rotation of logfiles will + # happen after that much log # output. 0 to disable. # These are relevant when logging to syslog: @@ -268,7 +287,7 @@ #log_error_verbosity = default # terse, default, or verbose messages -#log_min_error_statement = panic # Values in order of increasing severity: +#log_min_error_statement = error # Values in order of increasing severity: # debug5 # debug4 # debug3 @@ -278,13 +297,15 @@ # notice # warning # error - # panic(off) - + # fatal + # panic (effectively off) + #log_min_duration_statement = -1 # -1 is disabled, 0 logs all statements - # and their durations, in milliseconds. + # and their durations. #silent_mode = off # DO NOT USE without syslog or # redirect_stderr + # (change requires restart) # - What to Log - @@ -295,7 +316,7 @@ #log_connections = off #log_disconnections = off #log_duration = off -log_line_prefix = '[%m] ' # Special values: +#log_line_prefix = '' # Special values: # %u = user name # %d = database name # %r = remote host and port @@ -312,7 +333,7 @@ # processes # %% = '%' # e.g. '<%u%%%d> ' -#log_statement = 'none' # none, mod, ddl, all +#log_statement = 'none' # none, ddl, mod, all #log_hostname = off @@ -320,6 +341,18 @@ # RUNTIME STATISTICS #--------------------------------------------------------------------------- +# - Query/Index Statistics Collector - + +#stats_command_string = on +#update_process_title = on + +stats_start_collector = on # needed for block or row stats + # (change requires restart) +stats_block_level = on +stats_row_level = on +stats_reset_on_server_start = off # (change requires restart) + + # - Statistics Monitoring - #log_parser_stats = off @@ -327,34 +360,30 @@ #log_executor_stats = off #log_statement_stats = off -# - Query/Index Statistics Collector - -stats_start_collector = on -#stats_command_string = off -stats_block_level = on -stats_row_level = on -stats_reset_on_server_start = off - - #--------------------------------------------------------------------------- # AUTOVACUUM PARAMETERS #--------------------------------------------------------------------------- #autovacuum = off # enable autovacuum subprocess? -#autovacuum_naptime = 60 # time between autovacuum runs, in secs -#autovacuum_vacuum_threshold = 1000 # min # of tuple updates before + # 'on' requires stats_start_collector + # and stats_row_level to also be on +#autovacuum_naptime = 1min # time between autovacuum runs +#autovacuum_vacuum_threshold = 500 # min # of tuple updates before # vacuum -#autovacuum_analyze_threshold = 500 # min # of tuple updates before +#autovacuum_analyze_threshold = 250 # min # of tuple updates before # analyze -#autovacuum_vacuum_scale_factor = 0.4 # fraction of rel size before +#autovacuum_vacuum_scale_factor = 0.2 # fraction of rel size before # vacuum -#autovacuum_analyze_scale_factor = 0.2 # fraction of rel size before +#autovacuum_analyze_scale_factor = 0.1 # fraction of rel size before # analyze +#autovacuum_freeze_max_age = 200000000 # maximum XID age before forced vacuum + # (change requires restart) #autovacuum_vacuum_cost_delay = -1 # default vacuum cost delay for - # autovac, -1 means use + # autovacuum, -1 means use # vacuum_cost_delay #autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for - # autovac, -1 means use + # autovacuum, -1 means use # vacuum_cost_limit @@ -364,20 +393,27 @@ # - Statement Behavior - -#search_path = '$user,public' # schema names +#search_path = '"$user",public' # schema names #default_tablespace = '' # a tablespace name, '' uses # the default #check_function_bodies = on #default_transaction_isolation = 'read committed' #default_transaction_read_only = off -#statement_timeout = 0 # 0 is disabled, in milliseconds +#statement_timeout = 0 # 0 is disabled +#vacuum_freeze_min_age = 100000000 # - Locale and Formatting - -#datestyle = 'iso, mdy' +datestyle = 'iso, mdy' #timezone = unknown # actually, defaults to TZ # environment setting -#australian_timezones = off +#timezone_abbreviations = 'Default' # select the set of available timezone + # abbreviations. Currently, there are + # Default + # Australia + # India + # However you can also create your own + # file in share/timezonesets/. #extra_float_digits = 0 # min -15, max 2 #client_encoding = sql_ascii # actually, defaults to database # encoding @@ -393,15 +429,17 @@ #explain_pretty_print = on #dynamic_library_path = '$libdir' +#local_preload_libraries = '' #--------------------------------------------------------------------------- # LOCK MANAGEMENT #--------------------------------------------------------------------------- -#deadlock_timeout = 1000 # in milliseconds +#deadlock_timeout = 1s #max_locks_per_transaction = 64 # min 10 -# note: each lock table slot uses ~220 bytes of shared memory, and there are + # (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. @@ -413,10 +451,13 @@ # - Previous Postgres Versions - #add_missing_from = off +#array_nulls = on +#backslash_quote = safe_encoding # on, off, or safe_encoding +#default_with_oids = off +#escape_string_warning = on +#standard_conforming_strings = off #regex_flavor = advanced # advanced, extended, or basic #sql_inheritance = on -#default_with_oids = off -#escape_string_warning = off # - Other Platforms & Clients - Modified: trunk/x86-linux/pgsql.tar.gz =================================================================== (Binary files differ) |