tag:blogger.com,1999:blog-7476449567742726187.post2345435351380999328..comments2023-12-18T12:25:52.296-08:00Comments on Database Soup: De-corrupting TOAST TablesJosh Berkushttp://www.blogger.com/profile/09671139717468724246noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-7476449567742726187.post-87704639524978663422018-05-03T06:14:17.173-07:002018-05-03T06:14:17.173-07:00As a note on this, zero damaged pages deletes all ...As a note on this, zero damaged pages deletes all information on a page when that page is damaged (i.e. database rows cannot be read out of it because of actual corruption errors on the page level).<br /><br />Here there are no problems on the page level. The problems are with missing rows in TOAST. To the pages are intact. But rows are missing. So page-level corrections would not be applied. And if they were they'd lose way more info than the approach discussed here.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-37700142626617822592017-01-31T07:14:05.496-08:002017-01-31T07:14:05.496-08:00It's not sufficient, no.It's not sufficient, no.Josh Berkushttps://www.blogger.com/profile/09671139717468724246noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-23444097490157144952017-01-30T12:26:40.467-08:002017-01-30T12:26:40.467-08:00Josh, would it be possible to eliminate the corrup...Josh, would it be possible to eliminate the corruption (understood, there is data loss) with zero_damaged_pages=on and vacuuming the table? Instead of rebuilding the table with pg_repack. Thanks!Steve Kehlethttps://www.blogger.com/profile/07568850497983767709noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-82995599581100552412016-07-09T13:15:30.918-07:002016-07-09T13:15:30.918-07:00On the psql command line, like a query.
DO script...On the psql command line, like a query.<br /><br />DO scripts are a way of running a one-time stored procedure.Josh Berkushttps://www.blogger.com/profile/09671139717468724246noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-67149754957425459362016-07-08T15:39:18.666-07:002016-07-08T15:39:18.666-07:00How do i do to run that 'do' script? Im ve...How do i do to run that 'do' script? Im very new at this...Chitãohttps://www.blogger.com/profile/15690212645125068404noreply@blogger.com