Re: postgres 8.2 doesn't start after ubuntu upgrade

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>
> 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
>



-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux