X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id EB05F9FB433 for ; Thu, 31 Aug 2006 17:20:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 93197-08 for ; Thu, 31 Aug 2006 20:19:56 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 400799FB30A for ; Thu, 31 Aug 2006 17:19:37 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k7VKJZgq023431; Thu, 31 Aug 2006 16:19:35 -0400 (EDT) To: "Sriram Dandapani" cc: pgsql-admin@postgresql.org Subject: Re: archive logs recovery In-reply-to: <6992E470F12A444BB787B5C937B9D4DF05ABC495@ca-mail1.cis.local> References: <6992E470F12A444BB787B5C937B9D4DF05ABC495@ca-mail1.cis.local> Comments: In-reply-to "Sriram Dandapani" message dated "Thu, 31 Aug 2006 12:12:20 -0700" Date: Thu, 31 Aug 2006 16:19:35 -0400 Message-ID: <23430.1157055575@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200608/364 X-Sequence-Number: 22907 "Sriram Dandapani" writes: > I have a situation where the database needs to be restarted > periodically. Will this affect recovery of a database using a base > online backup that took place earlier than the restart. No. But why do you need to shut down the database? Most people around here seem to want 24x7 operation ... regards, tom lane