PostgreSQL Backup Encoding Fix

Posted on Tue 25 August 2020 in misc

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.