pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: acemeicn <acemeijp@yahoo.co.jp>
To: pgsql-admin@postgresql.org
Subject: a error about PostgreSQL7.3.4's Log setting
Date: Wed, 26 Oct 2005 11:14:37 +0900 (JST)
Message-ID: <20051026021437.93644.qmail@web2102.mail.yahoo.co.jp> (raw)

Hi everyone, 
My name is Ken working in Tokyo,Japan. Please forgive my
poor English.

We have been using PostgreSQL7.3.4 on a Map GIS engine
since last year.To tune the system, I need to get the log
from PostgreSQL7.3.4 and analyze it. 

Here comes the problem. When a long SQL is excuted. I got
the error as follow 

error:SQL Execute error  0 = Too much data was received.

when I removed the log setting from my postgresql.conf
file the sql was excuted without any problem and ended
normally. I appand my postgresql.conf and start shell as
follow.
 
postgresql.conf
----------------------------------------------------------------
#
# Message display
#
server_min_messages = log
# Values, in order of decreasing detail:
# debug5, debug4, debug3, debug2, debug1,
# info, notice, warning, error, log, fatal,
# panic
client_min_messages = log
# Values, in order of decreasing detail:
# debug5, debug4, debug3, debug2, debug1,
# log, info, notice, warning, error
silent_mode = false

log_connections = false
log_pid = true
log_statement = true
log_duration = true
log_timestamp = true

#
# Syslog
#
syslog = 1 # range 0-2
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'

LC_MESSAGES = 'C'
LC_MONETARY = 'C'
LC_NUMERIC = 'C'
LC_TIME = 'C'
----------------------------------------------------------------

start_pgsql.sh
----------------------------------------------------------------
pg_ctl start -D /data/pgsql -o "-i" -l
/data/pgsql/postgresql.log
----------------------------------------------------------------
develop environment
OS: solaris2.9
Apserver: Sun application Server 7
JDBC Driver: pg74.215.jdbc3.jar

can any friend help me, thanks a lot



view thread (5+ messages)  latest in thread

Message-ID: <20051026021437.93644.qmail@web2102.mail.yahoo.co.jp>
Permalink:  ../20051026021437.93644.qmail@web2102.mail.yahoo.co.jp/
Also on:    postgresql.org/message-id/20051026021437.93644.qmail@web2102.mail.yahoo.co.jp

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: acemeijp@yahoo.co.jp
  Subject: Re: a error about PostgreSQL7.3.4's Log setting
  In-Reply-To: <20051026021437.93644.qmail@web2102.mail.yahoo.co.jp>
  References: <20051026021437.93644.qmail@web2102.mail.yahoo.co.jp>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox