Обсуждение: BUG #4768: FATAL:could not reattach to shared memory:487
The following bug has been logged online:
Bug reference: 4768
Logged by: grouvi
Email address: ghr@sylob.com
PostgreSQL version: 8.3.7
Operating system: Windows 2008 x64
Description: FATAL:could not reattach to shared memory:487
Details:
Symptoms:
My DB update scripts crashes with the following error message
FATAL: could not reattach to shared memory (key=288, addr=02020000): 487
The problem occurs with both autovacuum turned on or off.
Configuration:
-> PostgreSQL 8.3.7
->Windows 2008 64 bits.
It is a normal install.
I have no antivirus nor Firewall.
There is the Windows Firewall but the problem still occurs while it is
turned off.
Thanks for help.
Here is my full postgresql.conf
# -----------------------------
# 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 paramters can be changed at run
time
# with the "SET" SQL command.
#
# Memory units: kB = kilobytes MB = megabytes GB = gigabytes
# Time units: ms = milliseconds s = seconds 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 = '*' # 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 = 200 # 200 pour éviter des "too many clients already"
# 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 = 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_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)
#password_encryption = on
#db_user_namespace = off
# Kerberos and GSSAPI
#krb_server_keyfile = '' # (change requires restart)
#krb_srvname = 'postgres' # (change requires restart, Kerberos only)
#krb_server_hostname = '' # empty string matches any keytab entry
# (change requires restart, Kerberos only)
#krb_caseins_users = off # (change requires restart)
#krb_realm = '' # (change requires restart)
# - 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 = 32MB # min 128kB or max_connections*16kB
# (change requires restart)
#temp_buffers = 8MB # min 800kB
max_prepared_transactions = 200 # can be 0 or more
# (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 = 1MB # min 64kB
#maintenance_work_mem = 16MB # min 1MB
#max_stack_depth = 2MB # min 100kB
# - Free Space Map -
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
# (change requires restart)
shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll' #
(change requires restart)
# - Cost-Based Vacuum Delay -
#vacuum_cost_delay = 0 # 0-1000 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
#---------------------------------------------------------------------------
---
# WRITE AHEAD LOG
#---------------------------------------------------------------------------
---
# - Settings -
#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 is off
# - 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
# time; 0 is off
#---------------------------------------------------------------------------
---
# QUERY TUNING
#---------------------------------------------------------------------------
---
# - Planner Method Configuration -
#enable_bitmapscan = on
#enable_hashagg = on
#enable_hashjoin = on
#enable_indexscan = 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
# - Other Planner Options -
#default_statistics_target = 10 # range 1-1000
#constraint_exclusion = off
#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 = on # 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 = on # 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 to disable.
#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:
#syslog_facility = 'LOCAL0'
#syslog_ident = 'postgres'
# - 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 = notice # values in order of decreasing detail:
# debug5
# debug4
# debug3
# debug2
# debug1
# info
# notice
# warning
# error
# log
# fatal
# panic
#log_error_verbosity = default # terse, default, or verbose messages
#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 time.
#silent_mode = off # DO NOT USE without syslog or
# logging_collector
# (change requires restart)
# - What to Log -
#debug_print_parse = off
#debug_print_rewritten = off
#debug_print_plan = off
#debug_pretty_print = off
#log_checkpoints = off
#log_connections = off
#log_disconnections = off
#log_duration = off
#log_hostname = off
log_line_prefix = '%t Tx[%x] cmd[%i] PID[%p] DB[%d] '
# special values:
# %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
# %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 specified size;
# -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
update_process_title = on
# - Statistics Monitoring -
#log_parser_stats = off
#log_planner_stats = off
#log_executor_stats = off
#log_statement_stats = off
#---------------------------------------------------------------------------
---
# AUTOVACUUM PARAMETERS
#---------------------------------------------------------------------------
---
autovacuum = off # 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 that time.
#autovacuum_max_workers = 3 # max number of autovacuum subprocesses
#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 = 20 # default vacuum cost delay for
# autovacuum, -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 # 0 is disabled
#vacuum_freeze_min_age = 100000000
#xmlbinary = 'base64'
#xmloption = 'content'
# - Locale and Formatting -
datestyle = 'iso, mdy'
#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 2
#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 -
#explain_pretty_print = on
#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 -
#add_missing_from = off
#array_nulls = on
#backslash_quote = safe_encoding # on, off, or safe_encoding
#default_with_oids = off
#escape_string_warning = on
#regex_flavor = advanced # advanced, extended, or basic
#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
This is a known problem. I think stoping/starting the server will fix it. We hope to find the cause soon. --------------------------------------------------------------------------- grouvi wrote: > > The following bug has been logged online: > > Bug reference: 4768 > Logged by: grouvi > Email address: ghr@sylob.com > PostgreSQL version: 8.3.7 > Operating system: Windows 2008 x64 > Description: FATAL:could not reattach to shared memory:487 > Details: > > Symptoms: > My DB update scripts crashes with the following error message > FATAL: could not reattach to shared memory (key=288, addr=02020000): 487 > The problem occurs with both autovacuum turned on or off. > > > Configuration: > -> PostgreSQL 8.3.7 > ->Windows 2008 64 bits. > It is a normal install. > I have no antivirus nor Firewall. > There is the Windows Firewall but the problem still occurs while it is > turned off. > > > > Thanks for help. > > > Here is my full postgresql.conf > > # ----------------------------- > # 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 paramters can be changed at run > time > # with the "SET" SQL command. > # > # Memory units: kB = kilobytes MB = megabytes GB = gigabytes > # Time units: ms = milliseconds s = seconds 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 = '*' # 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 = 200 # 200 pour éviter des "too many clients already" > # 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 = 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_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) > #password_encryption = on > #db_user_namespace = off > > # Kerberos and GSSAPI > #krb_server_keyfile = '' # (change requires restart) > #krb_srvname = 'postgres' # (change requires restart, Kerberos only) > #krb_server_hostname = '' # empty string matches any keytab entry > # (change requires restart, Kerberos only) > #krb_caseins_users = off # (change requires restart) > #krb_realm = '' # (change requires restart) > > # - 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 = 32MB # min 128kB or max_connections*16kB > # (change requires restart) > #temp_buffers = 8MB # min 800kB > max_prepared_transactions = 200 # can be 0 or more > # (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 = 1MB # min 64kB > #maintenance_work_mem = 16MB # min 1MB > #max_stack_depth = 2MB # min 100kB > > # - Free Space Map - > > 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 > # (change requires restart) > shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll' # > (change requires restart) > > # - Cost-Based Vacuum Delay - > > #vacuum_cost_delay = 0 # 0-1000 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 > > > #--------------------------------------------------------------------------- > --- > # WRITE AHEAD LOG > #--------------------------------------------------------------------------- > --- > > # - Settings - > > #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 is off > > # - 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 > # time; 0 is off > > > #--------------------------------------------------------------------------- > --- > # QUERY TUNING > #--------------------------------------------------------------------------- > --- > > # - Planner Method Configuration - > > #enable_bitmapscan = on > #enable_hashagg = on > #enable_hashjoin = on > #enable_indexscan = 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 > > # - Other Planner Options - > > #default_statistics_target = 10 # range 1-1000 > #constraint_exclusion = off > #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 = on # 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 = on # 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 to disable. > #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: > #syslog_facility = 'LOCAL0' > #syslog_ident = 'postgres' > > > # - 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 = notice # values in order of decreasing detail: > # debug5 > # debug4 > # debug3 > # debug2 > # debug1 > # info > # notice > # warning > # error > # log > # fatal > # panic > > #log_error_verbosity = default # terse, default, or verbose messages > > #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 time. > > #silent_mode = off # DO NOT USE without syslog or > # logging_collector > # (change requires restart) > > # - What to Log - > > #debug_print_parse = off > #debug_print_rewritten = off > #debug_print_plan = off > #debug_pretty_print = off > #log_checkpoints = off > #log_connections = off > #log_disconnections = off > #log_duration = off > #log_hostname = off > log_line_prefix = '%t Tx[%x] cmd[%i] PID[%p] DB[%d] ' > # special values: > # %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 > # %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 specified size; > # -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 > update_process_title = on > > > # - Statistics Monitoring - > > #log_parser_stats = off > #log_planner_stats = off > #log_executor_stats = off > #log_statement_stats = off > > > #--------------------------------------------------------------------------- > --- > # AUTOVACUUM PARAMETERS > #--------------------------------------------------------------------------- > --- > > autovacuum = off # 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 that time. > #autovacuum_max_workers = 3 # max number of autovacuum subprocesses > #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 = 20 # default vacuum cost delay for > # autovacuum, -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 # 0 is disabled > #vacuum_freeze_min_age = 100000000 > #xmlbinary = 'base64' > #xmloption = 'content' > > # - Locale and Formatting - > > datestyle = 'iso, mdy' > #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 2 > #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 - > > #explain_pretty_print = on > #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 - > > #add_missing_from = off > #array_nulls = on > #backslash_quote = safe_encoding # on, off, or safe_encoding > #default_with_oids = off > #escape_string_warning = on > #regex_flavor = advanced # advanced, extended, or basic > #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 > > -- > Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-bugs -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
Thanks for your answer. Stoping/starting the server does not solve the problem. It reappears quickly. As a work around I still run my DB on Linux Red Hat with Postgres 8.1, but i would like to move to the new Windows 2008 server. How can I know when a fix will be released ? -----Message d'origine----- De=A0: Bruce Momjian [mailto:bruce@momjian.us]=20 Envoy=E9=A0: mardi 21 avril 2009 16:14 =C0=A0: grouvi Cc=A0: pgsql-bugs@postgresql.org Objet=A0: Re: [BUGS] BUG #4768: FATAL:could not reattach to shared memory:4= 87 This is a known problem. I think stoping/starting the server will fix it. We hope to find the cause soon. --------------------------------------------------------------------------- grouvi wrote: >=20 > The following bug has been logged online: >=20 > Bug reference: 4768 > Logged by: grouvi > Email address: ghr@sylob.com > PostgreSQL version: 8.3.7 > Operating system: Windows 2008 x64 > Description: FATAL:could not reattach to shared memory:487 > Details:=20 >=20 > Symptoms: > My DB update scripts crashes with the following error message > FATAL: could not reattach to shared memory (key=3D288, addr=3D02020000):= 487 > The problem occurs with both autovacuum turned on or off. >=20 >=20 > Configuration: > -> PostgreSQL 8.3.7 > ->Windows 2008 64 bits. > It is a normal install.=20 > I have no antivirus nor Firewall. > There is the Windows Firewall but the problem still occurs while it is > turned off. >=20 >=20 >=20 > Thanks for help. >=20 >=20 > Here is my full postgresql.conf >=20 > # ----------------------------- > # PostgreSQL configuration file > # ----------------------------- > # > # This file consists of lines of the form: > # > # name =3D value > # > # (The "=3D" is optional.) Whitespace may be used. Comments are introdu= ced > 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=3Don". Some paramters can be changed at r= un > time > # with the "SET" SQL command. > # > # Memory units: kB =3D kilobytes MB =3D megabytes GB =3D gigabytes > # Time units: ms =3D milliseconds s =3D seconds min =3D minutes h =3D = hours d =3D > days >=20 >=20 > #--------------------------------------------------------------------------- > --- > # FILE LOCATIONS > #--------------------------------------------------------------------------- > --- >=20 > # The default values of these variables are driven from the -D command-line > # option or PGDATA environment variable, represented here as ConfigDir. >=20 > #data_directory =3D 'ConfigDir' # use data in another directory > # (change requires restart) > #hba_file =3D 'ConfigDir/pg_hba.conf' # host-based authentication file > # (change requires restart) > #ident_file =3D 'ConfigDir/pg_ident.conf' # ident configuration file > # (change requires restart) >=20 > # If external_pid_file is not explicitly set, no extra PID file is written. > #external_pid_file =3D '(none)' # write an extra PID file > # (change requires restart) >=20 >=20 > #--------------------------------------------------------------------------- > --- > # CONNECTIONS AND AUTHENTICATION > #--------------------------------------------------------------------------- > --- >=20 > # - Connection Settings - >=20 > listen_addresses =3D '*' # what IP address(es) to listen on; > # comma-separated list of addresses; > # defaults to 'localhost', '*' =3D all > # (change requires restart) > port =3D 5432 # (change requires restart) > max_connections =3D 200 # 200 pour =C3=A9viter des "too many clients a= lready" > # Note: Increasing max_connections costs ~400 bytes of shared memory per= =20 > # 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 =3D 3 # (change requires restart) > #unix_socket_directory =3D '' # (change requires restart) > #unix_socket_group =3D '' # (change requires restart) > #unix_socket_permissions =3D 0777 # begin with 0 to use octal notation > # (change requires restart) > #bonjour_name =3D '' # defaults to the computer name > # (change requires restart) >=20 > # - Security and Authentication - >=20 > #authentication_timeout =3D 1min # 1s-600s > #ssl =3D off # (change requires restart) > #ssl_ciphers =3D 'ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH' # allowed SSL ciphers > # (change requires restart) > #password_encryption =3D on > #db_user_namespace =3D off >=20 > # Kerberos and GSSAPI > #krb_server_keyfile =3D '' # (change requires restart) > #krb_srvname =3D 'postgres' # (change requires restart, Kerberos only) > #krb_server_hostname =3D '' # empty string matches any keytab entry > # (change requires restart, Kerberos only) > #krb_caseins_users =3D off # (change requires restart) > #krb_realm =3D '' # (change requires restart) >=20 > # - TCP Keepalives - > # see "man 7 tcp" for details >=20 > #tcp_keepalives_idle =3D 0 # TCP_KEEPIDLE, in seconds; > # 0 selects the system default > #tcp_keepalives_interval =3D 0 # TCP_KEEPINTVL, in seconds; > # 0 selects the system default > #tcp_keepalives_count =3D 0 # TCP_KEEPCNT; > # 0 selects the system default >=20 >=20 > #--------------------------------------------------------------------------- > --- > # RESOURCE USAGE (except WAL) > #--------------------------------------------------------------------------- > --- >=20 > # - Memory - >=20 > shared_buffers =3D 32MB # min 128kB or max_connections*16kB > # (change requires restart) > #temp_buffers =3D 8MB # min 800kB > max_prepared_transactions =3D 200 # can be 0 or more > # (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 =3D 1MB # min 64kB > #maintenance_work_mem =3D 16MB # min 1MB > #max_stack_depth =3D 2MB # min 100kB >=20 > # - Free Space Map - >=20 > max_fsm_pages =3D 204800 # min max_fsm_relations*16, 6 bytes e= ach > # (change requires restart) > #max_fsm_relations =3D 1000 # min 100, ~70 bytes each > # (change requires restart) >=20 > # - Kernel Resource Usage - >=20 > #max_files_per_process =3D 1000 # min 25 > # (change requires restart) > shared_preload_libraries =3D '$libdir/plugins/plugin_debugger.dll' = # > (change requires restart) >=20 > # - Cost-Based Vacuum Delay - >=20 > #vacuum_cost_delay =3D 0 # 0-1000 milliseconds > #vacuum_cost_page_hit =3D 1 # 0-10000 credits > #vacuum_cost_page_miss =3D 10 # 0-10000 credits > #vacuum_cost_page_dirty =3D 20 # 0-10000 credits > #vacuum_cost_limit =3D 200 # 1-10000 credits >=20 > # - Background Writer - >=20 > #bgwriter_delay =3D 200ms # 10-10000ms between rounds > #bgwriter_lru_maxpages =3D 100 # 0-1000 max buffers written/round > #bgwriter_lru_multiplier =3D 2.0 # 0-10.0 multipler on buffers > scanned/round >=20 >=20 > #--------------------------------------------------------------------------- > --- > # WRITE AHEAD LOG > #--------------------------------------------------------------------------- > --- >=20 > # - Settings - >=20 > #fsync =3D on # turns forced synchronization on or off > #synchronous_commit =3D on # immediate fsync at commit > #wal_sync_method =3D fsync # the default is the first option=20 > # supported by the operating system: > # open_datasync > # fdatasync > # fsync > # fsync_writethrough > # open_sync > #full_page_writes =3D on # recover from partial page writes > #wal_buffers =3D 64kB # min 32kB > # (change requires restart) > #wal_writer_delay =3D 200ms # 1-10000 milliseconds >=20 > #commit_delay =3D 0 # range 0-100000, in microseconds > #commit_siblings =3D 5 # range 1-1000 >=20 > # - Checkpoints - >=20 > #checkpoint_segments =3D 3 # in logfile segments, min 1, 16MB each > #checkpoint_timeout =3D 5min # range 30s-1h > #checkpoint_completion_target =3D 0.5 # checkpoint target duration, 0.= 0 - > 1.0 > #checkpoint_warning =3D 30s # 0 is off >=20 > # - Archiving - >=20 > #archive_mode =3D off # allows archiving to be done > # (change requires restart) > #archive_command =3D '' # command to use to archive a logfile segm= ent > #archive_timeout =3D 0 # force a logfile segment switch after this > # time; 0 is off >=20 >=20 > #--------------------------------------------------------------------------- > --- > # QUERY TUNING > #--------------------------------------------------------------------------- > --- >=20 > # - Planner Method Configuration - >=20 > #enable_bitmapscan =3D on > #enable_hashagg =3D on > #enable_hashjoin =3D on > #enable_indexscan =3D on > #enable_mergejoin =3D on > #enable_nestloop =3D on > #enable_seqscan =3D on > #enable_sort =3D on > #enable_tidscan =3D on >=20 > # - Planner Cost Constants - >=20 > #seq_page_cost =3D 1.0 # measured on an arbitrary scale > #random_page_cost =3D 4.0 # same scale as above > #cpu_tuple_cost =3D 0.01 # same scale as above > #cpu_index_tuple_cost =3D 0.005 # same scale as above > #cpu_operator_cost =3D 0.0025 # same scale as above > #effective_cache_size =3D 128MB >=20 > # - Genetic Query Optimizer - >=20 > #geqo =3D on > #geqo_threshold =3D 12 > #geqo_effort =3D 5 # range 1-10 > #geqo_pool_size =3D 0 # selects default based on effort > #geqo_generations =3D 0 # selects default based on effort > #geqo_selection_bias =3D 2.0 # range 1.5-2.0 >=20 > # - Other Planner Options - >=20 > #default_statistics_target =3D 10 # range 1-1000 > #constraint_exclusion =3D off > #from_collapse_limit =3D 8 > #join_collapse_limit =3D 8 # 1 disables collapsing of explicit=20 > # JOIN clauses >=20 >=20 > #--------------------------------------------------------------------------- > --- > # ERROR REPORTING AND LOGGING > #--------------------------------------------------------------------------- > --- >=20 > # - Where to Log - >=20 > log_destination =3D 'stderr' # Valid values are combinations of > # stderr, csvlog, syslog and eventlog, > # depending on platform. csvlog > # requires logging_collector to be on. >=20 > # This is used when logging to stderr: > logging_collector =3D on # Enable capturing of stderr and csvlog > # into log files. Required to be on for > # csvlogs. > # (change requires restart) >=20 > # These are only used if logging_collector is on: > #log_directory =3D 'pg_log' # directory where log files are writte= n, > # can be absolute or relative to PGDATA > #log_filename =3D 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name > pattern, > # can include strftime() escapes > #log_truncate_on_rotation =3D on # 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 =3D 1d # Automatic rotation of logfiles will > # happen after that time. 0 to disable. > #log_rotation_size =3D 10MB # Automatic rotation of logfiles will= =20 > # happen after that much log output. > # 0 to disable. >=20 > # These are relevant when logging to syslog: > #syslog_facility =3D 'LOCAL0' > #syslog_ident =3D 'postgres' >=20 >=20 > # - When to Log - >=20 > #client_min_messages =3D notice # values in order of decreasing > detail: > # debug5 > # debug4 > # debug3 > # debug2 > # debug1 > # log > # notice > # warning > # error >=20 > #log_min_messages =3D notice # values in order of decreasing detai= l: > # debug5 > # debug4 > # debug3 > # debug2 > # debug1 > # info > # notice > # warning > # error > # log > # fatal > # panic >=20 > #log_error_verbosity =3D default # terse, default, or verbose messages >=20 > #log_min_error_statement =3D error # values in order of decreasing detail: > # debug5 > # debug4 > # debug3 > # debug2 > # debug1 > # info > # notice > # warning > # error > # log > # fatal > # panic (effectively off) >=20 > #log_min_duration_statement =3D -1 # -1 is disabled, 0 logs all statements > # and their durations, > 0 logs only > # statements running at least this time. >=20 > #silent_mode =3D off # DO NOT USE without syslog or > # logging_collector > # (change requires restart) >=20 > # - What to Log - >=20 > #debug_print_parse =3D off > #debug_print_rewritten =3D off > #debug_print_plan =3D off > #debug_pretty_print =3D off > #log_checkpoints =3D off > #log_connections =3D off > #log_disconnections =3D off > #log_duration =3D off > #log_hostname =3D off > log_line_prefix =3D '%t Tx[%x] cmd[%i] PID[%p] DB[%d] ' > # special values: > # %u =3D user name > # %d =3D database name > # %r =3D remote host and port > # %h =3D remote host > # %p =3D process ID > # %t =3D timestamp without milliseconds > # %m =3D timestamp with milliseconds > # %i =3D command tag > # %c =3D session ID > # %l =3D session line number > # %s =3D session start timestamp > # %v =3D virtual transaction ID > # %x =3D transaction ID (0 if none) > # %q =3D stop here in non-session > # processes > # %% =3D '%' > # e.g. '<%u%%%d> ' > #log_lock_waits =3D off # log lock waits >=3D deadlock_timeout > #log_statement =3D 'none' # none, ddl, mod, all > #log_temp_files =3D -1 # log temporary files equal or larger > # than specified size; > # -1 disables, 0 logs all temp files > #log_timezone =3D unknown # actually, defaults to TZ environme= nt > # setting >=20 >=20 > #--------------------------------------------------------------------------- > --- > # RUNTIME STATISTICS > #--------------------------------------------------------------------------- > --- >=20 > # - Query/Index Statistics Collector - >=20 > track_activities =3D on > track_counts =3D on > update_process_title =3D on >=20 >=20 > # - Statistics Monitoring - >=20 > #log_parser_stats =3D off > #log_planner_stats =3D off > #log_executor_stats =3D off > #log_statement_stats =3D off >=20 >=20 > #--------------------------------------------------------------------------- > --- > # AUTOVACUUM PARAMETERS > #--------------------------------------------------------------------------- > --- >=20 > autovacuum =3D off # Enable autovacuum subprocess? 'on'=20 > # requires track_counts to also be on. > #log_autovacuum_min_duration =3D -1 # -1 disables, 0 logs all actions = and > # their durations, > 0 logs only > # actions running at least that time. > #autovacuum_max_workers =3D 3 # max number of autovacuum subproces= ses > #autovacuum_naptime =3D 1min # time between autovacuum runs > autovacuum_vacuum_threshold =3D 50 # min number of row updates before > # vacuum > autovacuum_analyze_threshold =3D 50 # min number of row updates before= =20 > # analyze > autovacuum_vacuum_scale_factor =3D 0.2 # fraction of table size before > vacuum > autovacuum_analyze_scale_factor =3D 0.1 # fraction of table size before > analyze > autovacuum_freeze_max_age =3D 200000000 # maximum XID age before forced > vacuum > # (change requires restart) > autovacuum_vacuum_cost_delay =3D 20 # default vacuum cost delay for > # autovacuum, -1 means use > # vacuum_cost_delay > autovacuum_vacuum_cost_limit =3D -1 # default vacuum cost limit for > # autovacuum, -1 means use > # vacuum_cost_limit >=20 >=20 > #--------------------------------------------------------------------------- > --- > # CLIENT CONNECTION DEFAULTS > #--------------------------------------------------------------------------- > --- >=20 > # - Statement Behavior - >=20 > #search_path =3D '"$user",public' # schema names > #default_tablespace =3D '' # a tablespace name, '' uses the default > #temp_tablespaces =3D '' # a list of tablespace names, '' uses > # only default tablespace > #check_function_bodies =3D on > #default_transaction_isolation =3D 'read committed' > #default_transaction_read_only =3D off > #session_replication_role =3D 'origin' > #statement_timeout =3D 0 # 0 is disabled > #vacuum_freeze_min_age =3D 100000000 > #xmlbinary =3D 'base64' > #xmloption =3D 'content' >=20 > # - Locale and Formatting - >=20 > datestyle =3D 'iso, mdy' > #timezone =3D unknown # actually, defaults to TZ environment > # setting > #timezone_abbreviations =3D 'Default' # Select the set of available t= ime > zone > # abbreviations. Currently, there are > # Default > # Australia > # India > # You can create your own file in > # share/timezonesets/. > #extra_float_digits =3D 0 # min -15, max 2 > #client_encoding =3D sql_ascii # actually, defaults to database > # encoding >=20 > # These settings are initialized by initdb, but they can be changed. > lc_messages =3D 'C' # locale for system error message > # strings > lc_monetary =3D 'C' # locale for monetary formatting > lc_numeric =3D 'C' # locale for number formatting > lc_time =3D 'C' # locale for time formatting >=20 > # default configuration for text search > default_text_search_config =3D 'pg_catalog.english' >=20 > # - Other Defaults - >=20 > #explain_pretty_print =3D on > #dynamic_library_path =3D '$libdir' > #local_preload_libraries =3D '' >=20 >=20 > #--------------------------------------------------------------------------- > --- > # LOCK MANAGEMENT > #--------------------------------------------------------------------------- > --- >=20 > #deadlock_timeout =3D 1s > #max_locks_per_transaction =3D 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. >=20 >=20 > #--------------------------------------------------------------------------- > --- > # VERSION/PLATFORM COMPATIBILITY > #--------------------------------------------------------------------------- > --- >=20 > # - Previous PostgreSQL Versions - >=20 > #add_missing_from =3D off > #array_nulls =3D on > #backslash_quote =3D safe_encoding # on, off, or safe_encoding > #default_with_oids =3D off > #escape_string_warning =3D on > #regex_flavor =3D advanced # advanced, extended, or basic > #sql_inheritance =3D on > #standard_conforming_strings =3D off > #synchronize_seqscans =3D on >=20 > # - Other Platforms and Clients - >=20 > #transform_null_equals =3D off >=20 >=20 > #--------------------------------------------------------------------------- > --- > # CUSTOMIZED OPTIONS > #--------------------------------------------------------------------------- > --- >=20 > #custom_variable_classes =3D '' # list of custom variable class na= mes >=20 > --=20 > Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-bugs --=20 Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. +