Re: [OxLUG] Broken postgresql 7.4 by upgrade from lenny to s…

Top Page
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: Tim Pizey
To: Oxfordshire Linux User Group Discussion List
Subject: Re: [OxLUG] Broken postgresql 7.4 by upgrade from lenny to squeeze
On 30 March 2012 09:09, Dave Ewart wrote:
> On Thursday, 29.03.2012 at 23:55 +0100, Tim Pizey wrote:
>> My own fault, which I will pay for now in time I should have spent
>> thinking beforehand.
>> I went and did a dist-upgrade from lenny to squeeze, which has broken
>> postgresql-7.4,
>> which I should have upgraded when I did an upgrade from etch.
>> postgresql 8.4 refactored to postgresql-common and deleted postmaster
>> from postgresql-7.4
>> I am thinking of removing postgresql-8.4 and reinstalling
>> postgresql-7.4 from .deb.
>> Any idea if this might work?
>> How do I check?
>> (I will use --dry-run this time :)
> If you're planning on upgrading to PostgreSQL 8.4, then you'll need
> *both* installed simultaneously: the upgrade scripts do a 'dump and
> restore' on the wire, utilising both postmasters running on different
> ports.  During a normal upgrade this works quite happily if you read
> the docs to know what to expect.
> If you just want to carry on using PostgreSQL 7.4, then what you suggest
> should be OK.
> Dave.

thanks for your reply, my mate has successfully got 7.4 reinstalled,
so I can do a more planned upgrade to 8.4.

thanks again

Tim Pizey