Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 5EA846334B4 for ; Mon, 2 Mar 2009 12:43:04 -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 47527-03 for ; Mon, 2 Mar 2009 12:43:00 -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 74FA463317F for ; Mon, 2 Mar 2009 12:43:00 -0400 (AST) Received: from ideotrope.org (localhost [127.0.0.1]) by mail.ideotrope.org (Postfix) with ESMTP id B4A9C33D13; Mon, 2 Mar 2009 08:42:56 -0800 (PST) Received: from 64.78.232.178 (SquirrelMail authenticated user bryan) by ideotrope.org with HTTP; Mon, 2 Mar 2009 09:42:56 -0700 (MST) Message-ID: <1203.64.78.232.178.1236012176.squirrel@ideotrope.org> In-Reply-To: <49AB94A9.1060907@bluegap.ch> References: <1386.71.208.251.23.1235868684.squirrel@ideotrope.org> <49A9F8DC.2080309@djs-consulting.com> <1237.71.208.251.23.1235882478.squirrel@ideotrope.org> <1168.71.208.251.23.1235918386.squirrel@ideotrope.org> <49AB05D4.8060309@bluegap.ch> <1248.71.208.251.23.1235955413.squirrel@ideotrope.org> <49AB94A9.1060907@bluegap.ch> Date: Mon, 2 Mar 2009 09:42:56 -0700 (MST) Subject: Re: postgres 8.2 doesn't start after ubuntu upgrade From: "Bryan Keith" To: "Markus Wanner" Cc: pgsql-admin@postgresql.org, "Scott Marlowe" , "Daniel J. Summers" 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/17 X-Sequence-Number: 31517 >> How do I install postgres 8.2? I think I installed 8.2 with something >> like sudo apt-get install postgresql, but that will install 8.3 now, I >> think. > > Try: sudo apt-get install postgresql-8.2 > > I'm not sure about Ubuntu. Probably 8.2 isn't included in Intrepid > anymore. (packages.ubuntu.com is currently not responding) (Why don't > you stay at a LTS ubuntu version for a database server?) > > If that's the case, try adding the Hardy Heron repository back to > /etc/apt/sources.list. If postgres-8.2 isn't available on Intrepid Ibex, > it then falls back to that from Hardy Heron. It looks to me like postgresql-8.2 is still available in the hardy repositories: http://packages.ubuntu.com/hardy/misc/postgresql-8.2 but I can't figure out what lines to add to /etc/apt/sources.list to find the repository. I keep getting this error: $ sudo apt-get install postgresql-8.2 Reading package lists... Done Building dependency tree Reading state information... Done Package postgresql-8.2 is not available, but is referred to by another package. This may mean that the package is missing, has been obsoleted, or is only available from another source E: Package postgresql-8.2 has no installation candidate $ I even put the entire old (from hardy) file into sources.list, but that didn't work. sources.list looked like this at that point: deb http://us.archive.ubuntu.com/ubuntu/ hardy main restricted deb-src http://us.archive.ubuntu.com/ubuntu/ hardy main restricted deb http://us.archive.ubuntu.com/ubuntu/ hardy-updates main restricted deb-src http://us.archive.ubuntu.com/ubuntu/ hardy-updates main restricted deb http://us.archive.ubuntu.com/ubuntu/ hardy universe deb-src http://us.archive.ubuntu.com/ubuntu/ hardy universe deb http://us.archive.ubuntu.com/ubuntu/ hardy-updates universe deb-src http://us.archive.ubuntu.com/ubuntu/ hardy-updates universe deb http://us.archive.ubuntu.com/ubuntu/ hardy multiverse deb-src http://us.archive.ubuntu.com/ubuntu/ hardy multiverse deb http://us.archive.ubuntu.com/ubuntu/ hardy-updates multiverse deb-src http://us.archive.ubuntu.com/ubuntu/ hardy-updates multiverse deb http://security.ubuntu.com/ubuntu hardy-security main restricted deb-src http://security.ubuntu.com/ubuntu hardy-security main restricted deb http://security.ubuntu.com/ubuntu hardy-security universe deb-src http://security.ubuntu.com/ubuntu hardy-security universe deb http://security.ubuntu.com/ubuntu hardy-security multiverse Same error. Any suggestions? Bryan