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

[Devrim GÜNDÜZ]

On Fri, 2008-09-12 at 11:59 +1200, Martin Langhoff wrote:
>  - Major Pg upgrades will have to run 100% unattended, with a sane
> failover, so: install the new version of Pg, attempt a
> pg_dump|pg_restore data migration and only switch over if it was
> successful.

I am *very* against this one. It is not packager's job to run
dump/reload:

* You may never be sure that it will work. We had this issue in 8.3 for
example.

* Upstream never ever gives such a guarantee that all apps will work on
every PostgreSQL version. For example, some casts were removed in 8.3.
So dumping/restoring should be a DBA work. So "switch over if it was
successful" is really a bad idea, and *will* break things.

* RPMs are *not* allowed to do interactive job, per guidelines. Period.

Regards,
-- 
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
                   http://www.gunduz.org
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part
Url : http://lists.laptop.org/pipermail/server-devel/attachments/20080912/19df0b67/attachment.pgp