| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Allan Kelly <allan(dot)kelly(at)buildstore(dot)co(dot)uk> |
| Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: cron job INSERT appears to bail. |
| Date: | 2000-06-05 15:47:55 |
| Message-ID: | 12232.960220075@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Allan Kelly <allan(dot)kelly(at)buildstore(dot)co(dot)uk> writes:
> 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.
"Appears to stop" is hardly enough of a problem description to allow
useful advice to be given. Does the process quit, or just hang up
waiting for something? Is there anything reported in the postmaster
log? (You might try firing up the psql run with environment variable
PGOPTIONS = "-d2" to cause individual queries to be logged.)
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Hoffmann | 2000-06-05 15:52:38 | Re: Default timestamp value |
| Previous Message | Tom Lane | 2000-06-05 15:27:49 | Re: Default timestamp value |