Received: from rossini.ednet.co.uk (root@rossini.ednet.co.uk [212.20.226.132]) by hub.org (8.10.1/8.10.1) with ESMTP id e55CjJO05634 for ; Mon, 5 Jun 2000 08:45:23 -0400 (EDT) Received: from qube.buildstore.office (dialup7.ednet.co.uk [212.20.228.70]) by rossini.ednet.co.uk (8.9.3/8.9.3) with ESMTP id NAA07022 for ; Mon, 5 Jun 2000 13:45:10 +0100 Received: from buildstore.co.uk (babyb.buildstore.office [192.168.1.78]) by qube.buildstore.office (8.9.2/8.9.2) with ESMTP id NAA27639 for ; Mon, 5 Jun 2000 13:36:58 +0100 (BST) Message-ID: <393B9EA9.EDBD54CA@buildstore.co.uk> Date: Mon, 05 Jun 2000 13:35:53 +0100 From: Allan Kelly Organization: buildstore X-Mailer: Mozilla 4.6 [en-gb]C-CCK-MCD NetscapeOnline.co.uk (Win98; I) X-Accept-Language: en-GB,en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: cron job INSERT appears to bail. Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200006/35 Hi, I have mirrored our Web site to a client's intranet, using tried and tested techniques. Every day I generate a new file containing some table drops, some table creates and about 7000 insert statements. This is ftp'd up to our ISP, where a cronjob uses 'psql -f' to update the Website data. Great, all is well. 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. Running the 'psql -f' from the command line works just fine. So.. what is it about the cron job that is limiting? I know this is probably a systems issue, rather than a PostgreSQL issue per se, but I am completely stumped. And this is all a little embarassing! Linux Mandrake 7.0, Intel platform, postgres 6.5.2 -- # Allan Kelly http://www.plotsearch.co.uk # (+44) (0)1506 417130 x 229 # allan.kelly@buildstore.co.uk... .. # /Software Engineer/i . . . . . # ------------------------------ * . . . . . # "If you are a Visual Basic programmer, * . . . # these details are none of your business." * . . . # Mr Bunny's Guide to Active X, by Carlton Egremont III * . . # ------------------------------ vi: set noet tw=80 sts=4 ts=8 : .