From: | "Andrus" <kobruleht2(at)hot(dot)ee> |
---|---|
To: | "pgsql-general" <pgsql-general(at)postgresql(dot)org>, "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com> |
Subject: | Re: could not determine encoding for locale "et_EE.UTF-8": codeset is "CPUTF-8" in pg_restore |
Date: | 2020-03-29 21:47:22 |
Message-ID: | DCAAD5074A8646B195DA28592F25223D@dell2 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi!
>> Same warning appears two times. This command execute by pg_restore
>> probably causes this (harmless?) warning:
>What warning?
pg_restore: WARNING: could not determine encoding for locale "et_EE.UTF-8":
codeset is "CPUTF-8"
>I cranked up a Windows 7 instance and tried to migrate a Postgres 11
>database from Ubuntu and it failed on the CREATE DATABASE step because of
>this line in the dump file:
>CREATE DATABASE redmine WITH TEMPLATE = template0 ENCODING = 'UTF8'
>LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8';
I ran this statemnt it in Windows 10 with Postgres 12 successfully. Result
was:
WARNING: could not determine encoding for locale "en_US.UTF-8": codeset is
"CPUTF-8"
WARNING: could not determine encoding for locale "en_US.UTF-8": codeset is
"CPUTF-8"
CREATE DATABASE
Query returned successfully in 1 secs 75 msec.
redmine database was created. I dont understand why it failed in your test.
>When I manually changed it in the plain text version of the dump file to:
>CREATE DATABASE redmine WITH TEMPLATE = template0 ENCODING = 'UTF8'
>LC_COLLATE = 'English_United States.1252' LC_CTYPE = 'English_United
>States.1252';
I verifed that data was restored using pg_restore without manually changing
anything.
Andrus.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter J. Holzer | 2020-03-29 22:49:13 | Idle sessions keep deleted files open |
Previous Message | Adrian Klaver | 2020-03-29 21:31:16 | Re: could not determine encoding for locale "et_EE.UTF-8": codeset is "CPUTF-8" in pg_restore |