Troubleshooting Migration Issues
This section provides some guidance if you encounter issues when migrating PostgreSQL data.
Data Encoding Do Not Match
| Issue | Solution |
|---|---|
Running the migration script generates an error message similar to the following: encodings for database "postgres" do not match: old "SQL_ASCII", new "UTF8" |
Reinitialize the target PostgreSQL 11 data directory to match the source PostgreSQL 9.5 database encoding. For more, see Configuring PostgreSQL on RHEL . |