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
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 |