PostgreSQL 9.2 DB migrate to PostGres 11
I'm getting stuck with a PostgreSQL 9.2 on CentOS 7 to be migrated to a new Postgres 11 fresh install on Debian 10.
I don't have experience with PGSQL as such so getting looped in the concept of Dump > < Restore and not getting in my head.
I noticed the old PG 9.2 DB has Encoding SQL_ASCII Collate C
But when I create new DB in PG v11 it defaults to UTF8 encoding.
So I guess we need to either create new DB with same encoding or convert to UTF8 which again might be a pain.
Should be a straightforward thing I presume so seeking out help if we we have someone experienced with PGSQL administration here on LET...