Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 281596333AC for ; Sat, 28 Feb 2009 23:56:57 -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 28119-03 for ; Sat, 28 Feb 2009 23:56:47 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gx0-f176.google.com (mail-gx0-f176.google.com [209.85.217.176]) by mail.postgresql.org (Postfix) with ESMTP id B03B3632907 for ; Sat, 28 Feb 2009 23:56:45 -0400 (AST) Received: by gxk24 with SMTP id 24so4486862gxk.19 for ; Sat, 28 Feb 2009 19:56:43 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=a8Y4RaMgNTwwZm1MsaA0um88iqQ6TzTEwL7Nahl9Lgo=; b=uECYx9UsGS7gMZcrU/2TaG8B8tXlhSFjTHGnY5boF+Go3WUhfmQqCbaASMH/uhpCGJ FENNArNkAiWKZmsjxz5d1ojGnWzhq4cZqpkTBcoRiqpIExS/3z5ECBGNwfrYnbjv3cHJ aV8CmTZTHzUVdybmQee4e9zqS0J3vysZgOaS8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=lnOuAGb4lMEHRM4vFs8RgRhjyZBDDGACslxLLaA1LDzxDbSXQiQy+IPQO3NNCCezk5 KZqGehfvIAn+GAJSZdk4rmsFCVAbxGzpQUhNKReu1GeadKKph1bjRNAoCEN5X3u5c5R5 wBiaYAr2KVjtPDm1mCSGAVRZImaB5FaZVtLzc= MIME-Version: 1.0 Received: by 10.150.52.10 with SMTP id z10mr7400400ybz.182.1235879803616; Sat, 28 Feb 2009 19:56:43 -0800 (PST) In-Reply-To: <49A9F8DC.2080309@djs-consulting.com> References: <1386.71.208.251.23.1235868684.squirrel@ideotrope.org> <49A9F8DC.2080309@djs-consulting.com> Date: Sat, 28 Feb 2009 20:56:43 -0700 Message-ID: Subject: Re: postgres 8.2 doesn't start after ubuntu upgrade From: Scott Marlowe To: "Daniel J. Summers" Cc: pgsql-admin@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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/279 X-Sequence-Number: 31500 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. You're absolutely right. FYI, pg has a different numbering system where the first two digits are pretty much both major numbers. 8.4 and 8.3 are two distinct major versions, and are not binary on disc compatible etc. That means that 8.2 and 8.1 were as different as 8.0 and 7.4 in terms of things like file formatting and catalogues And pg_upgradescluster is a great little bit of code. I wish RedHat had such things. (If they do someone please tell me.)