On 12/26/05, Martijn van Oosterhout <kleptog@xxxxxxxxx> wrote: > On Mon, Dec 26, 2005 at 03:21:03PM -0500, Jaime Casanova wrote: > > Hi, can someone point me where is explained how can i recover from a > > wraparound that vanish all databases in a cluster? > > Some recent investigation indicates that simply doing a VACUUM on the > databases in question should bring the data back, as long as it hasn't > been too long the wraparound. > > However, to be more specific you'll need to provide info as to which > version of PostgreSQL and what your VACUUM setup so far has been. > yes, it seems that's enough... i was trying to help to a buddy in the spanish list and my first recommendation was to copy all data directory... when he tries that he makes a vacuum and the data go back... i told him to review their data to be sure... > Have a nice day, > -- > Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > > tool for doing 5% of the work and then sitting around waiting for someone > > else to do the other 95% so you can sue them. > > > -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;)
