I saw some replication projects but think this might be an overkill for
I have two databases, Primary / Secondary where the Secondary is
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.
pgsql-general by date
|Next:||From: Matthew T. O'Connor||Date: 2003-08-29 03:58:46|
|Subject: Re: Vacuuming and already vacuumed table?|
|Previous:||From: Joe Conway||Date: 2003-08-29 03:40:43|
|Subject: Re: Arrays and Indices / Foreign Keys|