Tag: Upload PostgreSQL not working

Upload PostgreSQL not working, change the encoding may help

Upload PostgreSQL not working, change the encoding may help

When we upload and restore the backup into new postgresql server, sometimes we facing problem because encoding. To solve this, we can use UTF-8 : 1update pg_database set encoding = pg_char_to_encoding(‘UTF8’) where datname = ‘your-database’;