> From: Tatsuo Ishii [mailto:t-ishii@sra.co.jp]
> > 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