[Server-devel] PostgreSQL mgmt on Fedora: pg_cluster-like tools?

[Martin Langhoff]

On Sat, Sep 13, 2008 at 12:07 AM, Tom Lane <tgl at redhat.com> 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 at gmail.com
 martin at laptop.org -- School Server Architect
 - ask interesting questions
 - don't get distracted with shiny stuff - working code first
 - http://wiki.laptop.org/go/User:Martinlanghoff