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

Поиск
Список
Период
Сортировка
От Scott Whitney
Тема Re: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8
Дата
Msg-id SN6PR11MB2976942F96E421107E5ED3E4A79C0@SN6PR11MB2976.namprd11.prod.outlook.com
обсуждение исходный текст
Ответ на upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
Ответы RE: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8  (David Modica <davidmo@imaginesoftware.com>)
Список 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.stainburn@ringways.co.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



 

Scott Whitney
Director of IT

scott@journyx.com | +1 (800) 755-9878

7600 Burnet Road, Ste. 300
Austin, TX 78757

Visit us at www.journyx.com



To unsubscribe from Journyx promotional emails, click here or visit http://journyx.com/communication-preferences.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Gary Stainburn
Дата:
Сообщение: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8
Следующее
От: David Modica
Дата:
Сообщение: RE: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8