Search Postgresql Archives

Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 6/23/22 00:37, Tomas Pospisek wrote:
On 22.06.22 22:18, Tomas Pospisek wrote:
On 22.06.22 21:25, Adrian Klaver wrote:
On 6/22/22 12:17, Tomas Pospisek wrote:


So I used both pg_dump and pg_restore from the newer machine. Result is still the same.  So I'll use Tom Lane's suggestion too and fix the 'UTF-8' spelling in the dump file:

Not sure why that is necessary? Is seems this is low hanging fruit that could dealt with by the equivalent of lower('en_US.UTF-8') = lower('en_US.utf-8').


Tom Lane wrote:

 > This is probably more about dumping from different operating systems.
 > The spelling of the locale name is under the control of the OS,
 > and Postgres doesn't know very much about the semantics of it
 > (so I think we conservatively assume that any difference in
 > spelling is significant).
 >
 > Best bet might be to edit the dump file to adjust the locale
 > spellings to match your new system.

Many thanks to both Tom & Adrian!!!
*t




--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux