Re: Re: automatic restore of database

From: clayton cottingham <drfrog(at)smartt(dot)com>
To: dennis(at)zserve(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Re: automatic restore of database
Date: 2001-07-05 22:23:51
Message-ID: 3B44E8F7.E5DE71D8@smartt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-07-06 04:23:42 Re: Text manipulation in SQL
Previous Message Dennis 2001-07-05 21:57:41 Re: automatic restore of database