Postgresql migration from 9.6 to 10 fails
This document (7023640) is provided subject to the disclaimer at the end of this document.
encodings for database "postgres" do not match: old "UTF8", new "LATIN1" Failure, exitingUpgrading database to version 10 failed!
Before :su -s /bin/bash - postgres -c "initdb -D /var/lib/pgsql/data"After :su -s /bin/bash - postgres -c "initdb -D /var/lib/pgsql/data --locale=en_US.UTF-8"
rm -rf /var/lib/pgsql/data-new-failed
This Support Knowledgebase provides a valuable tool for SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.
- Document ID:7023640
- Creation Date: 15-Jan-2019
- Modified Date:03-Mar-2020
- SUSE Manager
For questions or concerns with the SUSE Knowledgebase please contact: firstname.lastname@example.org