pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
automatic restore of database
4+ messages / 4 participants
[nested] [flat]

* automatic restore of database
@ 2001-07-05 09:40 Jacky Cheang <s050399b@hotmail.com>
  2001-07-05 21:57 ` Re: automatic restore of database Dennis <dennis@zserve.com>
  2001-07-10 23:31 ` Re: automatic restore of database Grant <grant@conprojan.com.au>
  0 siblings, 2 replies; 4+ messages in thread

From: s050399b@hotmail.com @ 2001-07-05 09:40 UTC (permalink / raw)
  To: pgsql-sql

Dear sir/mdm,

How do I automatic restore a database everyday in the morning?




Pls advise,

Jacky



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: automatic restore of database
  2001-07-05 09:40 automatic restore of database Jacky Cheang <s050399b@hotmail.com>
@ 2001-07-05 21:57 ` Dennis <dennis@zserve.com>
  2001-07-05 22:23   ` Re: Re: automatic restore of database clayton cottingham <drfrog@smartt.com>
  1 sibling, 1 reply; 4+ messages in thread

From: Dennis @ 2001-07-05 21:57 UTC (permalink / raw)
  To: pgsql-sql

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
> 




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Re: automatic restore of database
  2001-07-05 09:40 automatic restore of database Jacky Cheang <s050399b@hotmail.com>
  2001-07-05 21:57 ` Re: automatic restore of database Dennis <dennis@zserve.com>
@ 2001-07-05 22:23   ` clayton cottingham <drfrog@smartt.com>
  0 siblings, 0 replies; 4+ messages in thread

From: clayton cottingham @ 2001-07-05 22:23 UTC (permalink / raw)
  To: dennis@zserve.com; +Cc: 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@postgresql.org so that your
> message can get through to the mailing list cleanly



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: automatic restore of database
  2001-07-05 09:40 automatic restore of database Jacky Cheang <s050399b@hotmail.com>
@ 2001-07-10 23:31 ` Grant <grant@conprojan.com.au>
  1 sibling, 0 replies; 4+ messages in thread

From: Grant @ 2001-07-10 23:31 UTC (permalink / raw)
  To: pgsql-sql

www.postgresql.org/docs

Go to Admin and look up pg_dump. It has some nice examples. A postgresql
backup script is available at http://database.sourceforge.net




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2001-07-10 23:31 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-07-05 09:40 automatic restore of database Jacky Cheang <s050399b@hotmail.com>
2001-07-05 21:57 ` Dennis <dennis@zserve.com>
2001-07-05 22:23   ` clayton cottingham <drfrog@smartt.com>
2001-07-10 23:31 ` Grant <grant@conprojan.com.au>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox