On Sun, May 20, 2007 at 07:44:38PM +1000, Pascal Hakim wrote: > On Sun, May 20, 2007 at 05:04:29AM -0400, Roberto C. Sánchez wrote: > > On Sun, May 20, 2007 at 06:56:45PM +1000, Pascal Hakim wrote: > > > > > > I realise the original poster uses MySQL, but if you want to keep a > > > postgresql DB in sync like that, a great way to do it is by using > > > PITR/WAL shipping[1]. This will work pretty well if what you're worried > > > about is hardware failure, and will let you set just how far behind you > > > want the slave to be. > > > > > Interesting. Is that a new feature in 8.2? > > > > It was added in 8.0: > http://www.postgresql.org/docs/8.0/static/backup-online.html > > As an added bonus, since you can replay stuff in advance, you can > restore in seconds rather than hours. > That is awesome. I will have to hurry up and get my servers upgraded to Etch.
Regards, -Roberto -- Roberto C. Sánchez http://people.connexer.com/~roberto http://www.connexer.com
signature.asc
Description: Digital signature
