Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eAODZqA39321 for ; Fri, 24 Nov 2000 08:35:53 -0500 (EST) (envelope-from pgsql-admin-owner@postgresql.org) Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eANHRIA74947 for ; Thu, 23 Nov 2000 12:27:18 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id eANHQnw07421; Thu, 23 Nov 2000 12:26:49 -0500 (EST) To: sathya priya cc: pgsql-admin@postgresql.org Subject: Re: [INTERFACES] PQendcopy: resetting connection error In-reply-to: <20001123143100.3631.qmail@web1901.mail.yahoo.com> References: <20001123143100.3631.qmail@web1901.mail.yahoo.com> Comments: In-reply-to sathya priya message dated "Thu, 23 Nov 2000 06:31:00 -0800" Date: Thu, 23 Nov 2000 12:26:49 -0500 Message-ID: <7418.975000409@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200011/159 X-Sequence-Number: 168 sathya priya writes: > pg_dump -z dbname > bkfilename > PQendcopy: resetting connection It's difficult to tell from this what made the COPY command fail. There might be more info in the postmaster's logfile, though. (If you're not running the postmaster with a logfile, restart it with one --- no -S switch, send stdout and stderr to a file --- and do the dump again.) regards, tom lane