Re: [HACKERS] Database replication... - Mission Critica - Mailing list pgsql-general

From Neil Conway
Subject Re: [HACKERS] Database replication... - Mission Critica
Date
Msg-id 873cqdh0w7.fsf@mailbox.samurai.com
Whole thread Raw
In response to Re: [HACKERS] Database replication... - Mission Critica  ("Mikheev, Vadim" <VMIKHEEV@sectordata.com>)
Responses Re: [HACKERS] Database replication... - Mission Critica  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-general
"Mikheev, Vadim" <VMIKHEEV@sectordata.com> writes:
> > My presumption would be that if you initialize 2 databases to
> > a known identical start, have all the same triggers and rules
> > on both, then send all queries to both databases, you will
> > have 2 identical databases at the end.
>
> This is wrong assumption.

Agreed. Another simple example is:

INSERT INTO foo VALUES (random());

Cheers,

Neil

--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC

pgsql-general by date:

Previous
From: Oskar Berggren
Date:
Subject: Re: Q!
Next
From: Tom Lane
Date:
Subject: Re: [SQL] Problem: Referential Integrity Constraints lost