> From: Tatsuo Ishii [mailto:t-ishii@xxxxxxxxx] > > You can use PITR to archive transaction logs to a second > server that is > > kept in standby mode. > > > > This will cope with any number of tables and cope with > dynamic changes > > to tables. > > > > This is fairly straightforward and very low overhead. > > Set archive_command to a program that transfers xlog files to second > > server. > > Then set restore_command on the second server to a program > that loops > > until the next file is available. > > Switchover time is low. > > 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. I was regrettably unable to get a patch for that into 8.1 Best Regards, Simon Riggs ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
