Received: from marketingchallenge.com (marketingchallenge.com [64.40.111.205] (may be forged)) by postgresql.org (8.11.3/8.11.1) with SMTP id f65MMVa70606 for ; Thu, 5 Jul 2001 18:22:31 -0400 (EDT) (envelope-from drfrog@smartt.com) Received: (qmail 21783 invoked from network); 5 Jul 2001 22:22:26 -0000 Received: from clayton-cottingham.imc (HELO smartt.com) (10.1.4.1) by marketingchallenge.com with SMTP; 5 Jul 2001 22:22:26 -0000 Message-ID: <3B44E8F7.E5DE71D8@smartt.com> Date: Thu, 05 Jul 2001 15:23:51 -0700 From: clayton cottingham X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.17-21mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: dennis@zserve.com CC: pgsql-sql@postgresql.org Subject: Re: Re: automatic restore of database References: <7da55afe.0107050140.7f7e68f0@posting.google.com> <9i2nsl$jv9$1@news.tht.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200107/49 X-Sequence-Number: 3830 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