Re: postgres 8.2 doesn't start after ubuntu upgrade

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

 



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.

--
Daniel J. Summers
*Owner, DJS Consulting* Support <http://support.djs-consulting.com/> • Tech Blog <http://www.djs-consulting.com/linux/blog>

daniel@xxxxxxxxxxxxxxxxxx <mailto:daniel@xxxxxxxxxxxxxxxxxx> • http://www.djs-consulting.com <http://www.djs-consulting.com/>

GEEKCODE 3.12 GCS/IT d s-:+ a C++ L++ E--- W++ N++ o? K- w !O M--
V PS+ PE++ Y? !PGP t+ 5? X+ R* tv b+ DI++ D+ G- e h---- r+++ y++++

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