From: Bryan Keith <bryan@ideotrope.org>
To: Markus Wanner <markus@bluegap.ch>
Cc: pgsql-admin@postgresql.org, "Scott Marlowe" <scott.marlowe@gmail.com>
Cc: Daniel J. Summers <daniel@djs-consulting.com>
Subject: Re: postgres 8.2 doesn't start after ubuntu upgrade
Date: Sun, 1 Mar 2009 17:56:53 -0700 (MST)
Message-ID: <1248.71.208.251.23.1235955413.squirrel@ideotrope.org> (raw)
In-Reply-To: <49AB05D4.8060309@bluegap.ch>
References: <1386.71.208.251.23.1235868684.squirrel@ideotrope.org>
<49A9F8DC.2080309@djs-consulting.com>
<dcc563d10902281956s74a74c39k2d8c309d416544d7@mail.gmail.com>
<1237.71.208.251.23.1235882478.squirrel@ideotrope.org>
<1168.71.208.251.23.1235918386.squirrel@ideotrope.org>
<49AB05D4.8060309@bluegap.ch>
>
> 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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bryan@ideotrope.org, markus@bluegap.ch, scott.marlowe@gmail.com, daniel@djs-consulting.com
Subject: Re: postgres 8.2 doesn't start after ubuntu upgrade
In-Reply-To: <1248.71.208.251.23.1235955413.squirrel@ideotrope.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox