"Simon Riggs" <simon@xxxxxxxxxxxxxxx> writes: >> From: Tatsuo Ishii [mailto:t-ishii@xxxxxxxxx] >> I thought there are some issues of log based replication (I don't >> remeber details though). Have they been resolved recently? > Yes, currently log-file based replication is not recommended when the > transaction rate is either low or extremely variable. The point being not that it doesn't work, but that it can take a long time (or an unpredictable amount of time) for transactions to propagate to the slave machine. You can kluge up a solution for this, ie, write a cron job to copy the latest WAL segment file across to the slave once a minute (or whatever your requirement for propagation delay is). But we haven't gotten a standard solution into the code itself yet. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
