PG::Error: ERROR: new encoding (UTF8) is incompatible

-
  1. First, we need to drop template1. Templates can't be dropped, so we first modify it so t's an ordinary database:
    UPDATE pg_database SET datistemplate = FALSE WHERE datname = 'template1';
  2. Now we can drop it:
    DROP DATABASE template1;
  3. Now its time to create database from template0, with a new default encoding:
    CREATE DATABASE template1 WITH TEMPLATE = template0 ENCODING = 'UNICODE';
  4. Now modify template1 so it's actually a template:
    UPDATE pg_database SET datistemplate = TRUE WHERE datname = 'template1';
  5. Now switch to template1 and VACUUM FREEZE the template:
    \c template1
    VACUUM FREEZE;
Problem should be resolved.

Popular posts from this blog

cognos content store database tables

-
CMSYSPROPS This table has the Content Store Version. CMOBJNAMES This table has the names of all the objects in the content store. CMOBJPROPS1 Users, Roles \ Group Distribution list and contact information such as Email, phone number, Fax Given name etc are stored in this table. CMOBJPROPS2 Report scheduling information is stored. This table has fields like hour, day week etc CMOBJPROPS3 Stores Screen Tip and Object description provided while creating the objects are stored here CMOBJPROPS4 Stores the printer paper setting details like height and width of A3 , A4 , letter and 11X17 paper orientations CMOBJPROPS6 Has the details of the all packages which were published using the FM. CMOBJPROPS7 This table stores the XML of all reports and models. This is basically to maintain the metadata about the structure of the reports and models. CMOBJPROPS10 Contact information is stored in this table. This table has columns like Contact Email and C...
Read more

alma linux: dnf Module yaml error: Unexpected key in data

-
While applying recent updates to a server running Rocky Linux 8, an error presented itself. Module yaml error: Unexpected key in data: static_context [line 9 col 3] Module yaml error: Unexpected key in data: static_context [line 9 col 3] The solution turned out to be a simple one. Update the libmodulemd first to correct the problem then perform the dnf updates as usual. dnf update libmodulemd For a detailed explanation as to the cause of this problem.
Read more

Shrink you container size up to 95%.

-
BLAFS is a bloat-aware filesystem for container debloating. The design principles of BLAFS are effective, efficient, and easy to use. It detects the files used by the container, and then debloats the container by removing the unused files. The debloated containers are still functional and can run the same workload as the original containers, but with a much smaller size and faster deployment. https://github.com/negativa-ai/BLAFS?tab=readme-ov-file
Read more