Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f65LxUa61951 for ; Thu, 5 Jul 2001 17:59:30 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f65LvhM20490 for pgsql-sql@postgresql.org; Thu, 5 Jul 2001 17:57:43 -0400 (EDT) (envelope-from news) From: Dennis X-Newsgroups: comp.databases.postgresql.sql Subject: Re: automatic restore of database Date: Thu, 5 Jul 2001 15:57:41 -0600 Organization: ZServe Lines: 21 Message-ID: <9i2nsl$jv9$1@news.tht.net> References: <7da55afe.0107050140.7f7e68f0@posting.google.com> Reply-To: dennis@zserve.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7Bit X-Complaints-To: scrappy@hub.org User-Agent: KNode/0.4 To: pgsql-sql@postgresql.org X-Archive-Number: 200107/48 X-Sequence-Number: 3829 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 >