Postgresql Backfup Fix Encoding

Posted on 25-08-2020

Today I dumped some data from PostgreSQL's docker instance and when I try to restore it it brokes the data. After checking the dump's encoding via file command, figured out that dump file has UTF-16 encoding. When converting dump file encoding to utf-8 using iconv it worked.