Hello guys; Days ago I backup my postgres database using the PGAdmin program for windows; my postgres version is 8.1.
Now; when I try to restore the backup an error occur. ( BTW; I format my disk; so I can't backup gain :( ) After restore I check the postgres database and I found all table; functions; and others structures; also data in some tables but not in all. After some research I detect that I have some "bad blocks" in my backup file. Those blocks are in the DATA section of a large table; maybe in a range of 16K. So; when I run the pg_restore everything is restored until the damaged sector; all information after it is ignored. In the console appear "out of memory". Someones suggest to open the backup file and remove bad rows; but when I open in any text editor the data is not in a human readable way. So; maybe you know how can I remove all rows stored in damaged bytes in order to restore all others rows after it. Thanks!! Anibal ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
