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 jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
