Simon Riggs wrote:
Barry, 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.
Apologies for going slighly off topic, but isn't this basically how MySQL does replication? I ask because one of the arguments against moving to PostgreSQL in my organisation is 'no replication out of the box'. But if the above is true it seems that all that is required are a couple of scripts to handle log transfer and you have a form of replication out of the box right there.
Or am I missing something? -- Russ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
