Re: Help on WAL needed!

Namrata writes:

> I want to know about the WAL. How it is used in postgreSQL and how it is implemented and how data is recovered using
WAL?

-> Administrator's Guide

> Is there any provision for fault tolerance provided in postgreSQL?

If you mean "hardware fault": not really.

> Is there any versioning of data provided in postgreSQL when we alter the table contentes ( say If I add new column to
thetable and after some time if 
> I don't want new column. I want my previous table contents. Can I get it using the versioning of the data? )

"Time travel" was removed several years ago, and I don't think it ever
covered schema changes.  You can do this with triggers, there should be an
example somewhere in contrib, IIRC.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter