Received: from mx1.ZSEA.zp.ua (ZSEA.zp.ua [212.8.40.5])
	by hub.org (8.10.1/8.10.1) with ESMTP id e8ICdhs46585
	for <pgsql-interfaces@postgresql.org>;
	Mon, 18 Sep 2000 08:39:44 -0400 (EDT)
Received: (from laa@localhost) by mx1.ZSEA.zp.ua (8.9.3/8.9.3) id PAA05878
	for pgsql-interfaces@postgresql.org;
	Mon, 18 Sep 2000 15:39:23 +0300 (EEST) (envelope-from laa@laa.zp.ua)
Date: Mon, 18 Sep 2000 15:39:23 +0300
From: "Alexandr A. Listopad" <laa@laa.zp.ua>
To: "pgsql-interfaces@postgresql.org" <pgsql-interfaces@postgresql.org>
Subject: Fwd: Cron <root@Eagle> /etc/counts/squid-logs/copy-to-sql.sh
Message-ID: <20000918153923.A5774@laa.zp.ua>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
X-Archive-Number: 200009/67

----- Forwarded message from Cron Daemon <root> -----

Date: Mon, 18 Sep 2000 00:25:36 +0300 (EEST)
From: root (Cron Daemon)
To: root
Subject: Cron <root@Eagle> /etc/counts/squid-logs/copy-to-sql.sh

pqReadData() --  read() failed: errno=60
Operation timed out
PQendcopy: resetting connection

----- End forwarded message -----


this is my  /etc/counts/squid-logs/copy-to-sql.sh file:
----------
#!/bin/sh

rm -f /p/logs/log_to_sql >/dev/null ;

/etc/counts/squid-logs/log-squid-to-sql.perl \
        /p/logs/access.log.0 /p/logs/log_to_sql &&

/usr/local/pgsql/bin/psql -h eagle -c \
        "COPY squid_logs
                 FROM STDIN
                 USING DELIMITERS '\t';" stats \
        < /p/logs/log_to_sql &&
                rm -f /p/logs/log_to_sql >/dev/null

----------

Where mistake?

-- 
 Laa