Upload PostgreSQL not working, change the encoding may help

20 Jul , 2015  

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 :

update pg_database set encoding = pg_char_to_encoding('UTF8') where datname = 'your-database';


Leave a Reply

Your email address will not be published. Required fields are marked *