Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f3DMuC842007 for ; Fri, 13 Apr 2001 18:56:12 -0400 (EDT) (envelope-from pgsql-general-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3D6tD845737 for ; Fri, 13 Apr 2001 02:55:13 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f3D6h5d68907 for pgsql-general@postgresql.org; Fri, 13 Apr 2001 02:43:05 -0400 (EDT) (envelope-from news) From: "Newbie" Subject: Log File? Date: Wed, 11 Apr 2001 21:48:27 -0700 Lines: 13 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 Message-ID: X-Newsgroups: comp.databases.postgresql.questions To: pgsql-general@postgresql.org X-Archive-Number: 200104/546 X-Sequence-Number: 7678 Our company is deciding whether to choose Postgresql or not and have a question. Say we back up our database every night and the next day at 11am, the hard drive crashes. We then have data from our back up from last night, but, is there a way to have a log file sitting somewhere other than the hard drive that will allow us to retrieve all data from that morning and add that data to the back up? Therefore, we will have only lost the trasaction that we would have been working on because it has not been commited. Any answer would be extremely helpful.