database encoding migration from a pg_dumpall set - Mailing list pgsql-novice

From Steve T
Subject database encoding migration from a pg_dumpall set
Date
Msg-id ecf6066e7e1372c849f9d36477f999b0ad627785.camel@yahoo.co.uk
Whole thread Raw
Responses Re: database encoding migration from a pg_dumpall set
List pgsql-novice
Postgresql 14.3 Fedora 36

I have been meaning to move a few databases from an ISO encoding to UTF-8 for a while. I had taken a pg_dumpall dump of
the complete instance and then created a new instance with a UTF-8 encoding and imported the pg_dumpall. The databases
were all imported ok, but still show as LATIN9/ISO... - so presumably the restore from pg_dumpall takes the instruction
for the encoding from the dump records.
Is there an official way for migrating database encodings?






pgsql-novice by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: switch between async to sync automatically
Next
From: Tom Lane
Date:
Subject: Re: database encoding migration from a pg_dumpall set