Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 5DC66633DDC for ; Sun, 1 Mar 2009 20:56:58 -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 55772-09 for ; Sun, 1 Mar 2009 20:56:55 -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 5FCAF632D14 for ; Sun, 1 Mar 2009 20:56:55 -0400 (AST) Received: from ideotrope.org (localhost [127.0.0.1]) by mail.ideotrope.org (Postfix) with ESMTP id 3D8FD33D13; Sun, 1 Mar 2009 16:56:53 -0800 (PST) Received: from 71.208.251.23 (SquirrelMail authenticated user bryan) by ideotrope.org with HTTP; Sun, 1 Mar 2009 17:56:53 -0700 (MST) Message-ID: <1248.71.208.251.23.1235955413.squirrel@ideotrope.org> In-Reply-To: <49AB05D4.8060309@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> Date: Sun, 1 Mar 2009 17:56:53 -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/8 X-Sequence-Number: 31508 > > Is the package postgresql-8.2 still installed? I don't know. Maybe not. How can I tell? > Or did the Ubuntu upgrade > automatically deinstall that? What does the log in > /var/log/postgresql/8.2/... say? The last lines of the latest non-empty 8.2 log file are: $ sudo tail -n 15 /var/log/postgresql/postgresql-8.2-main.log.1 2009-02-24 14:01:51 MST LOG: shutting down 2009-02-24 14:01:51 MST LOG: database system is shut down 2009-02-24 14:01:52 MST LOG: could not load root certificate file "root.crt": no SSL error reported 2009-02-24 14:01:52 MST DETAIL: Will not verify client certificates. 2009-02-24 14:01:52 MST LOG: database system was shut down at 2009-02-24 14:01:51 MST 2009-02-24 14:01:52 MST LOG: checkpoint record is at 0/3222C388 2009-02-24 14:01:52 MST LOG: redo record is at 0/3222C388; undo record is at 0/0; shutdown TRUE 2009-02-24 14:01:52 MST LOG: next transaction ID: 0/2559565; next OID: 29907 2009-02-24 14:01:52 MST LOG: next MultiXactId: 1; next MultiXactOffset: 0 2009-02-24 14:01:52 MST LOG: database system is ready 2009-02-24 14:01:52 MST LOG: incomplete startup packet 2009-02-24 14:35:59 MST LOG: incomplete startup packet 2009-02-24 14:35:59 MST LOG: received fast shutdown request 2009-02-24 14:35:59 MST LOG: shutting down 2009-02-24 14:35:59 MST LOG: database system is shut down $ The last entries in the log file are from the day of the upgrade. So I'm guessing postgres 8.2 isn't installed. I guess now the questions are: How can I install postgres 8.2 without messing up the data in /var/lib/postgresql/8.2/main? Can I just copy that to a new location and copy it back after the installation? Or...? 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. Thank you everyone for the help. Bryan > > Regards > > Markus Wanner >