Re: replica question

Started by Bruce Momjianabout 25 years ago1 messagesgeneral
Jump to latest
#1Bruce Momjian
bruce@momjian.us

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