pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
cron job INSERT appears to bail.
2+ messages / 2 participants
[nested] [flat]

* cron job INSERT appears to bail.
@ 2000-06-05 12:35 Allan Kelly <allan.kelly@buildstore.co.uk>
  2000-06-05 15:47 ` Re: cron job INSERT appears to bail. Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Allan Kelly @ 2000-06-05 12:35 UTC (permalink / raw)
  To: pgsql-sql

Hi, I have mirrored our Web site to a client's intranet, using tried and tested
techniques. Every day I generate a new file containing some table drops, some
table creates and about 7000 insert statements. This is ftp'd up to our ISP,
where a cronjob uses 'psql -f' to update the Website data. Great, all is well.

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. Running the
'psql -f' from the command line works just fine.

So.. what is it about the cron job that is limiting? I know this is probably a
systems issue, rather than a PostgreSQL issue per se, but I am completely
stumped. And this is all a little embarassing!

Linux Mandrake 7.0, Intel platform, postgres 6.5.2

-- 

 # Allan Kelly                                http://www.plotsearch.co.uk
 # (+44) (0)1506 417130 x 229
 # allan.kelly@buildstore.co.uk...     ..
 # /Software Engineer/i            . .    .    . .
 # ------------------------------   *      . .     .    . .
 # "If you are a Visual Basic programmer,   *       . .     .
 #  these details are none of your business."        *       .  . .
 # Mr Bunny's Guide to Active X, by Carlton Egremont III      *     . .
 # ------------------------------      vi: set noet tw=80 sts=4 ts=8  : .



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: cron job INSERT appears to bail.
  2000-06-05 12:35 cron job INSERT appears to bail. Allan Kelly <allan.kelly@buildstore.co.uk>
@ 2000-06-05 15:47 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2000-06-05 15:47 UTC (permalink / raw)
  To: Allan Kelly <allan.kelly@buildstore.co.uk>; +Cc: pgsql-sql

Allan Kelly <allan.kelly@buildstore.co.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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2000-06-05 15:47 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-06-05 12:35 cron job INSERT appears to bail. Allan Kelly <allan.kelly@buildstore.co.uk>
2000-06-05 15:47 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox