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

Re: PostgreSQL mgmt on Fedora: pg_cluster-like tools?



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

Attachment: signature.asc
Description: This is a digitally signed message part


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