Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 122828

Data corruption refers to errors in computer data that occur during writing, reading, storage, transmission, or processing, which introduce unintended changes to the original data

2
votes
If you have initialized your cluster with checksum, you can control this while backuping with pg_backrest. PostgreSQL has supported page-level checksums since 9.3. If page checksums are enabled pg …
answered May 15 '17 by Arkhena
1
vote
I'm sorry you ran into that kind of problem, due to device failure. I suppose you don't have any backup (either physical or logical) from before the corruption. You may find interesting things in … Christophe Petus's conf talk "Corruption war stories". You'll find the slides here and the youtube video there. What you could do is trying to copy all your uncorrupted data in another table (created …
answered Jan 18 by Arkhena