Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 5D92B9FA1F9 for ; Fri, 2 Nov 2007 11:11:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 64300-04 for ; Fri, 2 Nov 2007 11:11:21 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from bay0-omc3-s25.bay0.hotmail.com (bay0-omc3-s25.bay0.hotmail.com [65.54.246.225]) by postgresql.org (Postfix) with ESMTP id 311D89FA1F6 for ; Fri, 2 Nov 2007 11:11:30 -0300 (ADT) Received: from BAY116-W33 ([64.4.38.133]) by bay0-omc3-s25.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.3959); Fri, 2 Nov 2007 07:11:28 -0700 Message-ID: Content-Type: multipart/alternative; boundary="_64acf47a-f15e-40bd-a46e-1ddefbf10eec_" X-Originating-IP: [204.132.58.73] From: dx k9 To: Subject: jumpstart - pgsql.v824 Date: Fri, 2 Nov 2007 10:11:28 -0400 Importance: Normal MIME-Version: 1.0 X-OriginalArrivalTime: 02 Nov 2007 14:11:28.0862 (UTC) FILETIME=[43036FE0:01C81D5A] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.801 tagged_above=0 required=5 tests=AWL=0.799, BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200711/21 X-Sequence-Number: 27264 --_64acf47a-f15e-40bd-a46e-1ddefbf10eec_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi Everyone, Is there any way to trick an instance into starting when you just have base= , global, pg_clog, pg_mulitxact, pg_subtrans, pg_tblspc, & pg_twophase, but= no pg_xlog? We weren't backing up the pg_xlog, because we didn't think we needed it, b= ut the backup_label seems to need it. Even if we take the backup_label fil= e out, and try to start postgres, it doesn't start. I'm going to start experimenting and testing to see if I can trick it to st= arting, but if anyone has any insight that would help. We noticed this on = a test restore, so it wasn't a major problem, now we are backing up the pg_= xlog files as well. ~DjK _________________________________________________________________ Windows Live Hotmail and Microsoft Office Outlook =96 together at last. =A0= Get it now. http://office.microsoft.com/en-us/outlook/HA102225181033.aspx?pid=3DCL10062= 6971033= --_64acf47a-f15e-40bd-a46e-1ddefbf10eec_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi Everyone,

Is there any way to trick an instance into starting whe= n you just have base, global, pg_clog, pg_mulitxact, pg_subtrans, pg_tblspc= , & pg_twophase, but no pg_xlog?

 We weren't backing up the= pg_xlog, because we didn't think we needed it, but the backup_label seems = to need it.  Even if we take the backup_label file out, and try to sta= rt postgres, it doesn't start.

I'm going to start experimenting and = testing to see if I can trick it to starting, but if anyone has any insight= that would help.  We noticed this on a test restore, so it wasn't a m= ajor problem, now we are backing up the pg_xlog files as well.

~DjK<= br>


Windows Live Hotmail and Microsoft Office Outlook =96 to= gether at last. Get it now! = --_64acf47a-f15e-40bd-a46e-1ddefbf10eec_--