From: ogjunk-pgjedan@yahoo.com
To: pgsql-admin@postgresql.org
Subject: Re: DB replicators comparison; (vs. DB upgrade via pg_dump)
Date: Sun, 15 May 2005 21:40:48 -0700 (PDT)
Message-ID: <20050516044048.21949.qmail@web31104.mail.mud.yahoo.com> (raw)
Hello,
Thanks for the explanation :) I thought there was some technical
limitation when dump/reload is used, and I just wasn't seeing it after
my dump/reload successfully got me from 7.3.4 to 8.0.3.
Still, DB replication sounds very useful, so I'd still be interested in
Slony-I, Daffodil, and Mammoth comparison, if anyone has used more than
one of them.
Thanks,
Otis
--- Christopher Browne <cbbrowne@acm.org> wrote:
> A long time ago, in a galaxy far, far away, ogjunk-pgjedan@yahoo.com
> wrote:
> > I am about to upgrade from 7.3.4 to 8.0.3, and I read that using a
> DB
> > replication tool is a good way to go about it.
>
> Replication is useful for this purpose if it helps you cut down on
> the
> time the transition takes.
>
> If the database is relatively small, and it only takes a few minutes
> to load the data in, then it's far simpler to do a dump/reload.
>
> But if you discover that the dump/reload takes 4 hours, and you're
> only permitted 20 minutes of downtime, the complexities of
> replication
> may get forced on you...
> --
> output = ("cbbrowne" "@" "ntlug.org")
> http://linuxdatabases.info/info/slony.html
> Sheridan:"So how did you find out all of this?"
> Bester:"I'm a telepath. Work it out." <*>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: ogjunk-pgjedan@yahoo.com
Subject: Re: DB replicators comparison; (vs. DB upgrade via pg_dump)
In-Reply-To: <20050516044048.21949.qmail@web31104.mail.mud.yahoo.com>
References: <20050516044048.21949.qmail@web31104.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox