From: | Patrick Meylemans <Patrick(dot)Meylemans(at)wtcm(dot)be> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | SI buffer overflow |
Date: | 2003-01-13 21:20:49 |
Message-ID: | 5.2.0.9.0.20030113221022.04180948@server04.site04.wtcm.be |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Dear,
From time to time we receive some DEBUG information in the /var/log/messages
logger: DEBUG: SendSharedInvalidMessage: SI buffer overflow
I assume this is a parameter witch is too low, can anybody tell me what
parameter this is
Our settings:
THE OS
Red Hat Linux release 7.0 (Guinness)
Kernel 2.2.16-22 on an i686
Postgresql version
psql (PostgreSQL) 7.2.3
contains support for: readline, history
Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group
Portions Copyright (c) 1996, Regents of the University of California
Read the file COPYRIGHT or use the command \copyright to see the
usage and distribution terms.
The config file
#max_connections = 32
# VKP max_connections = 64
max_connections = 64
#port = 5432
#hostname_lookup = false
#show_source_port = false
#unix_socket_directory = ''
#unix_socket_group = ''
#unix_socket_permissions = 0777
#virtual_host = ''
#krb_server_keyfile = ''
#
# Shared Memory Size
#
#shared_buffers = 64 # 2*max_connections, min 16
# VKP shared_buffer = 8192
shared_buffers = 8192
#max_fsm_relations = 100 # min 10, fsm is free space map
#max_fsm_pages = 10000 # min 1000, fsm is free space map
#max_locks_per_transaction = 64 # min 10
#wal_buffers = 8 # min 4
#
# Non-shared Memory Sizes
#
#sort_mem = 512 # min 32
# VKP sort_mem = 16384
sort_mem = 16384
#vacuum_mem = 8192 # min 1024
#
# Write-ahead log (WAL)
#
#wal_files = 0 # range 0-64
#wal_sync_method = fsync # the default varies across platforms:
# # fsync, fdatasync, open_sync, or open_datasync
#wal_debug = 0 # range 0-16
#commit_delay = 0 # range 0-100000
#commit_siblings = 5 # range 1-1000
#checkpoint_segments = 3 # in logfile segments (16MB each), min 1
#checkpoint_timeout = 300 # in seconds, range 30-3600
#fsync = true
# VKP fsync = false
fsync = false
Thanks in advance
Patrick Meylemans
WTCM-CRIF
Celestijnenlaan 300C
3001 Heverlee
Mobile : +32(0)498 91 93 10
From | Date | Subject | |
---|---|---|---|
Next Message | codeWarrior | 2003-01-13 21:40:10 | Re: Database logging.... Recycle server logs ??? |
Previous Message | Laurette Cisneros | 2003-01-13 20:45:49 | Re: crypto? |