I would like to know whether I can set DBmirror replication from the fedora core
5_64 which postgresql8.1 was installed by rpm process not by compiling the
source. All of the component include server, contrib, perl, test, doc, devel
and lib were also rpm and what is the way to set it?
Do I need to
Just to add - the replacement for DBMirror.pl automatically works out
the schema in use and will replicate using DBmirror from 7.x or from
8.x (table names all changed!). This is done transparently.
I also wrote a short article at
http://www.whitebeam.org/library/guide/TechNotes/replicate.rhtm
Not sure whether this is any use to anyone, or whether this is the right
list to post to but...
I've just released a C++ implementation of the DBMirror.pl script as
part of Whitebeam (http://www.whitebeam.org). We had *real* performance
issues with the Perl implementation replicating large fiel
sday, May 13, 2004 4:10 PM
Subject: Re: [GENERAL] dbmirror
> Does dbmirror do that? No, it does not. It also doesn't support
> promoting a slave database to a master; that has to be done manually, so
> I wouldn't consider that too big a problem.
>
> Worse in my opinion is th
Does dbmirror do that? No, it does not. It also doesn't support
promoting a slave database to a master; that has to be done manually, so
I wouldn't consider that too big a problem.
Worse in my opinion is that sequences don't get updated... so a slave
that tries to do an insert on a replicated t
On Wed, May 12, 2004 at 05:53:05PM -0700, Gregory S. Williamson wrote:
> Fred --
>
> Yes, the slave database(s) can be safely used in a R/O mode,
Does it also block write transactions in those slaves? The ability
for clients to write into the slave replicated tables is a problem,
because it ma
