Received: from magus.postgresql.org ([87.238.57.229])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <craig@2ndQuadrant.com>) id 1TXUa1-0003kI-AS
	for pgsql-admin@postgresql.org; Sun, 11 Nov 2012 10:15:53 +0000
Received: from outmail149078.authsmtp.net ([62.13.149.78])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <craig@2ndQuadrant.com>) id 1TXUZy-0000Fg-FR
	for pgsql-admin@postgresql.org; Sun, 11 Nov 2012 10:15:52 +0000
Received: from mail-c232.authsmtp.com (mail-c232.authsmtp.com [62.13.128.232])
	by punt8.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id
	qABAFmS9028918; Sun, 11 Nov 2012 10:15:48 GMT
Received: from ayaki.localdomain (124-148-90-153.dyn.iinet.net.au
	[124.148.90.153]) (authenticated bits=0)
	by mail.authsmtp.com (8.14.2/8.14.2/) with ESMTP id qABAFfQf049699
	(version=TLSv1/SSLv3 cipher=DHE-RSA-CAMELLIA256-SHA bits=256 verify=NO);
	Sun, 11 Nov 2012 10:15:43 GMT
Message-ID: <509F7ACB.9040103@2ndQuadrant.com>
Date: Sun, 11 Nov 2012 18:15:39 +0800
From: Craig Ringer <craig@2ndQuadrant.com>
Organization: 2nd Quadrant
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:16.0) Gecko/20121016 Thunderbird/16.0.1
MIME-Version: 1.0
To: Pat Heuvel <pheuvel@tpg.com.au>
CC: pgsql-admin@postgresql.org
Subject: Re: No databases visible on pg 8.3 server
References: <k7mrf0$2nir$1@news.hub.org>
In-Reply-To: <k7mrf0$2nir$1@news.hub.org>
Content-Type: multipart/alternative;
	boundary="------------090905060201020107050805"
X-Server-Quench: c1523707-2be8-11e2-b10b-0025903375e2
X-AuthReport-Spam: If SPAM / abuse - report it at:
	http://www.authsmtp.com/abuse
X-AuthRoute: OCdxZQATClZeVg0b BQteCiN5VAwpPBRK HVkIKg5MJUcNSQVJ
	NksadBtFaQRbY1ZH HGQLWlZEUV17WGZ/ bw8fbAdZfEtKVxtj
	UFZIR1FNFgBqBAMA SF9vIGgEIWQQeHp5 Y09rEHZeW0c0Jkd4
	QE1TFWobZzU1YH0e URVaalFVcFFXfh9H b1l/V3AKZDAFKBg1
	TUcAFhwUHBNqYAJS Cg0EMVsYSF0GBXYi RgsDFzEiVUoDDz08
	Z0xgcRYHEVwPP19a
X-Authentic-SMTP: 61633235383639.1019:706
X-AuthFastPath: 0 (Was 255)
X-AuthSMTP-Origin: 124.148.90.153/2525
X-AuthVirus-Status: No virus detected - but ensure you scan with your own
	anti-virus system.
X-Pg-Spam-Score: -2.6 (--)
X-Archive-Number: 201211/64
X-Sequence-Number: 40309

This is a multi-part message in MIME format.
--------------090905060201020107050805
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

On 11/11/2012 08:27 AM, Pat Heuvel wrote:
>
> 2012-11-05 23:03:07 EST LOG:  could not open file
> "pg_xlog/00000001000002850000002E" (log file 645, segment 46): No such
> file or directory
If you haven't already, before you do ANYTHING ELSE, take a file-system
level copy of the PostgreSQL database while the server is stopped. See
http://wiki.postgresql.org/wiki/Corruption .

--
Craig Ringer

--------------090905060201020107050805
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">On 11/11/2012 08:27 AM, Pat Heuvel
      wrote:<br>
    </div>
    <blockquote cite="mid:k7mrf0$2nir$1@news.hub.org" type="cite"><br>
      2012-11-05 23:03:07 EST LOG:&nbsp; could not open file
      "pg_xlog/00000001000002850000002E" (log file 645, segment 46): No
      such file or directory
      <br>
    </blockquote>
    If you haven't already, before you do ANYTHING ELSE, take a
    file-system level copy of the PostgreSQL database while the server
    is stopped. See
    <meta http-equiv="content-type" content="text/html;
      charset=ISO-8859-1">
    <a href="http://wiki.postgresql.org/wiki/Corruption">http://wiki.postgresql.org/wiki/Corruption</a>
    .<br>
    <br>
    --<br>
    Craig Ringer<br>
  </body>
</html>

--------------090905060201020107050805--