Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TammH-0003Mq-3A for pgsql-admin@postgresql.org; Tue, 20 Nov 2012 12:18:09 +0000 Received: from news.hub.org ([200.46.204.72]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tamm8-0006es-Vr for pgsql-admin@postgresql.org; Tue, 20 Nov 2012 12:18:08 +0000 Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.5/8.14.5) with ESMTP id qAKCHxHt009812 for ; Tue, 20 Nov 2012 08:17:59 -0400 (AST) (envelope-from news@news.hub.org) Received: from news.hub.org (news@localhost) by news.hub.org (8.14.5/8.14.5/Submit) with NNTP id qAKBpqeo000699 for pgsql-admin@postgresql.org; Tue, 20 Nov 2012 07:51:52 -0400 (AST) (envelope-from news) From: Pat Heuvel X-Newsgroups: pgsql.admin Subject: Re: No databases visible on pg 8.3 server Date: Tue, 20 Nov 2012 22:50:28 +1100 Organization: Hub.Org Networking Services Message-ID: <50AB6E84.9080204@tpg.com.au> References: <509F7ACB.9040103@2ndQuadrant.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit User-Agent: Mozilla/5.0 (Windows NT 6.0; rv:16.0) Gecko/20121026 Thunderbird/16.0.2 In-Reply-To: <509F7ACB.9040103@2ndQuadrant.com> To: pgsql-admin@postgresql.org X-Pg-Spam-Score: -2.3 (--) X-Archive-Number: 201211/109 X-Sequence-Number: 40354 Thanks Craig, I've already done that. On 11/11/2012 9:15 PM, Craig Ringer wrote: > 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