The only way to get 0% data loss is some form of syncronous replication, which is rather difficult to implement, especially across a WAN.
There is pgCluster and pgpool, both of which do syncronous replication, but it's also statement based which has some serious rammifications. On Wed, Dec 14, 2005 at 12:11:07PM -0400, Ing. Jhon Carrillo // Caracas, Venezuela wrote: > Hi all, > > I need to use PITR for to do backup in a critical enviroment, but this > configuration save the segment files in the backup directory only when the > segment file (in pg_xlog) is full, ?Is there any way to configure the WAL > like a real online backup? > > > In my enviroment is necesary the 0% data lost, any idea?. > > regards, > > -- > Jhon Carrillo > IT Senior Engineer > Caracas-Venezuela -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
