Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e55Fm1O64869 for ; Mon, 5 Jun 2000 11:48:01 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id LAA12235; Mon, 5 Jun 2000 11:47:55 -0400 (EDT) To: Allan Kelly cc: "pgsql-sql@postgresql.org" Subject: Re: cron job INSERT appears to bail. In-reply-to: <393B9EA9.EDBD54CA@buildstore.co.uk> References: <393B9EA9.EDBD54CA@buildstore.co.uk> Comments: In-reply-to Allan Kelly message dated "Mon, 05 Jun 2000 13:35:53 +0100" Date: Mon, 05 Jun 2000 11:47:55 -0400 Message-ID: <12232.960220075@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200006/39 Allan Kelly writes: > The intranet mirror for the client later grabs the file from the ISP > and attempts the same 'psql -f' but appears to stop after a few > inserts. "Appears to stop" is hardly enough of a problem description to allow useful advice to be given. Does the process quit, or just hang up waiting for something? Is there anything reported in the postmaster log? (You might try firing up the psql run with environment variable PGOPTIONS = "-d2" to cause individual queries to be logged.) regards, tom lane