| From: | Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info> |
|---|---|
| To: | Dawid Kuroczko <qnex42(at)gmail(dot)com> |
| Cc: | Csaba Nagy <nagy(at)ecircle-ag(dot)com>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Perceived weaknesses of postgres |
| Date: | 2008-02-13 13:40:00 |
| Message-ID: | 47B2F330.4060404@ca.afilias.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Dawid Kuroczko wrote:
> Slony is good as long as there are no DDLs issued. And its easy to
> shoot oneself in the foot if one is not careful (some time ago I have
> lost all the triggers while upgrading from 8.1 to 8.2; it was my fault
> since I did pg_dump -s on a slave database, not on the master...).
>
>
It can also be a very time consuming process. It often also involves
having to juggle resources around, find extra disk space floating around
somewhere to build extra replicas, or abandon your fail over target for
a period of time while upgrade that.
BTW, the trigger issue goes away with 8.3 and Slony 2.0.
Brad.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2008-02-13 13:45:32 | Re: Storing images as BYTEA or large objects |
| Previous Message | Csaba Nagy | 2008-02-13 13:11:56 | Re: Perceived weaknesses of postgres |