We need to "recreate" our demonstration database about every two hours,
and we'd like to develop a cron job, calling scripts, that will
accomplish that for us.
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.
Basically, here's what we're trying to do:
dump (pg_dump) our demo_model database to a "demo_model.sql" file
/usr/bin/psql active_demo < demo_model.sql > /dev/null
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2005-03-22 18:53:59|
|Subject: Re: timestamp group by bug??? |
|Previous:||From: Tom Lane||Date: 2005-03-22 18:19:34|
|Subject: Re: Compiling 8.0.1 on Ubuntu AMD_64 |