upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8

From: Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk>
To: "pgsql-admin" <pgsql-admin(at)postgresql(dot)org>
Subject: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8
Date: 2019-01-18 14:29:51
Message-ID: 201901181429.51278.gary.stainburn@ringways.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I'm performing a long overdue upgrade of a Fedora 9 / Postgresql 8.3 to a
Centos 7 / Postgresql 9.6 system.

I'm just going though the config files to check that everything is okay and
I've found a discrepency regarding language settings. I realise things have
progressed a lot since 2008 when I built this server, so I wonder what is the
right thing to do moving forward. The old system has

# These settings are initialized by initdb, but they can be changed.
lc_messages = 'en_GB' # locale for system error message strings
lc_monetary = 'en_GB' # locale for monetary formatting
lc_numeric = 'en_GB' # locale for number formatting
lc_time = 'en_GB' # locale for time formatting

while the new system has

lc_messages = 'en_GB.UTF-8' # locale for system error message strings
lc_monetary = 'en_GB.UTF-8' # locale for monetary formatting
lc_numeric = 'en_GB.UTF-8' # locale for number formatting
lc_time = 'en_GB.UTF-8' # locale for time formatting

Am I best changing the new system to match the old one?
If I leave the settings as they are, enabling the utf-8, how will it affect
a) the pg_dumpall / pg_recover process
b) using the database moving forward?

Gary

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Whitney 2019-01-18 14:31:28 Re: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8
Previous Message Pepe TD Vo 2019-01-17 16:54:54 Re: Copying Data from Oracle to PostgreSQL