X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6C042DAF31 for ; Tue, 25 Oct 2005 23:14:36 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 51790-02 for ; Wed, 26 Oct 2005 02:14:31 +0000 (GMT) Received: from web2102.mail.yahoo.co.jp (web2102.mail.yahoo.co.jp [211.14.23.76]) by svr1.postgresql.org (Postfix) with SMTP id 623BEDAF0B for ; Tue, 25 Oct 2005 23:14:32 -0300 (ADT) Received: (qmail 93646 invoked by uid 60001); 26 Oct 2005 02:14:37 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=yj20050223; d=yahoo.co.jp; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type; b=N0p1FJLqfNdEnzUdaoR3gdm+t/kmBdo10Gbw/IFdBjz2yd/A2oDP+fn3VPNsHrOqqbaMQGZsd3frlDIVOzS3rsFJ8lJth4nX3xU0xtLtMLkvV9WROC9WQCie6qA0S5Pj ; Message-ID: <20051026021437.93644.qmail@web2102.mail.yahoo.co.jp> Received: from [210.249.77.10] by web2102.mail.yahoo.co.jp via HTTP; Wed, 26 Oct 2005 11:14:37 JST Date: Wed, 26 Oct 2005 11:14:37 +0900 (JST) From: acemeicn Subject: a error about PostgreSQL7.3.4's Log setting To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-2022-jp X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200510/272 X-Sequence-Number: 19344 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