From: Gary Stainburn <gary.stainburn@ringways.co.uk>
Organization: Ringways Garages Ltd
To: "pgsql-admin" <pgsql-admin@postgresql.org>
Subject: Re: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8
Date: Fri, 18 Jan 2019 15:08:26 +0000
User-Agent: KMail/1.9.10
References: <201901181429.51278.gary.stainburn@ringways.co.uk>
 <SN6PR11MB2976942F96E421107E5ED3E4A79C0@SN6PR11MB2976.namprd11.prod.outlook.com>
 <4e0b15ef7f84466b9370324b7f384972@imaginesoftware.com>
In-Reply-To: <4e0b15ef7f84466b9370324b7f384972@imaginesoftware.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <201901181508.26233.gary.stainburn@ringways.co.uk>
Precedence: bulk

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@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?
>
> 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@journyx.com<mailto:scott@journyx.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