Fwd: Cron <root@Eagle> /etc/counts/squid-logs/copy-to-sql.sh

From: "Alexandr A(dot) Listopad" <laa(at)laa(dot)zp(dot)ua>
To: "pgsql-interfaces(at)postgresql(dot)org" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Fwd: Cron <root@Eagle> /etc/counts/squid-logs/copy-to-sql.sh
Date: 2000-09-18 12:39:23
Message-ID: 20000918153923.A5774@laa.zp.ua
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

----- 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(at)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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Chris Haas 2000-09-18 20:17:37 upgrade pgaccess v0.96 to v0.98 fatal error: attribute querytables not found
Previous Message Peter Mount 2000-09-18 10:44:12 RE: jdbc - prepared statement and cvs questions