> 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?
--
SRA OSS, Inc. Japan
Tatsuo Ishii