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

That is a very good question.

The honest answer is because the article(s) that I have been following have
all pointed to 9.6. Having installed 9.6 and imported my data a couple of
times I've found it faultless.

Other than being on the latest version, what benefits and what problems would
I encounter moving to 10.x?

If I were to go to 10.x on Centos 7, would I be able to install it alongside
the existing 9.6 to test it? I have noticed with the 9.6 install that it's
now using the version number as part of the data path.

As a side question, I will be moving PHP5 on my old box to PHP7 on my new one.
Is there any gotcha's I need to worry about?

On Friday 18 January 2019 14:52:25 David Modica wrote:
> 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(at)journyx(dot)com>
> Sent: Friday, January 18, 2019 9:31 AM
> 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
>
>
> 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
>
>
> [Image removed by sender.]
>
> [Image removed by sender.]<https://www.linkedin.com/company/journyx-inc/>
> [Image removed by sender.] <https://www.twitter.com/journyxinc>
>
> [Image removed by sender.]
>
>
> Scott Whitney
> Director of IT
>
> [Image removed by sender.]
>
> 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.

--
Gary Stainburn
Group I.T. Manager
Ringways Garages
http://www.ringways.co.uk