pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedautomatic 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