Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1758D2E3BA3 for ; Tue, 22 Jan 2008 13:33:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 31143-01-3 for ; Tue, 22 Jan 2008 13:33:16 -0400 (AST) Received: from ipmail01.adl6.internode.on.net (ipmail01.adl6.internode.on.net [203.16.214.146]) by postgresql.org (Postfix) with ESMTP id 5A80F2E3D63 for ; Tue, 22 Jan 2008 13:24:24 -0400 (AST) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: Ah4FAOmzlUfLevdH/2dsb2JhbAAsgSurIg X-IronPort-AV: E=Sophos;i="4.25,234,1199626200"; d="scan'208";a="27189596" Received: from ppp247-71.static.internode.on.net (HELO DevBox.local) ([203.122.247.71]) by ipmail01.adl6.internode.on.net with ESMTP; 23 Jan 2008 03:54:19 +1030 Message-ID: <479626C1.3060803@Sheeky.Biz> Date: Wed, 23 Jan 2008 03:54:17 +1030 From: Shane Ambler User-Agent: Thunderbird 2.0.0.6 (Macintosh/20070728) MIME-Version: 1.0 To: Mark Steben CC: pgsql-admin@postgresql.org Subject: Re: no entry on pg_database for a live database References: <000101c85d10$8bab2c10$14010a0a@dei26g028575> In-Reply-To: <000101c85d10$8bab2c10$14010a0a@dei26g028575> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/224 X-Sequence-Number: 27998 Mark Steben wrote: > > I'm running version 7.4.5. Do I have to do a drop-recreate or is there > > Some other way around this? > > There has been mention that some of the old versions of 7.x had data critical issues that are fixed in newer updates. My first suggestion would be to try it with 7.4.19 (using a copy of your data files of course) As well as planning an upgrade to 8.1 or 8.2 -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz