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 :

1
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 *