On Sat, Sep 13, 2008 at 12:07 AM, Tom Lane <tgl@xxxxxxxxxx> wrote:
>> Having been once the maintainer of the Pg compat layer in Moodle, I
>> also have first-hand experience with this. When the casts removal was
>> mentioned in pg-devel, who was there asking about backwards compat?
>
> If you need 100% backwards compatibility, you keep using 8.2
Perhaps wasn't clear - I wasn't complaining at all, just pointing out
to Devrim that I am aware and active in tracking compat issues.
> Anyway, Devrim is quite right that mere installation of an RPM cannot
> execute any sort of database conversion. The functionality would need
> to be invoked sometime else. That doesn't mean it has to be manual
> though. Could we put it in the start script, invoked by something like
> "service postgresql upgrade"?
I completely agree.
> Exactly what does a conversion look like
> in Debian's packaging, anyway?
* apt-get install postgresql-8.2
* pg_dropcluster –stop 8.2 main
* pg_upgradecluster -v 8.2 8.1 main /var/lib/postgresql/8.2/main
and if it works well, pg_dropcluster 8.1 main will delete the data dir
of the old one.
also see http://www.digipedia.pl/man/pg_upgradecluster.8.html
cheers,
m
--
martin.langhoff@xxxxxxxxx
martin@xxxxxxxxxx -- School Server Architect
- ask interesting questions
- don't get distracted with shiny stuff - working code first
- http://wiki.laptop.org/go/User:Martinlanghoff
--
fedora-devel-list mailing list
fedora-devel-list@xxxxxxxxxx
https://www.redhat.com/mailman/listinfo/fedora-devel-list
