Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gS4iZ-0000i3-8T for pgsql-sql@arkaria.postgresql.org; Wed, 28 Nov 2018 18:37:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gS4iX-00061p-Io for pgsql-sql@arkaria.postgresql.org; Wed, 28 Nov 2018 18:37:45 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gS4iX-00061h-2t for pgsql-sql@lists.postgresql.org; Wed, 28 Nov 2018 18:37:45 +0000 Received: from mail-wm1-x342.google.com ([2a00:1450:4864:20::342]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gS4iP-00052w-1L for pgsql-sql@postgresql.org; Wed, 28 Nov 2018 18:37:44 +0000 Received: by mail-wm1-x342.google.com with SMTP id r11-v6so3692180wmb.2 for ; Wed, 28 Nov 2018 10:37:36 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=message-id:from:to:cc:references:in-reply-to:subject:date :mime-version:thread-index:content-language; bh=id1Y82IYxKL2qGsQSgco2xG5e0p3ucI+/oX2+kVS4sM=; b=Ir2DIXn9IWtzlVj6scQaVvgEp9gDD1E4/8lnYZTjyrD3wn1cMCOahIR3wmyzPKEIdw cd80NOBRM3VC/c2XptVVSqtrQbTBSTySK++tiE5XVCYvg8cwbHidAye1xKBjIW7haj72 K+3BV4JORYiqNermB7KuVeqgMOYGSPmphU3rXozQherjy6L3sAS5V/XDUPYfezUqJewY GkTpMtQl8q/XlvhhPgcIRTOwGsDRj1X12wvqCF4VfJx8noPv43OJ3dyEtufY9ay+THiB W50gMZXykonBVPfsq6Cd59yOCcbZxiSnv3nhl1a5qfp4RcupUFLL/dGil0Fou2ApjeZn QxMA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:from:to:cc:references:in-reply-to :subject:date:mime-version:thread-index:content-language; bh=id1Y82IYxKL2qGsQSgco2xG5e0p3ucI+/oX2+kVS4sM=; b=b+fnMJ5Y9RhBAB7lYR01/+itcE7zlEDC0hxeUTv1yGNmZEkDiFOGSPW7Rk/JkFjAHG KnuN0wg16POsaJ+ELKyhkmyHrM7rnrXX4k5VzLpEDaZCe4cEXSqiMnzFHoVggVMvPDb/ WXVLTxFWtfrexjlL4rPZKBPgDCwJAB3O8WVeAruoobIqYfP9Qc52e3BBEdgckNprj+n3 wT/1Qwi2ZbxQ3wj4N8Q1KVj6teQBWisHEjorXTvFy/XXVHdpQlCe3px95ykk1TKcrjyX WJ15WMz37onZs0+yuU4RBOcfYkGF0ZjSbfaKEKGt1ooGoxN/bbrsxHR82l4KSKshxHYp zomA== X-Gm-Message-State: AA+aEWYSnkPbDPGkVO/C62nWoIQQW8d6HlZANlC5Su8anC64b1budvKa gA6nZMh+c36Urht4Qh6Q2rw= X-Google-Smtp-Source: AFSGD/Vm4BNQg1zEYAWrgl2ECYnGcY8fkG4O+CRU8Hzlr9qnF+qULnT0u+DT9gwtOXAWu/gE7LW8+w== X-Received: by 2002:a1c:2304:: with SMTP id j4mr3760318wmj.14.1543430255517; Wed, 28 Nov 2018 10:37:35 -0800 (PST) Received: from PADOUE (mau78-1-88-184-109-217.fbx.proxad.net. [88.184.109.217]) by smtp.gmail.com with ESMTPSA id d8sm5544778wrw.70.2018.11.28.10.37.29 (version=TLS1 cipher=ECDHE-RSA-AES128-SHA bits=128/128); Wed, 28 Nov 2018 10:37:34 -0800 (PST) Message-ID: <5bfee06e.1c69fb81.5882.f894@mx.google.com> X-Google-Original-Message-ID: <03f501d48749$69446780$3bcd3680$@lepretre@gmail.com> From: =?UTF-8?Q?Olivier_Lepr=C3=AAtre?= To: "'Rene Romero Benavides'" , "'Pavel Stehule'" Cc: References: <5bfe52c2.1c69fb81.f4ac6.53a6@mx.google.com> In-Reply-To: Subject: RE: error code 8 Date: Wed, 28 Nov 2018 19:37:25 +0100 MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_NextPart_000_03F6_01D48751.CB08CF80" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: AdSHQY5DBjH+C/dCQqCXML8DqT9RHgABbhyA Content-Language: fr X-Antivirus: Avast (VPS 181128-4, 28/11/2018), Outbound message X-Antivirus-Status: Clean List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. ------=_NextPart_000_03F6_01D48751.CB08CF80 Content-Type: multipart/alternative; boundary="----=_NextPart_001_03F7_01D48751.CB08CF80" ------=_NextPart_001_03F7_01D48751.CB08CF80 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, =20 Thanks for your answers, I found that it's a Postgresql 32 bits version = installed on a 64 bits machine :-( I didn't imagine that. I guess I'm on the way of getting some = troubles... =20 Have a good day, =20 Olivier =20 De : Rene Romero Benavides [mailto:rene.romero.b@gmail.com]=20 Envoy=C3=A9 : mercredi 28 novembre 2018 18:41 =C3=80 : o.lepretre@gmail.com Cc : pgsql-sql@postgresql.org Objet : Re: error code 8 =20 Share with us the log messages please, also the stack trace. work_mem is 64MB try lowering it, maybe the app is causing the out of = memory messages due to queries using too much memory. =20 Am Mi., 28. Nov. 2018 um 02:33 Uhr schrieb Olivier Lepr=C3=AAtre = : Hi, =20 I get shared "memory exhausted messages". shared buffers where set to = 1Gb. I tried to increase them to 2048 or 1536 and got "error code 8" = when trying to launch with pg_ctl. =20 Windows server 2016 8 Gb Postgresql 9.6 =20 Below is the postgresql.conf file. Is this shared buffer parameter the = main one to change for shared memory problems ?=20 =20 I read " If you have a system with 1GB or more of RAM, a reasonable = starting value for shared_buffers is 1/4 of the memory in your system. " https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server =20 But it seems that I can't go above 1gb, even with a 8 Gbytes memory.=20 =20 What does this error code 8 means, it does not appear here https://www.postgresql.org/docs/9.6/errcodes-appendix.html =20 Thanks for any help, =20 Olivier =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 = 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=3Don". Some parameters can be changed at = run time # with the "SET" SQL command. # # Memory units: kB =3D kilobytes Time units: ms =3D = milliseconds # MB =3D megabytes s =3D seconds # GB =3D gigabytes min =3D minutes # TB =3D terabytes 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 '' # 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'; use '*' for all # (change requires = restart) port =3D 5432 # (change requires restart) max_connections =3D 100 # (change requires = restart) #superuser_reserved_connections =3D 3 # (change requires restart) #unix_socket_directories =3D '' # comma-separated list of = directories # (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 =3D off # advertise server = via Bonjour # (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 'HIGH:MEDIUM:+3DES:!aNULL' # allowed SSL ciphers # (change requires = restart) #ssl_prefer_server_ciphers =3D on # (change requires restart) #ssl_ecdh_curve =3D 'prime256v1' # (change requires restart) #ssl_cert_file =3D 'server.crt' # (change requires = restart) #ssl_key_file =3D 'server.key' # (change requires = restart) #ssl_ca_file =3D '' # (change requires restart) #ssl_crl_file =3D '' # (change requires = restart) #password_encryption =3D on #db_user_namespace =3D off #row_security =3D on =20 # GSSAPI using Kerberos #krb_server_keyfile =3D '' #krb_caseins_users =3D off =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 1024MB # min 128kB # (change requires = restart) #huge_pages =3D try # on, off, or try # (change requires = restart) temp_buffers =3D 16MB # min 800kB #max_prepared_transactions =3D 0 # zero disables the feature # (change requires = restart) # Caution: it is not advisable to set max_prepared_transactions nonzero = unless # you actively intend to use prepared transactions. work_mem =3D 64MB # min = 64kB/Pr=C3=A9c=C3=A9dent 16 maintenance_work_mem =3D 64MB # min 1MB #replacement_sort_tuples =3D 150000 # limits use of replacement = selection sort #autovacuum_work_mem =3D -1 # min 1MB, or -1 to use = maintenance_work_mem #max_stack_depth =3D 2MB # min 100kB dynamic_shared_memory_type =3D windows # the default is the first = option # supported by the = operating system: # posix # sysv # windows # mmap # use none to disable = dynamic shared memory =20 # - Disk - =20 #temp_file_limit =3D -1 # limits per-process = temp file space # in kB, or -1 for no = limit =20 # - Kernel Resource Usage - =20 #max_files_per_process =3D 1000 # min 25 # (change requires = restart) #shared_preload_libraries =3D '' # (change requires = restart) =20 # - Cost-Based Vacuum Delay - =20 #vacuum_cost_delay =3D 0 # 0-100 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 multiplier on = buffers scanned/round #bgwriter_flush_after =3D 0 # 0 disables, # default is 512kB on = linux, 0 otherwise =20 # - Asynchronous Behavior - =20 #effective_io_concurrency =3D 0 # 1-1000; 0 disables = prefetching #max_worker_processes =3D 8 # (change requires restart) #max_parallel_workers_per_gather =3D 0 # taken from max_worker_processes #old_snapshot_threshold =3D -1 # 1min-60d; -1 disables; 0 = is immediate = # (change requires restart) #backend_flush_after =3D 0 # 0 disables, default is 0 =20 =20 #------------------------------------------------------------------------= ------ # WRITE AHEAD LOG #------------------------------------------------------------------------= ------ =20 # - Settings - =20 #wal_level =3D minimal # minimal, replica, or = logical # (change requires = restart) #fsync =3D on # flush data to disk for = crash safety # (turning = this off can cause # = unrecoverable data corruption) #synchronous_commit =3D on # synchronization level; # off, local, = remote_write, remote_apply, or on #wal_sync_method =3D fsync # the default is the first = option # supported by the = operating system: # open_datasync # fdatasync (default = on Linux) # fsync # fsync_writethrough # open_sync #full_page_writes =3D on # recover from partial = page writes #wal_compression =3D off # enable compression of = full-page writes #wal_log_hints =3D off # also do full page = writes of non-critical updates # (change requires = restart) #wal_buffers =3D -1 # min 32kB, -1 sets based on = shared_buffers # (change requires = restart) #wal_writer_delay =3D 200ms # 1-10000 milliseconds #wal_writer_flush_after =3D 1MB # 0 disables =20 #commit_delay =3D 0 # range 0-100000, in microseconds #commit_siblings =3D 5 # range 1-1000 =20 # - Checkpoints - =20 #checkpoint_timeout =3D 5min # range 30s-1d #max_wal_size =3D 1GB #min_wal_size =3D 80MB #checkpoint_completion_target =3D 0.5 # checkpoint target duration, = 0.0 - 1.0 #checkpoint_flush_after =3D 0 # 0 disables, # default is 256kB on = linux, 0 otherwise #checkpoint_warning =3D 30s # 0 disables =20 # - Archiving - =20 #archive_mode =3D off # enables archiving; off, on, or = always # (change requires restart) #archive_command =3D '' # command to use to archive a = logfile segment # placeholders: %p =3D path of = file to archive # %f =3D file name = only # e.g. 'test ! -f = /mnt/server/archivedir/%f && cp %p /mnt/server/archivedir/%f' #archive_timeout =3D 0 # force a logfile segment switch = after this # number of seconds; 0 disables =20 =20 #------------------------------------------------------------------------= ------ # REPLICATION #------------------------------------------------------------------------= ------ =20 # - Sending Server(s) - =20 # Set these on the master and on any standby that will send replication = data. =20 #max_wal_senders =3D 0 # max number of walsender processes # (change requires restart) #wal_keep_segments =3D 0 # in logfile segments, 16MB each; 0 = disables #wal_sender_timeout =3D 60s # in milliseconds; 0 disables =20 #max_replication_slots =3D 0 # max number of replication slots # (change requires restart) #track_commit_timestamp =3D off # collect timestamp of transaction = commit # (change requires restart) =20 # - Master Server - =20 # These settings are ignored on a standby server. =20 #synchronous_standby_names =3D '' # standby servers that provide = sync rep # number of sync standbys and = comma-separated list of application_name # from standby(s); '*' =3D all #vacuum_defer_cleanup_age =3D 0 # number of xacts by which = cleanup is delayed =20 # - Standby Servers - =20 # These settings are ignored on a master server. =20 #hot_standby =3D off # "on" allows queries during = recovery # (change requires = restart) #max_standby_archive_delay =3D 30s # max delay before canceling = queries # when reading WAL from = archive; # -1 allows indefinite = delay #max_standby_streaming_delay =3D 30s # max delay before canceling = queries # when reading = streaming WAL; # -1 allows indefinite = delay #wal_receiver_status_interval =3D 10s # send replies at least this = often # 0 disables #hot_standby_feedback =3D off # send info from standby to = prevent # query conflicts #wal_receiver_timeout =3D 60s # time that receiver waits = for # communication from = master # in milliseconds; 0 = disables #wal_retrieve_retry_interval =3D 5s # time to wait before = retrying to # retrieve WAL after a = failed attempt =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_indexonlyscan =3D on #enable_material =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 #parallel_tuple_cost =3D 0.1 # same scale as above #parallel_setup_cost =3D 1000.0 # same scale as above #min_parallel_relation_size =3D 8MB #effective_cache_size =3D 4GB =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 #geqo_seed =3D 0.0 # range 0.0-1.0 =20 # - Other Planner Options - =20 #default_statistics_target =3D 100 # range 1-10000 #constraint_exclusion =3D partition # on, off, or partition #cursor_tuple_fraction =3D 0.1 # range 0.0-1.0 #from_collapse_limit =3D 8 #join_collapse_limit =3D 8 # 1 disables collapsing of = explicit # JOIN clauses #force_parallel_mode =3D off =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 = written, # 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_file_mode =3D 0600 # creation mode for log = files, # begin with 0 to use = octal notation #log_truncate_on_rotation =3D off # If on, an existing log = file with 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 disables. #log_rotation_size =3D 10MB # Automatic rotation of = logfiles will # happen after that = much log output. # 0 disables. =20 # These are relevant when logging to syslog: #syslog_facility =3D 'LOCAL0' #syslog_ident =3D 'postgres' #syslog_sequence_numbers =3D on #syslog_split_messages =3D on =20 # This is only relevant when logging to eventlog (win32): #event_source =3D 'PostgreSQL' =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 warning # values in order of = decreasing detail: # debug5 # debug4 # debug3 # debug2 # debug1 # info # notice # warning # error # log # fatal # panic =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 number # of milliseconds =20 =20 # - What to Log - =20 #debug_print_parse =3D off #debug_print_rewritten =3D off #debug_print_plan =3D off #debug_pretty_print =3D on #log_checkpoints =3D off #log_connections =3D off #log_disconnections =3D off #log_duration =3D off #log_error_verbosity =3D default # terse, default, or = verbose messages #log_hostname =3D off log_line_prefix =3D '%t ' # special values: # %a =3D application = name # %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 # %n =3D timestamp = with milliseconds (as a Unix epoch) # %i =3D command tag # %e =3D SQL state # %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_replication_commands =3D off #log_temp_files =3D -1 # log temporary files = equal or larger # than the specified = size in kilobytes; # -1 disables, 0 logs = all temp files log_timezone =3D 'Europe/Brussels' =20 =20 # - Process Title - =20 #cluster_name =3D '' # added to process titles if = nonempty # (change requires = restart) #update_process_title =3D off =20 =20 #------------------------------------------------------------------------= ------ # RUNTIME STATISTICS #------------------------------------------------------------------------= ------ =20 # - Query/Index Statistics Collector - =20 #track_activities =3D on #track_counts =3D on #track_io_timing =3D off #track_functions =3D none # none, pl, all #track_activity_query_size =3D 1024 # (change requires restart) #stats_temp_directory =3D 'pg_stat_tmp' =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 on # Enable autovacuum subprocess? = 'on' # 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 this number # of milliseconds. #autovacuum_max_workers =3D 3 # max number of autovacuum = subprocesses # (change requires = restart) #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 # 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_multixact_freeze_max_age =3D 400000000 # maximum = multixact age # before forced vacuum # (change requires = restart) #autovacuum_vacuum_cost_delay =3D 20ms # default vacuum cost delay = for # autovacuum, in = milliseconds; # -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 #default_transaction_deferrable =3D off #session_replication_role =3D 'origin' #statement_timeout =3D 0 # in milliseconds, 0 is = disabled #lock_timeout =3D 0 # in milliseconds, 0 is = disabled #idle_in_transaction_session_timeout =3D 0 # in = milliseconds, 0 is disabled #vacuum_freeze_min_age =3D 50000000 #vacuum_freeze_table_age =3D 150000000 #vacuum_multixact_freeze_min_age =3D 5000000 #vacuum_multixact_freeze_table_age =3D 150000000 #bytea_output =3D 'hex' # hex, escape #xmlbinary =3D 'base64' #xmloption =3D 'content' #gin_fuzzy_search_limit =3D 0 #gin_pending_list_limit =3D 4MB =20 # - Locale and Formatting - =20 datestyle =3D 'iso, dmy' #intervalstyle =3D 'postgres' timezone =3D 'Europe/Brussels' #timezone_abbreviations =3D 'Default' # Select the set of available = time zone # abbreviations. = Currently, there are # Default # Australia = (historical usage) # India # You can create your = own file in # share/timezonesets/. #extra_float_digits =3D 0 # min -15, max 3 #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 'French_France.1252' # locale = for system error message # strings lc_monetary =3D 'French_France.1252' # locale = for monetary formatting lc_numeric =3D 'French_France.1252' # locale = for number formatting lc_time =3D 'French_France.1252' # = locale for time formatting =20 # default configuration for text search default_text_search_config =3D 'pg_catalog.french' =20 # - Other Defaults - =20 #dynamic_library_path =3D '$libdir' #local_preload_libraries =3D '' #session_preload_libraries =3D '' =20 =20 #------------------------------------------------------------------------= ------ # LOCK MANAGEMENT #------------------------------------------------------------------------= ------ =20 #deadlock_timeout =3D 1s #max_locks_per_transaction =3D 64 # min 10 # (change requires = restart) #max_pred_locks_per_transaction =3D 64 # min 10 # (change requires = restart) =20 =20 #------------------------------------------------------------------------= ------ # VERSION/PLATFORM COMPATIBILITY #------------------------------------------------------------------------= ------ =20 # - Previous PostgreSQL Versions - =20 #array_nulls =3D on #backslash_quote =3D safe_encoding # on, off, or safe_encoding #default_with_oids =3D off #escape_string_warning =3D on #lo_compat_privileges =3D off #operator_precedence_warning =3D off #quote_all_identifiers =3D off #sql_inheritance =3D on #standard_conforming_strings =3D on #synchronize_seqscans =3D on =20 # - Other Platforms and Clients - =20 #transform_null_equals =3D off =20 =20 #------------------------------------------------------------------------= ------ # ERROR HANDLING #------------------------------------------------------------------------= ------ =20 #exit_on_error =3D off # terminate session = on any error? #restart_after_crash =3D on # reinitialize after backend = crash? =20 =20 #------------------------------------------------------------------------= ------ # CONFIG FILE INCLUDES #------------------------------------------------------------------------= ------ =20 # These options allow settings to be loaded from files other than the # default postgresql.conf. =20 #include_dir =3D 'conf.d' # include files = ending in '.conf' from # directory 'conf.d' #include_if_exists =3D 'exists.conf' # include file only if it exists #include =3D 'special.conf' # include file =20 =20 #------------------------------------------------------------------------= ------ # CUSTOMIZED OPTIONS #------------------------------------------------------------------------= ------ =20 # Add settings for extensions here =20 =20 =20 =20 _____ =20 Avast logo L'absence de virus dans ce courrier =C3=A9lectronique a =C3=A9t=C3=A9 = v=C3=A9rifi=C3=A9e par le logiciel antivirus Avast.=20 www.avast.com =20 =20 --=20 El genio es 1% inspiraci=C3=B3n y 99% transpiraci=C3=B3n. Thomas Alva Edison http://pglearn.blogspot.mx/ =20 ------=_NextPart_001_03F7_01D48751.CB08CF80 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Hi,

 

Thanks for your answers, I found that it's a Postgresql 32 bits = version installed on a 64 bits machine :-(

I didn't imagine that. I guess I'm on the way of getting some = troubles...

 

Have a good day,

 

Olivier

 

De : Rene = Romero Benavides [mailto:rene.romero.b@gmail.com] =
Envoy=C3=A9 : mercredi 28 novembre 2018 = 18:41
=C3=80 : o.lepretre@gmail.com
Cc : = pgsql-sql@postgresql.org
Objet : Re: error code = 8

 

Share with us the log messages please, also the stack = trace.

work_mem is 64MB = try lowering it, maybe the app is causing the out of memory messages due = to queries using too much memory.

 

Am = Mi., 28. Nov. 2018 um 02:33 Uhr schrieb Olivier Lepr=C3=AAtre = <o.lepretre@gmail.com>:

Hi,<= o:p>

 

I get = shared "memory exhausted messages". shared buffers where set = to 1Gb. I tried to increase them to 2048 or 1536 and got "error = code 8" when trying to launch with pg_ctl.

 

Windows = server 2016 8 Gb

Postgresql = 9.6

 

Below is = the postgresql.conf file. Is this shared buffer parameter the main one = to change for shared memory problems ?

 

I read = " If you have a system with 1GB or more of RAM, a = reasonable starting value for shared_buffers is 1/4 of the memory in = your system. = "

https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL= _Server

 

But it = seems that I can't go above 1gb, even with a 8 Gbytes memory. =

 

What does = this error code 8 means, it does not appear here

https://www.postgresql.org/docs/9.6/errcodes-appendix.h= tml

 

Thanks for = any help,

 

Olivier

 

# = -----------------------------

# = PostgreSQL configuration file

# = -----------------------------

#

# This = file consists of lines of the form:

#

# &nbs= p; name =3D value

#

# (The = "=3D" 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=3Don".  Some parameters can = be changed at run time

# with the = "SET" SQL command.

#

# Memory = units:  kB =3D kilobytes        = Time units:  ms  =3D milliseconds

# &nbs= p;            = ;  MB =3D = megabytes          &nbs= p;          s   = =3D seconds

# &nbs= p;            = ;  GB =3D = gigabytes          &nbs= p;          min =3D = minutes

# &nbs= p;            = ;  TB =3D = terabytes          &nbs= p;          h   = =3D hours

# &nbs= p;            = ;            =             &= nbsp;            = d   =3D 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_direc= tory =3D = 'ConfigDir'          &n= bsp;      # use data in another = directory

  = ;            =             &= nbsp;           &n= bsp;          # (change = requires restart)

#hba_file = =3D 'ConfigDir/pg_hba.conf'       # = host-based authentication file

  = ;            =             &= nbsp;           &n= bsp;          # (change = requires restart)

#ident_file= =3D 'ConfigDir/pg_ident.conf'   # ident configuration = file

  = ;            =             &= nbsp;           &n= bsp;          # (change = requires restart)

 

# If = external_pid_file is not explicitly set, no extra PID file is = written.

#external_p= id_file =3D = ''            = ;            =    # write an extra PID file

  = ;            =             &= nbsp;           &n= bsp;          # (change = requires restart)

 

 

#----------= --------------------------------------------------------------------

# = CONNECTIONS AND AUTHENTICATION

#----------= --------------------------------------------------------------------

 

# - = Connection Settings -

 

listen_addr= esses =3D = '*'           &nbs= p;     # what IP address(es) to listen = on;

  = ;            =             &= nbsp;           &n= bsp;          # = comma-separated list of addresses;

  = ;            =             &= nbsp;           &n= bsp;          # defaults to = 'localhost'; use '*' for all

  = ;            =             &= nbsp;           &n= bsp;          # (change = requires restart)

port =3D = 5432           &nb= sp;           &nbs= p;        # (change requires = restart)

max_connect= ions =3D = 100           &nbs= p;            # = (change requires restart)

#superuser_= reserved_connections =3D 3   # (change requires = restart)

#unix_socke= t_directories =3D ''       # = comma-separated list of directories

  = ;            =             &= nbsp;           &n= bsp;          # (change = requires restart)

#unix_socke= t_group =3D = ''            = ;           # (change = requires restart)

#unix_socke= t_permissions =3D = 0777           &nb= sp;       # begin with 0 to use octal = notation

  = ;            =             &= nbsp;           &n= bsp;          # (change = requires restart)

#bonjour = =3D = off           &nbs= p;            = ;            =   # advertise server via Bonjour

  = ;            =             &= nbsp;           &n= bsp;          # (change = requires restart)

#bonjour_na= me =3D = ''            = ;        # defaults to the computer = name

  = ;            =             &= nbsp;           &n= bsp;          # (change = requires restart)

 

# - = Security and Authentication -

 

#authentica= tion_timeout =3D = 1min           # = 1s-600s

#ssl =3D = off           &nbs= p;            = ;           # (change = requires restart)

#ssl_cipher= s =3D 'HIGH:MEDIUM:+3DES:!aNULL' # allowed SSL = ciphers

  = ;            =             &= nbsp;           &n= bsp;          # (change = requires restart)

#ssl_prefer= _server_ciphers =3D = on            # = (change requires restart)

#ssl_ecdh_c= urve =3D = 'prime256v1'           = # (change requires restart)

#ssl_cert_f= ile =3D = 'server.crt'          &= nbsp;         # (change requires = restart)

#ssl_key_fi= le =3D = 'server.key'          &= nbsp;        # (change requires = restart)

#ssl_ca_fil= e =3D = ''            = ;            =   # (change requires restart)

#ssl_crl_fi= le =3D = ''            = ;            =   # (change requires restart)

#password_e= ncryption =3D on

#db_user_na= mespace =3D off

#row_securi= ty =3D on

 

# GSSAPI = using Kerberos

#krb_server= _keyfile =3D ''

#krb_casein= s_users =3D off

 

# - TCP = Keepalives -

# see = "man 7 tcp" for details

 

#tcp_keepal= ives_idle =3D = 0            # = TCP_KEEPIDLE, in seconds;

  = ;            =             &= nbsp;           &n= bsp;          # 0 selects = the system default

#tcp_keepal= ives_interval =3D = 0            =      # TCP_KEEPINTVL, in = seconds;

  = ;            =             &= nbsp;           &n= bsp;          # 0 selects = the system default

#tcp_keepal= ives_count =3D = 0            =        # = TCP_KEEPCNT;

  = ;            =             &= nbsp;           &n= bsp;          # 0 selects = the system default

 

 

#----------= --------------------------------------------------------------------

# RESOURCE = USAGE (except WAL)

#----------= --------------------------------------------------------------------

 

# - Memory = -

 

shared_buff= ers =3D = 1024MB           &= nbsp;          # min = 128kB

  = ;            =             &= nbsp;           &n= bsp;          # (change = requires restart)

#huge_pages= =3D = try           &nbs= p;         # on, off, or = try

  = ;            =             &= nbsp;           &n= bsp;          # (change = requires restart)

temp_buffer= s =3D = 16MB           &nb= sp;           &nbs= p;   # min 800kB

#max_prepar= ed_transactions =3D = 0          # zero disables = the feature

  = ;            =             &= nbsp;           &n= bsp;          # (change = requires restart)

# Caution: = it is not advisable to set max_prepared_transactions nonzero = unless

# you = actively intend to use prepared transactions.

work_mem = =3D 64MB           =             &= nbsp;       # min 64kB/Pr=C3=A9c=C3=A9dent = 16

maintenance= _work_mem =3D 64MB          = # min 1MB

#replacemen= t_sort_tuples =3D 150000      # limits use of = replacement selection sort

#autovacuum= _work_mem =3D = -1            = ;  # min 1MB, or -1 to use = maintenance_work_mem

#max_stack_= depth =3D = 2MB           &nbs= p;         # min = 100kB

dynamic_sha= red_memory_type =3D windows       # the = default is the first option

  = ;            =             &= nbsp;           &n= bsp;          # supported = by the operating system:

  = ;            =             &= nbsp;           &n= bsp;          #   = posix

  = ;            =             &= nbsp;           &n= bsp;          #   = sysv

  = ;            =             &= nbsp;           &n= bsp;          #   = windows

  = ;            =             &= nbsp;           &n= bsp;          #   = mmap

  = ;            =             &= nbsp;           &n= bsp;          # use none to = disable dynamic shared memory

 

# - Disk = -

 

#temp_file_= limit =3D = -1            = ;            =    # limits per-process temp file = space

  = ;            =             &= nbsp;           &n= bsp;          # in kB, or = -1 for no limit

 

# - Kernel = Resource Usage -

 

#max_files_= per_process =3D = 1000            # = min 25

  = ;            =             &= nbsp;           &n= bsp;          # (change = requires restart)

#shared_pre= load_libraries =3D = ''            = ;   # (change requires restart)

 

# - = Cost-Based Vacuum Delay -

 

#vacuum_cos= t_delay =3D = 0            =           # 0-100 = milliseconds

#vacuum_cos= t_page_hit =3D = 1            =      # 0-10000 credits

#vacuum_cos= t_page_miss =3D = 10            # = 0-10000 credits

#vacuum_cos= t_page_dirty =3D = 20            # = 0-10000 credits

#vacuum_cos= t_limit =3D = 200           &nbs= p;        # 1-10000 = credits

 

# - = Background Writer -

 

#bgwriter_d= elay =3D = 200ms           &n= bsp;         # 10-10000ms = between rounds

#bgwriter_l= ru_maxpages =3D = 100           &nbs= p; # 0-1000 max buffers written/round

#bgwriter_l= ru_multiplier =3D = 2.0           &nbs= p;  # 0-10.0 multiplier on buffers = scanned/round

#bgwriter_f= lush_after =3D = 0           # 0 = disables,

  = ;            =             &= nbsp;           &n= bsp;          # default is = 512kB on linux, 0 otherwise

 

# - = Asynchronous Behavior -

 

#effective_= io_concurrency =3D = 0            =    # 1-1000; 0 disables prefetching

#max_worker= _processes =3D = 8            =      # (change requires = restart)

#max_parall= el_workers_per_gather =3D 0 # taken from = max_worker_processes

#old_snapsh= ot_threshold =3D = -1            = ;   # 1min-60d; -1 disables; 0 is = immediate

  = ;            =             &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =   # (change requires restart)

#backend_fl= ush_after =3D = 0           # 0 = disables, default is 0

 

 

#----------= --------------------------------------------------------------------

# WRITE = AHEAD LOG

#----------= --------------------------------------------------------------------

 

# - = Settings -

 

#wal_level = =3D = minimal           =             &= nbsp;   # minimal, replica, or logical

  = ;            =             &= nbsp;           &n= bsp;          # (change = requires restart)

#fsync =3D = on            = ;            =         # flush data to disk for = crash safety

  = ;            =             &= nbsp;           &n= bsp;           &nb= sp;        # (turning this off can = cause

  = ;            =             &= nbsp;           &n= bsp;           &nb= sp;        # unrecoverable data = corruption)

#synchronou= s_commit =3D = on            = ;      # synchronization = level;

  = ;            =             &= nbsp;           &n= bsp;          # off, local, = remote_write, remote_apply, or on

#wal_sync_m= ethod =3D = fsync           &n= bsp;       # the default is the first = option

  = ;            =             &= nbsp;           &n= bsp;          # supported = by the operating system:

  = ;            =             &= nbsp;           &n= bsp;          #   = open_datasync

  = ;            =             &= nbsp;           &n= bsp;          #   = fdatasync (default on Linux)

  = ;            =             &= nbsp;           &n= bsp;          #   = fsync

  = ;            =             &= nbsp;           &n= bsp;          #   = fsync_writethrough

  = ;            =             &= nbsp;           &n= bsp;          #   = open_sync

#full_page_= writes =3D = on            = ;            = # recover from partial page writes

#wal_compre= ssion =3D = off           &nbs= p;            # = enable compression of full-page writes

#wal_log_hi= nts =3D = off           &nbs= p;            = ;     # also do full page writes of non-critical = updates

  = ;            =             &= nbsp;           &n= bsp;          # (change = requires restart)

#wal_buffer= s =3D = -1            = ;           # min = 32kB, -1 sets based on shared_buffers

  = ;            =             &= nbsp;           &n= bsp;          # (change = requires restart)

#wal_writer= _delay =3D = 200ms           &n= bsp;      # 1-10000 = milliseconds

#wal_writer= _flush_after =3D = 1MB           &nbs= p;  # 0 disables

 

#commit_del= ay =3D = 0            =         # range 0-100000, in = microseconds

#commit_sib= lings =3D = 5            =             &= nbsp;  # range 1-1000

 

# - = Checkpoints -

 

#checkpoint= _timeout =3D = 5min           &nb= sp;     # range 30s-1d

#max_wal_si= ze =3D 1GB

#min_wal_si= ze =3D 80MB

#checkpoint= _completion_target =3D 0.5    # checkpoint target = duration, 0.0 - 1.0

#checkpoint= _flush_after =3D = 0            =       # 0 disables,

  = ;            =             &= nbsp;           &n= bsp;          # default is = 256kB on linux, 0 otherwise

#checkpoint= _warning =3D = 30s           &nbs= p;      # 0 disables

 

# - = Archiving -

 

#archive_mo= de =3D = off           &nbs= p;       # enables archiving; off, on, or = always

  = ;            =             &= nbsp;            = # (change requires restart)

#archive_co= mmand =3D = ''            = ;   # command to use to archive a logfile = segment

  = ;            =             &= nbsp;            = # placeholders: %p =3D path of file to archive

  = ;            =             &= nbsp;            = #            =    %f =3D file name only

  = ;            =             &= nbsp;            = # e.g. 'test ! -f /mnt/server/archivedir/%f && cp %p = /mnt/server/archivedir/%f'

#archive_ti= meout =3D = 0            =      # force a logfile segment switch after = this

  = ;            =             &= nbsp;            = # number of seconds; 0 disables

 

 

#----------= --------------------------------------------------------------------

# = REPLICATION

#----------= --------------------------------------------------------------------

 

# - = Sending Server(s) -

 

# Set = these on the master and on any standby that will send replication = data.

 

#max_wal_se= nders =3D = 0            =    # max number of walsender processes

  = ;            =             &= nbsp;            = # (change requires restart)

#wal_keep_s= egments =3D = 0           # in = logfile segments, 16MB each; 0 disables

#wal_sender= _timeout =3D 60s        # in = milliseconds; 0 disables

 

#max_replic= ation_slots =3D 0         # max = number of replication slots

  = ;            =             &= nbsp;            = # (change requires restart)

#track_comm= it_timestamp =3D off  # collect timestamp of transaction = commit

  = ;            =             &= nbsp;            = # (change requires restart)

 

# - Master = Server -

 

# These = settings are ignored on a standby server.

 

#synchronou= s_standby_names =3D ''        # = standby servers that provide sync rep

  = ;            =             &= nbsp;            = # number of sync standbys and comma-separated list of = application_name

  = ;            =             &= nbsp;            = # from standby(s); '*' =3D all

#vacuum_def= er_cleanup_age =3D = 0          # number of = xacts by which cleanup is delayed

 

# - = Standby Servers -

 

# These = settings are ignored on a master server.

 

#hot_standb= y =3D = off           &nbs= p;         # "on" = allows queries during recovery

  = ;            =             &= nbsp;           &n= bsp;          # (change = requires restart)

#max_standb= y_archive_delay =3D 30s      # max delay before = canceling queries

  = ;            =             &= nbsp;           &n= bsp;          # when = reading WAL from archive;

  = ;            =             &= nbsp;           &n= bsp;          # -1 allows = indefinite delay

#max_standb= y_streaming_delay =3D 30s  # max delay before canceling = queries

  = ;            =             &= nbsp;           &n= bsp;          # when = reading streaming WAL;

  = ;            =             &= nbsp;           &n= bsp;          # -1 allows = indefinite delay

#wal_receiv= er_status_interval =3D 10s      # send replies = at least this often

  = ;            =             &= nbsp;           &n= bsp;          # 0 = disables

#hot_standb= y_feedback =3D = off           &nbs= p;    # send info from standby to = prevent

  = ;            =             &= nbsp;           &n= bsp;          # query = conflicts

#wal_receiv= er_timeout =3D = 60s           &nbs= p;    # time that receiver waits = for

  = ;            =             &= nbsp;           &n= bsp;          # = communication from master

  = ;            =             &= nbsp;           &n= bsp;          # in = milliseconds; 0 disables

#wal_retrie= ve_retry_interval =3D = 5s          # time to wait = before retrying to

  = ;            =             &= nbsp;           &n= bsp;          # retrieve = WAL after a failed attempt

 

 

#----------= --------------------------------------------------------------------

# QUERY = TUNING

#----------= --------------------------------------------------------------------

 

# - = Planner Method Configuration -

 

#enable_bit= mapscan =3D on

#enable_has= hagg =3D on

#enable_has= hjoin =3D on

#enable_ind= exscan =3D on

#enable_ind= exonlyscan =3D on

#enable_mat= erial =3D on

#enable_mer= gejoin =3D on

#enable_nes= tloop =3D on

#enable_seq= scan =3D on

#enable_sor= t =3D on

#enable_tid= scan =3D on

 

# - = Planner Cost Constants -

 

#seq_page_c= ost =3D = 1.0           &nbs= p;            = ;  # measured on an arbitrary scale

#random_pag= e_cost =3D = 4.0           &nbs= p;        # same scale as = above

#cpu_tuple_= cost =3D = 0.01           &nb= sp;            # = same scale as above

#cpu_index_= tuple_cost =3D = 0.005            = # same scale as above

#cpu_operat= or_cost =3D = 0.0025           &= nbsp;    # same scale as above

#parallel_t= uple_cost =3D = 0.1           # same = scale as above

#parallel_s= etup_cost =3D 1000.0    # same scale as = above

#min_parall= el_relation_size =3D 8MB

#effective_= cache_size =3D 4GB

 

# - = Genetic Query Optimizer -

 

#geqo =3D = on

#geqo_thres= hold =3D 12

#geqo_effor= t =3D = 5            =             # = range 1-10

#geqo_pool_= size =3D = 0            =             &= nbsp;   # selects default based on = effort

#geqo_gener= ations =3D = 0            =              = # selects default based on effort

#geqo_selec= tion_bias =3D = 2.0           &nbs= p;       # range = 1.5-2.0

#geqo_seed = =3D = 0.0           &nbs= p;          # range = 0.0-1.0

 

# - Other = Planner Options -

 

#default_st= atistics_target =3D 100  # range 1-10000

#constraint= _exclusion =3D partition # on, off, or partition

#cursor_tup= le_fraction =3D = 0.1           &nbs= p;     # range 0.0-1.0

#from_colla= pse_limit =3D 8

#join_colla= pse_limit =3D = 8            =   # 1 disables collapsing of explicit

  = ;            =             &= nbsp;           &n= bsp;          # JOIN = clauses

#force_para= llel_mode =3D off

 

 

#----------= --------------------------------------------------------------------

# ERROR = REPORTING AND LOGGING

#----------= --------------------------------------------------------------------

 

# - Where = to Log -

 

log_destina= tion =3D = 'stderr'           = ;  # Valid values are combinations of

  = ;            =             &= nbsp;           &n= bsp;          # stderr, = csvlog, syslog, and eventlog,

  = ;            =             &= nbsp;           &n= bsp;          # depending = on platform.  csvlog

  = ;            =             &= nbsp;           &n= bsp;          # requires = logging_collector to be on.

 

# This is = used when logging to stderr:

logging_col= lector =3D = on            = ;     # Enable capturing of stderr and = csvlog

  = ;            =             &= nbsp;           &n= bsp;          # into log = files. Required to be on for

  = ;            =             &= nbsp;           &n= bsp;          # = csvlogs.

  = ;            =             &= nbsp;           &n= bsp;          # (change = requires restart)

 

# These = are only used if logging_collector is on:

#log_direct= ory =3D = 'pg_log'           = ; # directory where log files are written,

  = ;            =             &= nbsp;           &n= bsp;          # can be = absolute or relative to PGDATA

#log_filena= me =3D 'postgresql-%Y-%m-%d_%H%M%S.log'     # log = file name pattern,

  = ;            =             &= nbsp;           &n= bsp;          # can include = strftime() escapes

#log_file_m= ode =3D = 0600           &nb= sp;           &nbs= p; # creation mode for log files,

  = ;            =             &= nbsp;           &n= bsp;          # begin with = 0 to use octal notation

#log_trunca= te_on_rotation =3D = off            # = If on, an existing log file with the

  = ;            =             &= nbsp;           &n= bsp;          # same name = as the new log file will be

  = ;            =             &= nbsp;           &n= bsp;          # truncated = rather than appended to.

  = ;            =             &= nbsp;           &n= bsp;          # But such = truncation only occurs on

  = ;            =             &= nbsp;           &n= bsp;          # time-driven = rotation, not on restarts

  = ;            =             &= nbsp;           &n= bsp;          # or = size-driven rotation.  Default is

  = ;            =             &= nbsp;           &n= bsp;          # off, = meaning append to existing files

  = ;            =             &= nbsp;           &n= bsp;          # in all = cases.

#log_rotati= on_age =3D = 1d            = ;            # = Automatic rotation of logfiles will

  = ;            =             &= nbsp;           &n= bsp;          # happen = after that time.  0 disables.

#log_rotati= on_size =3D = 10MB           &nb= sp;        # Automatic rotation of = logfiles will

  = ;            =             &= nbsp;           &n= bsp;          # happen = after that much log output.

  = ;            =             &= nbsp;           &n= bsp;          # 0 = disables.

 

# These = are relevant when logging to syslog:

#syslog_fac= ility =3D 'LOCAL0'

#syslog_ide= nt =3D 'postgres'

#syslog_seq= uence_numbers =3D on

#syslog_spl= it_messages =3D on

 

# This is = only relevant when logging to eventlog (win32):

#event_sour= ce =3D 'PostgreSQL'

 

# - When = to Log -

 

#client_min= _messages =3D = notice           &= nbsp; # values in order of decreasing detail:

  = ;            =             &= nbsp;           &n= bsp;          #   = debug5

  = ;            =             &= nbsp;           &n= bsp;          #   = debug4

  = ;            =             &= nbsp;           &n= bsp;          #   = debug3

  = ;            =             &= nbsp;           &n= bsp;          #   = debug2

  = ;            =             &= nbsp;           &n= bsp;          #   = debug1

  = ;            =             &= nbsp;           &n= bsp;          #   = log

  = ;            =             &= nbsp;           &n= bsp;          #   = notice

  = ;            =             &= nbsp;           &n= bsp;          #   = warning

  = ;            =             &= nbsp;           &n= bsp;          #   = error

 

#log_min_me= ssages =3D = warning           =   # values in order of decreasing detail:

  = ;            =             &= nbsp;           &n= bsp;          #   = debug5

  = ;            =             &= nbsp;           &n= bsp;          #   = debug4

  = ;            =             &= nbsp;           &n= bsp;          #   = debug3

  = ;            =             &= nbsp;           &n= bsp;          #   = debug2

  = ;            =             &= nbsp;           &n= bsp;          #   = debug1

  = ;            =             &= nbsp;           &n= bsp;          #   = info

  = ;            =             &= nbsp;           &n= bsp;          #   = notice

  = ;            =             &= nbsp;           &n= bsp;          #   = warning

  = ;            =             &= nbsp;           &n= bsp;          #   = error

  = ;            =             &= nbsp;           &n= bsp;          #   = log

  = ;            =             &= nbsp;           &n= bsp;          #   = fatal

  = ;            =             &= nbsp;           &n= bsp;          #   = panic

 

#log_min_er= ror_statement =3D error         = # values in order of decreasing detail:

  = ;            =             &= nbsp;           &n= bsp;          #   = debug5

  = ;            =             &= nbsp;           &n= bsp;          #   = debug4

  = ;            =             &= nbsp;           &n= bsp;          #   = debug3

  = ;            =             &= nbsp;           &n= bsp;          #   = debug2

  = ;            =             &= nbsp;           &n= bsp;          #   = debug1

  = ;            =             &= nbsp;           &n= bsp;          #   = info

  = ;            =             &= nbsp;           &n= bsp;          #   = notice

  = ;            =             &= nbsp;           &n= bsp;          #   = warning

  = ;            =             &= nbsp;           &n= bsp;          #   = error

  = ;            =             &= nbsp;           &n= bsp;          #   = log

  = ;            =             &= nbsp;           &n= bsp;          #   = fatal

  = ;            =             &= nbsp;           &n= bsp;          #   = panic (effectively off)

 

#log_min_du= ration_statement =3D -1       # -1 is = disabled, 0 logs all statements

  = ;            =             &= nbsp;           &n= bsp;          # and their = durations, > 0 logs only

  = ;            =             &= nbsp;           &n= bsp;          # statements = running at least this number

  = ;            =             &= nbsp;           &n= bsp;          # of = milliseconds

 

 

# - What = to Log -

 

#debug_prin= t_parse =3D off

#debug_prin= t_rewritten =3D off

#debug_prin= t_plan =3D off

#debug_pret= ty_print =3D on

#log_checkp= oints =3D off

#log_connec= tions =3D off

#log_discon= nections =3D off

#log_durati= on =3D off

#log_error_= verbosity =3D = default           =    # terse, default, or verbose = messages

#log_hostna= me =3D off

log_line_pr= efix =3D '%t = '            =             &= nbsp;  # special values:

  = ;            =             &= nbsp;           &n= bsp;          #   = %a =3D application name

  = ;            =             &= nbsp;           &n= bsp;          #   = %u =3D user name

  = ;            =             &= nbsp;           &n= bsp;          #   = %d =3D database name

  = ;            =             &= nbsp;           &n= bsp;          #   = %r =3D remote host and port

  = ;            =             &= nbsp;           &n= bsp;          #   = %h =3D remote host

  = ;            =             &= nbsp;           &n= bsp;          #   = %p =3D process ID

  = ;            =             &= nbsp;           &n= bsp;          #   = %t =3D timestamp without milliseconds

  = ;            =             &= nbsp;           &n= bsp;          #   = %m =3D timestamp with milliseconds

  = ;            =             &= nbsp;           &n= bsp;          #   = %n =3D timestamp with milliseconds (as a Unix = epoch)

  = ;            =             &= nbsp;           &n= bsp;          #   = %i =3D command tag

  = ;            =             &= nbsp;           &n= bsp;          #   = %e =3D SQL state

  = ;            =             &= nbsp;           &n= bsp;          #   = %c =3D session ID

  = ;            =             &= nbsp;           &n= bsp;          #   = %l =3D session line number

  = ;            =             &= nbsp;           &n= bsp;          #   = %s =3D session start timestamp

  = ;        =             &= nbsp;           &n= bsp;           &nb= sp;  #   %v =3D virtual transaction = ID

  = ;            =             &= nbsp;           &n= bsp;          #   = %x =3D transaction ID (0 if none)

  = ;            =             &= nbsp;           &n= bsp;          #   = %q =3D stop here in non-session

  = ;            =             &= nbsp;           &n= bsp;          = #        = processes

  = ;            =             &= nbsp;           &n= bsp;          #   = %% =3D '%'

  = ;            =             &= nbsp;           &n= bsp;          # e.g. = '<%u%%%d> '

#log_lock_w= aits =3D = off           &nbs= p;            = ;    # log lock waits >=3D = deadlock_timeout

#log_statem= ent =3D = 'none'           &= nbsp;           # = none, ddl, mod, all

#log_replic= ation_commands =3D off

#log_temp_f= iles =3D = -1            = ;            =     # log temporary files equal or = larger

  = ;            =             &= nbsp;           &n= bsp;          # than the = specified size in kilobytes;

  = ;            =             &= nbsp;           &n= bsp;          # -1 = disables, 0 logs all temp files

log_timezon= e =3D 'Europe/Brussels'

 

 

# - = Process Title -

 

#cluster_na= me =3D = ''            = ;         # added to process = titles if nonempty

  = ;            =             &= nbsp;           &n= bsp;          # (change = requires restart)

#update_pro= cess_title =3D off

 

 

#----------= --------------------------------------------------------------------

# RUNTIME = STATISTICS

#----------= --------------------------------------------------------------------

 

# - = Query/Index Statistics Collector -

 

#track_acti= vities =3D on

#track_coun= ts =3D on

#track_io_t= iming =3D off

#track_func= tions =3D = none           &nb= sp;           # none, = pl, all

#track_acti= vity_query_size =3D 1024        # = (change requires restart)

#stats_temp= _directory =3D 'pg_stat_tmp'

 

 

# - = Statistics Monitoring -

 

#log_parser= _stats =3D off

#log_planne= r_stats =3D off

#log_execut= or_stats =3D off

#log_statem= ent_stats =3D off

 

 

#----------= --------------------------------------------------------------------

# = AUTOVACUUM PARAMETERS

#----------= --------------------------------------------------------------------

 

#autovacuum= =3D = on            = ;         # Enable autovacuum = subprocess?  'on'

  = ;            =             &= nbsp;           &n= bsp;          # requires = track_counts to also be on.

#log_autova= cuum_min_duration =3D -1    # -1 disables, 0 logs all = actions and

  = ;            =             &= nbsp;           &n= bsp;          # their = durations, > 0 logs only

  = ;            =             &= nbsp;           &n= bsp;          # actions = running at least this number

  = ;            =             &= nbsp;           &n= bsp;          # of = milliseconds.

#autovacuum= _max_workers =3D = 3            # = max number of autovacuum subprocesses

  = ;            =             &= nbsp;           &n= bsp;          # (change = requires restart)

#autovacuum= _naptime =3D = 1min           &nb= sp;  # time between autovacuum runs

#autovacuum= _vacuum_threshold =3D 50   # min number of row updates = before

  = ;            =             &= nbsp;           &n= bsp;          # = vacuum

#autovacuum= _analyze_threshold =3D 50   # min number of row updates = before

  = ;            =             &= nbsp;           &n= bsp;          # = 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

  = ;            =             &= nbsp;           &n= bsp;          # (change = requires restart)

#autovacuum= _multixact_freeze_max_age =3D = 400000000       # maximum multixact = age

  = ;            =             &= nbsp;           &n= bsp;          # before = forced vacuum

  = ;            =             &= nbsp;           &n= bsp;          # (change = requires restart)

#autovacuum= _vacuum_cost_delay =3D 20ms      # default = vacuum cost delay for

  = ;            =             &= nbsp;           &n= bsp;          # autovacuum, = in milliseconds;

  = ;            =             &= nbsp;           &n= bsp;          # -1 means = use vacuum_cost_delay

#autovacuum= _vacuum_cost_limit =3D -1  # default vacuum cost limit = for

  = ;            =             &= nbsp;           &n= bsp;          # autovacuum, = -1 means use

  = ;            =             &= nbsp;           &n= bsp;          # = vacuum_cost_limit

 

 

#----------= --------------------------------------------------------------------

# CLIENT = CONNECTION DEFAULTS

#----------= --------------------------------------------------------------------

 

# - = Statement Behavior -

 

#search_pat= h =3D '"$user", public'  # schema = names

#default_ta= blespace =3D = ''            = ;  # a tablespace name, '' uses the default

#temp_table= spaces =3D = ''            = ;            = # a list of tablespace names, '' uses

  = ;            =             &= nbsp;           &n= bsp;          # only = default tablespace

#check_func= tion_bodies =3D on

#default_tr= ansaction_isolation =3D 'read committed'

#default_tr= ansaction_read_only =3D off

#default_tr= ansaction_deferrable =3D off

#session_re= plication_role =3D 'origin'

#statement_= timeout =3D = 0            =            # in = milliseconds, 0 is disabled

#lock_timeo= ut =3D = 0            =           # in = milliseconds, 0 is disabled

#idle_in_tr= ansaction_session_timeout =3D = 0            =      # in milliseconds, 0 is = disabled

#vacuum_fre= eze_min_age =3D 50000000

#vacuum_fre= eze_table_age =3D 150000000

#vacuum_mul= tixact_freeze_min_age =3D 5000000

#vacuum_mul= tixact_freeze_table_age =3D 150000000

#bytea_outp= ut =3D = 'hex'           &n= bsp;           &nb= sp;  # hex, escape

#xmlbinary = =3D 'base64'

#xmloption = =3D 'content'

#gin_fuzzy_= search_limit =3D 0

#gin_pendin= g_list_limit =3D 4MB

 

# - Locale = and Formatting -

 

datestyle = =3D 'iso, dmy'

#intervalst= yle =3D 'postgres'

timezone = =3D 'Europe/Brussels'

#timezone_a= bbreviations =3D 'Default'     # Select the set of = available time zone

  = ;            =             &= nbsp;           &n= bsp;          # = abbreviations.  Currently, there are

  = ;            =             &= nbsp;           &n= bsp;          #   = Default

  = ;            =             &= nbsp;           &n= bsp;          #   = Australia (historical usage)

  = ;            =             &= nbsp;           &n= bsp;          #   = India

  = ;            =             &= nbsp;           &n= bsp;          # You can = create your own file in

  = ;            =             &= nbsp;           &n= bsp;          # = share/timezonesets/.

#extra_floa= t_digits =3D = 0            =              = # min -15, max 3

#client_enc= oding =3D = sql_ascii          &nbs= p;      # actually, defaults to = database

  = ;            =             &= nbsp;           &n= bsp;          # = encoding

 

# These = settings are initialized by initdb, but they can be = changed.

lc_messages= =3D = 'French_France.1252'         = ;            =     # locale for system error = message

  = ;            =             &= nbsp;           &n= bsp;          # = strings

lc_monetary= =3D = 'French_France.1252'         = ;            =      # locale for monetary = formatting

lc_numeric = =3D = 'French_France.1252'         = ;            =        # locale for number = formatting

lc_time = =3D = 'French_France.1252'         = ;            =             # = locale for time formatting

 

# default = configuration for text search

default_tex= t_search_config =3D 'pg_catalog.french'

 

# - Other = Defaults -

 

#dynamic_li= brary_path =3D '$libdir'

#local_prel= oad_libraries =3D ''

#session_pr= eload_libraries =3D ''

 

 

#----------= --------------------------------------------------------------------

# LOCK = MANAGEMENT

#----------= --------------------------------------------------------------------

 

#deadlock_t= imeout =3D 1s

#max_locks_= per_transaction =3D = 64            = ;       # min 10

  = ;            =             &= nbsp;           &n= bsp;          # (change = requires restart)

#max_pred_l= ocks_per_transaction =3D 64 # min 10

  = ;            =             &= nbsp;           &n= bsp;          # (change = requires restart)

 

 

#----------= --------------------------------------------------------------------

# = VERSION/PLATFORM COMPATIBILITY

#----------= --------------------------------------------------------------------

 

# - = Previous PostgreSQL Versions -

 

#array_null= s =3D on

#backslash_= quote =3D safe_encoding        # on, = off, or safe_encoding

#default_wi= th_oids =3D off

#escape_str= ing_warning =3D on

#lo_compat_= privileges =3D off

#operator_p= recedence_warning =3D off

#quote_all_= identifiers =3D off

#sql_inheri= tance =3D on

#standard_c= onforming_strings =3D on

#synchroniz= e_seqscans =3D on

 

# - Other = Platforms and Clients -

 

#transform_= null_equals =3D off

 

 

#----------= --------------------------------------------------------------------

# ERROR = HANDLING

#----------= --------------------------------------------------------------------

 

#exit_on_er= ror =3D = off           &nbs= p;            = ;     # terminate session on any = error?

#restart_af= ter_crash =3D = on            # = reinitialize after backend crash?

 

 

#----------= --------------------------------------------------------------------

# CONFIG = FILE INCLUDES

#----------= --------------------------------------------------------------------

 

# These = options allow settings to be loaded from files other than = the

# default = postgresql.conf.

 

#include_di= r =3D = 'conf.d'           = ;            =    # include files ending in '.conf' = from

  = ;            =             &= nbsp;           &n= bsp;          # directory = 'conf.d'

#include_if= _exists =3D 'exists.conf' # include file only if it = exists

#include = =3D = 'special.conf'          = ;    # include file

 

 

#----------= --------------------------------------------------------------------

# = CUSTOMIZED OPTIONS

#----------= --------------------------------------------------------------------

 

# Add = settings for extensions here

 

 

 

 

3D"Avast

L'absence de = virus dans ce courrier =C3=A9lectronique a =C3=A9t=C3=A9 = v=C3=A9rifi=C3=A9e par le logiciel antivirus Avast.
www.avast.com =

 



-- =

El genio es 1% inspiraci=C3=B3n = y 99% transpiraci=C3=B3n.
Thomas Alva Edison
http://pglearn.blogspot.mx/

 

------=_NextPart_001_03F7_01D48751.CB08CF80-- ------=_NextPart_000_03F6_01D48751.CB08CF80 Content-Type: image/png; name="image001.png" Content-Transfer-Encoding: base64 Content-ID: iVBORw0KGgoAAAANSUhEUgAAAFoAAAAhCAMAAABuk0wyAAABVlBMVEUAAAAtNkz/eAAtNkwtNkwt NkwtNkwtNkwtNkwtNkwtNkwtNkwtNkwtNkwtNkwtNkwtNkwtNkwtNkwtNkz/eAD/eAAtNkwtNkz/ eAAtNkwtNkz/eAD/eAAtNkz/eAAtNkwtNkwtNkwtNkwtNkwtNkwtNkwtNkwtNkwtNkwtNkwtNkz/ eAAtNkwtNkz/eAAtNkz/eAAtNkwtNkwtNkz/eAAtNkz/eAD/eAD/eAAtNkz/eAAtNkz/eAD/eAAt Nkz/eAD/eAD/eAD/eAAtNkz/eAAtNkz/eAAtNkz/eAD/eAAtNkwtNkz/eAD/eAAtNkz/eAD/eAAt Nkz/eAD/eAD/eAD/eAAtNkz/eAD/eAD/eAD/eAD/eAD/eAD/eAAtNkz//////Pn//vz/vYL/sWz/ plb/tXL/rGH/kjH/+PH/7+D/6tj/0Kb/xZH/mDz/iSD/hRf/ewX/oU0fLNpXAAAAXXRSTlMA8QEe hwb69TQJmTkRDeDPklNNSELz5qGHQxYE/tzCwLu2sapxYl0qJxsE++rVq4N1amZYVj8mFQnu7evl 28WwpZuQfXt3aUo9NC4YENLKuraOYFpHC+zngX5wHAh8XQyMAAADGElEQVRIx+WUR1siQRBAyyFH kSRiFhFQQBAQzDnHXXXz1CCgbjDs/v/LVnXP+KHiRfGy+w5Nh69f11RXA/8QO7n1oAJvwLdllRgo Q/tZITG72xT3++yXXpBsqjqnbTEXOcpp7lUifYZ6/YWylKt5tMqqiaPI5+VZ6rxO7UjjWHM+1BYE X6Y2IZqbhvsTT83HRhSukpvawh4oW0k5Ne438Y/F3hOltksMHIExf6qFGhaemLNnILabbYjWbo8T OyGPM25gJjGsgLLRgYix6CR6aSrOAzzcAh8K3oHBANuuarUb9fJC5D2nxzeCgs5F7IA4Yl5MhjEM 0C1X+ocQAQJ0vpeDcAzK6UEwOCDdxbmmadc/zlkdAckoYjqfKMUQSe2xUejEFn/yGM2MJlxORFaP YDpFqRl2wh5tGZ6KRw1zb0hVb7TqxVX9u6aROVSR85Y57BD5dbKaA92lAR2UhH602mVyWH2IXnfr a9wm3S+tTm1DqJdA4jKS5rayugfRBxC14iIkEbvlLc8giqPTZnsrdZZ0P7U7an9XWb0ip/mru2Sv k9WKFz9YOElxPmVKrgyz2uRFIlNQHqtP+4T6ltXnrD5urYY1HmfQ5mF1Xq6IawT3pJA7H6mnZ1WR kBq1dZnr/fuEOIHZ44SIbcN2TgX3RoDxdJCaUexcp4kH6u2PKnNV1a4btSolhFgF0MvM6uJtMWQ1 h2ilciyJz8AAz/iQ1bse7hcQ/az2gaCyavwfNag6qnVZfH05BZgpRNuaq2sIdXVBlDKv+WnFXPKL uqfB3AYVn48ryI0YDtj5qGX1nrvLy1v1T4O7xh+h8TAGh1gt6wE3gDHrj4mv0W7js63ypWTE8QBl irk1oR2RwdEwbTJTQIvGZ2Q8IIh7KXCfZ401JifLMebmC5qTr3FafZaFCgi5KWkBsAT0J5EIOEBH SSUs1Aai8r/K36M/QUdPl32c3uH88+4ivI5giCQHK7nNzU/Z2YfqCLyS8knxK0h6g0sP1W0l2JSg E2gv5SPDPH8GbaZXT8pEEKDt7kiIS28b3oL9YHFHgf+Sv0JnGhSQF4C0AAAAAElFTkSuQmCC ------=_NextPart_000_03F6_01D48751.CB08CF80--