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

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

 



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

-- 
fedora-devel-list mailing list
fedora-devel-list@xxxxxxxxxx
https://www.redhat.com/mailman/listinfo/fedora-devel-list

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Fedora Announce]     [Fedora Kernel]     [Fedora Testing]     [Fedora Formulas]     [Fedora PHP Devel]     [Kernel Development]     [Fedora Legacy]     [Fedora Maintainers]     [Fedora Desktop]     [PAM]     [Red Hat Development]     [Gimp]     [Yosemite News]
  Powered by Linux