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’; |
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’; |