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@xxxxxxxxxxx> > Sent: Friday, January 18, 2019 9:31 AM > To: Gary Stainburn <gary.stainburn@xxxxxxxxxxxxxx>; pgsql-admin > <pgsql-admin@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx> > 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@xxxxxxxxxxx<mailto:scott@xxxxxxxxxxx> | +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
