Thread: Re: automatic restore of database

Re: automatic restore of database

From
Dennis
Date:
You can use pg_restore to restore a db.   ( Try pg_restore --help )
You can use a cron job to run it everyday.

But don't you mean Backup the database?

-Dennis

Jacky Cheang wrote:

> Dear sir/mdm,
> 
> How do I automatic restore a database everyday in the morning?
> 
> 
> 
> 
> Pls advise,
> 
> Jacky
> 



Re: Re: automatic restore of database

From
clayton cottingham
Date:
Dennis wrote:
> 
> You can use pg_restore to restore a db.   ( Try pg_restore --help )
> You can use a cron job to run it everyday.
> 
> But don't you mean Backup the database?
> 

on this note i was wondering 
if a oracle type back up
scenario is planned for postgres?


one of the reasons my work wont switch to postgresql is
because they cant get that type of backup functionality

i personally dont know anything about oracles ability to backup so ...

any comments on this totally appreciated



> -Dennis
> 
> Jacky Cheang wrote:
> 
> > Dear sir/mdm,
> >
> > How do I automatic restore a database everyday in the morning?
> >
> >
> >
> >
> > Pls advise,
> >
> > Jacky
> >
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly