You could use slony for this a couple of ways. One is a simpler more
hacky way, another is a bit more involved but perhaps more "correct":
For the simple way, setup the source database as a provider and the
remote replica as a normal slony subscriber.Don't run the slon
daemons all the t
I searched the web sites for advice but came up short on something
that looked like what I need. I need to "replicate" a few tables
nightly (2am-6am). Each table will have about 1 million new records
(~100B each, ~5/second) each day.
I have tried using something like a cron job (copy from/copy to
