sorry, slightly off point but I am a newbie and I was wondering gary,
why aren’t you going to postgresql 10.X ? I keep thinking
that I should stay as current as possible. should I relax about that ?
david
From: Scott Whitney <scott@journyx.com> Sent: Friday, January 18, 2019 9:31 AM To: Gary Stainburn <gary.stainburn@ringways.co.uk>; pgsql-admin <pgsql-admin@postgresql.org> Subject: Re: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8
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?