Обсуждение: replica question

Поиск
Список
Период
Сортировка

replica question

От
Feite Brekeveld
Дата:
Hi,

I have the following situation


Machine - A equiped with
    -  a database
    - Internet application that receives records and stores them into a
table on this machine

Machine - B equiped with
    -  the same database
    -  the same internet application but it only receives records when
machine A is down


What I would like to achieve is that the tables in both databases are
kept consistent.

How to do this with postgres ?

Do a write a C-program for that that is started by a trigger ?


Thanks,


Feite Brekeveld


Re: replica question

От
Bruce Momjian
Дата:
7.1 will have /contrib/rserv, which does this and more.

> Hi,
>
> I have the following situation
>
>
> Machine - A equiped with
>     -  a database
>     - Internet application that receives records and stores them into a
> table on this machine
>
> Machine - B equiped with
>     -  the same database
>     -  the same internet application but it only receives records when
> machine A is down
>
>
> What I would like to achieve is that the tables in both databases are
> kept consistent.
>
> How to do this with postgres ?
>
> Do a write a C-program for that that is started by a trigger ?
>
>
> Thanks,
>
>
> Feite Brekeveld
>
>


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026