Does no one consider this to be a problem? You kinda wonder about PostgreSQL being used as serious commercial database then don't you?
Me again. "Andy Marden" <[EMAIL PROTECTED]> wrote in message news:a3dpjt$1l1s$[EMAIL PROTECTED]... > Putting together a system at the moment with a combination of batch loads > and user online modification of data, with PostgreSQL version 7.1.3. I'm > looking at recovery aspects at the moment. All I can see is pg_dump and > pg_restore at the moment, which is fine for batch loads once a day, but if > the database crashes halfway through the day then user modifications will be > lost. > > Is there the equivalent of Oracle's archived redo logs in PostgreSQL and > commands to allow recovery up to the last (or any) point in time. I've seen > pg_xlog files mentioned. > > The recovery section of the manuals is 'under construction' it seems. > > Thanks for your help. > > Cheers > > Andy Marden > > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html