Uploaded image for project: 'ONAP Operations Manager'
  1. ONAP Operations Manager
  2. OOM-2290

encoding for Common PG

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Done
    • Icon: High High
    • Frankfurt Release
    • None
    • None
    • None

      Current PG common chart does not allow application to specify char encoding. This defaults PG instance to SQL_ASCII encoding (instead of recommended UTF-8)

      Need  PG common template to be updated to provide encoding as option,  so the application can override them to UTF-8 via their helm charts.

       

      root@onap2-nfs:~# kubectl exec -it -n onap dcae-dashboard-dcae-dashboard-pg-primary-d8b649c7-4l49x /bin/sh
      sh-4.2$ psql
      psql (10.4)
      Type "help" for help.

      postgres=# \l
                                               List of databases
                Name          |  Owner   | Encoding  | Collate | Ctype |        Access privileges
      -----------------------+-----------------------------------------------------------------
       dashboard_pg_db_common | postgres | SQL_ASCII | C       | C     | =Tc/postgres                   +
                              |          |           |         |       | postgres=CTc/postgres          +
                              |          |           |         |       | dashboard_pg_admin=CTc/postgres
       postgres               | postgres | SQL_ASCII | C       | C     |
       template0              | postgres | SQL_ASCII | C       | C     | =c/postgres                    +
                              |          |           |         |       | postgres=CTc/postgres
       template1              | postgres | SQL_ASCII | C       | C     | =c/postgres                    +
                              |          |           |         |       | postgres=CTc/postgres
      (4 rows)

       

       

            sdesbure sdesbure
            vv770d vv770d
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: