Re: postgres 8.2 doesn't start after ubuntu upgrade

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

 



>> On Sat, Feb 28, 2009 at 7:54 PM, Daniel J. Summers
>> <daniel@xxxxxxxxxxxxxxxxxx> wrote:
>>>
>>> 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.
>>
>
> This sounds promising.  However, how do I start the cluster?  Here's what
> I did.  Remember that trying to start 8.2 doesn't do anything.
>
> $ /etc/init.d/postgresql-8.2 start
> $ pg_upgradecluster 8.2 main
> Error: specified cluster is not running
> $ ls /etc/postgresql/8.2
> main
> $
>
> Am I doing something wrong here?
>
> Bryan
>

After thinking about this a little more, I realize that the problem for me
is not that the upgrade didn't go well.  It's that I can't access my data
on 8.2.  If upgrading the cluster allows me to access the data, great.  If
I can access the data on 8,2, that'd be great, too, and then I can worry
about upgrading.  It looks to me like the data is still there:

$ du -shc /var/lib/postgresql/8.2/*
308M        /var/lib/postgresql/8.2/main
308M        total
$ du -shc /var/lib/postgresql/8.3/*
30M        /var/lib/postgresql/8.3/main
30M        total
$

How can I see it?  Why won't 8.2 start?  Note that I get no message at the
prompt when trying to start 8.2.

Bryan



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