From: | Scott Whitney <scott(at)journyx(dot)com> |
---|---|
To: | Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8 |
Date: | 2019-01-18 14:31:28 |
Message-ID: | SN6PR11MB2976942F96E421107E5ED3E4A79C0@SN6PR11MB2976.namprd11.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
So long as you use pg_dump from PG 9 to dump the PG 8 databases, you'll be fine.
en_GB.UTF-8 will be fine (and is probably preferred).
________________________________
From: Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk>
Sent: Friday, January 18, 2019 8:29 AM
To: pgsql-admin
Subject: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8
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
[http://journyx.com/emailImages/ScottWhitney.png]
[http://journyx.com/emailImages/linkedin.png]<https://www.linkedin.com/company/journyx-inc/> [http://journyx.com/emailImages/twitter.png] <https://www.twitter.com/journyxinc>
[http://journyx.com/emailImages/bluebar.jpg]
Scott Whitney
Director of IT
[http://journyx.com/emailImages/journyx.jpg]
scott(at)journyx(dot)com<mailto:scott(at)journyx(dot)com> | +1 (800) 755-9878
7600 Burnet Road, Ste. 300
Austin, TX 78757
Visit us at www.journyx.com<https://www.journyx.com/>
To unsubscribe from Journyx promotional emails, click here <http://journyx.com/communication-preferences> or visit http://journyx.com/communication-preferences.
From | Date | Subject | |
---|---|---|---|
Next Message | David Modica | 2019-01-18 14:52:25 | RE: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8 |
Previous Message | Gary Stainburn | 2019-01-18 14:29:51 | upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8 |