Re: [HACKERS] Database replication... - Mission Critica

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: [HACKERS] Database replication... - Mission Critica
Дата
Msg-id 873cqdh0w7.fsf@mailbox.samurai.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Database replication... - Mission Critica  ("Mikheev, Vadim" <VMIKHEEV@sectordata.com>)
Ответы Re: [HACKERS] Database replication... - Mission Critica  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Список 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 по дате отправления:

Предыдущее
От: Oskar Berggren
Дата:
Сообщение: Re: Q!
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] Problem: Referential Integrity Constraints lost