see contrib/dbmirror ... triggered by updates on the primary. Don't know if it would work for you ... not sure about
thesecond part (see the differences). It uses a table it creates called "Pending" to store transactions.
Greg W.
-----Original Message-----
From: Alex [mailto:alex@meerkatsoft.com]
Sent: Thu 8/28/2003 8:49 PM
To: pgsql-general@postgresql.org
Cc:
Subject: [GENERAL] Fast Table Replication / Mirroring
Hi,
I saw some replication projects but think this might be an overkill for
my intentions.
I have two databases, Primary / Secondary where the Secondary is
readyonly for
users. I need to mirror tables when changes occur on that table. That
may happen a few times a day.
Tables are in the area of few 100k records.
A) Is there an easy way to copy the data from Primary to Secondary
Can this be triggered by updates on the primary table ?
B) Is there a fast way to check if table A on Primary and Secondary
server are in Sync?
Not number of records but contents.
Any advise would be appreciated.
Alex
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly