Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id A0A16633C8A for ; Sat, 28 Feb 2009 22:54:29 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 60413-06 for ; Sat, 28 Feb 2009 22:54:25 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sabrina.lunarpages.com (sabrina.lunarpages.com [74.50.28.195]) by mail.postgresql.org (Postfix) with ESMTP id E3278633525 for ; Sat, 28 Feb 2009 22:54:25 -0400 (AST) Received: from c-76-113-62-16.hsd1.nm.comcast.net ([76.113.62.16] helo=[192.168.0.101]) by sabrina.lunarpages.com with esmtpa (Exim 4.69) (envelope-from ) id 1Ldbos-0005wG-4Z for pgsql-admin@postgresql.org; Sat, 28 Feb 2009 18:54:22 -0800 Message-ID: <49A9F8DC.2080309@djs-consulting.com> Date: Sat, 28 Feb 2009 19:54:20 -0700 From: "Daniel J. Summers" Organization: DJS Consulting User-Agent: Thunderbird 2.0.0.19 (X11/20090105) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: postgres 8.2 doesn't start after ubuntu upgrade References: <1386.71.208.251.23.1235868684.squirrel@ideotrope.org> In-Reply-To: <1386.71.208.251.23.1235868684.squirrel@ideotrope.org> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - sabrina.lunarpages.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - djs-consulting.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200902/278 X-Sequence-Number: 31499 Bryan Keith wrote: > I can run 8.3 and see the dbs (the default ones only; not mine) with psql. > I ran into this on an upgrade - however, I didn't do what I'm about to describe, and I lost all my data. Luckily, it wasn't the only place where it was, but there was some development stuff that I had to reaccomplish. Once I had lost it, I discovered the command below... The command you're looking for is pg_upgradecluster. There's a description of it at http://manpages.ubuntu.com/manpages/hardy/man8/pg_upgradecluster.8.html . I believe the only time you'll need this is if you change the major or minor version - for 8.3.5 to 8.3.6, for example, I believe there's no upgrade required. -- Daniel J. Summers *Owner, DJS Consulting* Support • Tech Blog daniel@djs-consulting.com • http://www.djs-consulting.com GEEKCODE 3.12 GCS/IT d s-:+ a C++ L++ E--- W++ N++ o? K- w !O M-- V PS+ PE++ Y? !PGP t+ 5? X+ R* tv b+ DI++ D+ G- e h---- r+++ y++++