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

Re: dump & create with a cron job

From: "Keith Worthington" <keithw(at)narrowpathinc(dot)com>
To: Jack Miller <jgm(at)miller-group(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: dump & create with a cron job
Date: 2005-03-22 19:37:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
On Tue, 22 Mar 2005 14:17:39 -0500, Tom Lane wrote
> 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
> 		sleep 10
> 	done
> 	createdb active_demo
> 	/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

I have scripts that you could have but they are only simple wrappers around
the pg_dump command.  As Tom suggests you need to make sur the drop is
working.  Do you utilize PGDATABASE in your setup?  Could you run two or more
databases at a time and utilize a round robin approach? 

As an outline:

# create connections to demo1 for a while
# check if anyone is still connected to demo2
dropdb demo2
createdb demo2
# create connections to demo2 for a while
# check if anyone is still connected to demo1
dropdb demo1
createdb demo1
# back to the top

Kind Regards,

In response to

pgsql-novice by date

Next:From: Marubayashi, Roy (Mission Systems)Date: 2005-03-23 00:06:59
Subject: I'd Like To See Permissions Granted
Previous:From: Tom LaneDate: 2005-03-22 19:17:39
Subject: Re: dump & create with a cron job

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