Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 47DCD9FC18D for ; Fri, 15 Jun 2007 10:28:57 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 75219-05 for ; Fri, 15 Jun 2007 10:28:41 -0300 (ADT) X-Greylist: delayed 00:16:51.577043 by SQLgrey-1.7.5 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 205689FC0E9 for ; Fri, 15 Jun 2007 10:28:53 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from smtp-out5.blueyonder.co.uk (smtp-out5.blueyonder.co.uk [195.188.213.8]) by svr4.postgresql.org (Postfix) with ESMTP id 66F325AF03A for ; Fri, 15 Jun 2007 13:12:00 +0000 (GMT) Received: from [172.23.170.147] (helo=anti-virus03-10) by smtp-out5.blueyonder.co.uk with smtp (Exim 4.52) id 1HzBan-0005U9-Ni for pgsql-admin@postgresql.org; Fri, 15 Jun 2007 14:11:57 +0100 Received: from [82.44.23.191] (helo=demolish1) by asmtp-out2.blueyonder.co.uk with smtp (Exim 4.52) id 1HzBTG-0001qE-81 for pgsql-admin@postgresql.org; Fri, 15 Jun 2007 14:04:10 +0100 Message-ID: <001201c7af4d$a9fe0cd0$7d64a8c0@demolish1> From: "Donald Fraser" To: "[ADMIN]" Subject: WAL file creation Date: Fri, 15 Jun 2007 14:04:09 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000F_01C7AF56.0B893C60" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1807 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.498 tagged_above=0 required=5 tests=BAYES_50=0.001, HTML_40_50=0.496, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200706/117 X-Sequence-Number: 25785 This is a multi-part message in MIME format. ------=_NextPart_000_000F_01C7AF56.0B893C60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Does anybody know if it is possible to create a set of *blank* WAL files = for PostgreSQL 8.1, knowing that the database was safely shut down and = all data is in tact? The reason is that during the weekend I failed our master database over = to our disaster recovery site, put that in read only mode, whilst I = upgraded the master database, and after completing the upgrade and = shutting the master down, I some how messed up re-connecting DRDB and = lost all the new WAL files. From that point on the master would not = start-up for obvious reasons, but I knew there were no pending = transactions to be rolled forward in the WAL files, yet without a valid = WAL file its impossible to start PostgreSQL. Thanks in advance, regards Donald Fraser ------=_NextPart_000_000F_01C7AF56.0B893C60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Does anybody know if it is possible to create a set = of *blank*=20 WAL files for PostgreSQL 8.1, knowing that the database was = safely=20 shut down and all data is in tact?
 
The reason is that during the weekend I = failed our=20 master database over to our disaster recovery site, put that in = read only=20 mode, whilst I upgraded the master database, and after completing=20 the upgrade and shutting the master down, I some how messed up=20 re-connecting DRDB and lost all the new WAL files. From that point on = the master=20 would not start-up for obvious reasons, but I knew there were no pending = transactions to be rolled forward in the WAL files, yet without a valid = WAL file=20 its impossible to start PostgreSQL.
 
Thanks in advance,
regards
Donald Fraser
------=_NextPart_000_000F_01C7AF56.0B893C60--