Re: pg_update and encoding

2023-09-12 Thread Adrian Klaver
On 9/12/23 04:49, Graeme wrote: Preparing to use pg_update, I used initdb to create the new pgsql/data, but pg_update has exited with I'm guessing that is actually pg_upgrade: https://www.postgresql.org/docs/current/pgupgrade.html encodings for database "template1" do not match:  old "UTF8"

Re: pg_update and encoding

2023-09-12 Thread Graeme
On 12/09/2023 15:52, Adrian Klaver wrote: On 9/12/23 04:49, Graeme wrote: Preparing to use pg_update, I used initdb to create the new pgsql/data, but pg_update has exited with I'm guessing that is actually pg_upgrade: https://www.postgresql.org/docs/current/pgupgrade.html encodings for dat

pg_update and encoding

2023-09-12 Thread Graeme
Preparing to use pg_update, I used initdb to create the new pgsql/data, but pg_update has exited with encodings for database "template1" do not match:  old "UTF8", new "SQL_ASCII" Should I delete pgsql/data and re-create with initdb -E "UTF8"? Thanks, Graeme