Carlos Henrique Reimer wrote:
I read some documents about replication and realized that if you plan
on using asynchronous replication, your application should be designed
from the outset with that in mind because asynchronous replication is
not something that can be easily “added on” after the fact.
Am I right?
Depending on your needs, you may find pgpool and Slony to be a workable
combination. This is better when you have a lot of reads and only
occasional writes. This way writes get redirected back to the master,
and read-only transactions get run on the slaves.
Best Wishes,
Chris Travers
Metatron Technology Consulting
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
