Jack Miller <jgm(at)miller-group(dot)net> writes:
> The problem is.... if someone is on our web demo at the time that the
> cron job goes off, it does not "dump" the database, it only "adds" the
> data to the database as the existing one.
Evidently you are neglecting to check for failure of the dropdb step.
Perhaps something like
while ! dropdb active_demo; do
/usr/bin/psql active_demo < demo_model.sql > /dev/null
This kinda begs the whole question of interlocking though; won't people
see funny behavior when you do this?
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Keith Worthington||Date: 2005-03-22 19:37:24|
|Subject: Re: dump & create with a cron job |
|Previous:||From: Tom Lane||Date: 2005-03-22 18:53:59|
|Subject: Re: timestamp group by bug??? |