Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group