From: | Geoffrey <lists(at)serioustechnology(dot)com> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
Cc: | Alan Hodgson <ahodgson(at)simkin(dot)ca>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: In the belly of the beast (MySQLCon) |
Date: | 2008-04-18 18:30:18 |
Message-ID: | 4808E8BA.1060709@serioustechnology.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-general |
Joshua D. Drake wrote:
> On Fri, 18 Apr 2008 13:54:52 -0400
> Geoffrey <lists(at)serioustechnology(dot)com> wrote:
>
>> What about the:
>>
>> 8.1 -> slony -> 8.3
>> switch users to 8.3 databases
>>
>> solution.
>
> Is it? What is your transactional velocity? How long will the initial
> sync transaction have to run? You know vacuum isn't working while
> that transaction is open right? Are you going to have to setup up a
> dozen different replicated sets in order to get it done?
>
> Slony works in "some" cases it does not work in all nor the most
> critical (in terms of large sets with minimal downtime requirement).
I don't know that slony is the answer. It was more of a question then
an answer. We are hoping to use that solution to migrate from 7.4.19 to
8.3.1. The primary reason is to reduce downtime.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
From | Date | Subject | |
---|---|---|---|
Next Message | Brad Nicholson | 2008-04-18 18:30:58 | Re: Joshua Drake's "What MySQL Can Learn From PostgreSQL" talk at MySQL Con 2008 |
Previous Message | Andrew Sullivan | 2008-04-18 18:16:28 | Re: Joshua Drake's "What MySQL Can Learn From PostgreSQL" talk at MySQL Con 2008 |
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Boddie | 2008-04-18 18:33:48 | Re: Which Python library - psycopg2 or pygresql? |
Previous Message | Rodrigo Gonzalez | 2008-04-18 18:30:17 | Re: Upgrade 8.3 |