Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 67A3A633525 for ; Sun, 1 Mar 2009 00:41:22 -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 71676-06-5 for ; Sun, 1 Mar 2009 00:41:19 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.ideotrope.org (ideotrope.org [209.237.247.148]) by mail.postgresql.org (Postfix) with ESMTP id 2BD446328AF for ; Sun, 1 Mar 2009 00:41:18 -0400 (AST) Received: from ideotrope.org (localhost [127.0.0.1]) by mail.ideotrope.org (Postfix) with ESMTP id 092DE33D13; Sat, 28 Feb 2009 20:41:18 -0800 (PST) Received: from 71.208.251.23 (SquirrelMail authenticated user bryan) by ideotrope.org with HTTP; Sat, 28 Feb 2009 21:41:18 -0700 (MST) Message-ID: <1237.71.208.251.23.1235882478.squirrel@ideotrope.org> In-Reply-To: References: <1386.71.208.251.23.1235868684.squirrel@ideotrope.org> <49A9F8DC.2080309@djs-consulting.com> Date: Sat, 28 Feb 2009 21:41:18 -0700 (MST) Subject: Re: postgres 8.2 doesn't start after ubuntu upgrade From: "Bryan Keith" To: "Scott Marlowe" Cc: "Daniel J. Summers" , pgsql-admin@postgresql.org User-Agent: SquirrelMail/1.4.9a MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal 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: 200903/1 X-Sequence-Number: 31501 > On Sat, Feb 28, 2009 at 7:54 PM, Daniel J. Summers > wrote: >> 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. > This sounds promising. However, how do I start the cluster? Here's what I did. Remember that trying to start 8.2 doesn't do anything. $ /etc/init.d/postgresql-8.2 start $ pg_upgradecluster 8.2 main Error: specified cluster is not running $ ls /etc/postgresql/8.2 main $ Am I doing something wrong here? Bryan