Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gkVry-000508-4g for pgsql-admin@arkaria.postgresql.org; Fri, 18 Jan 2019 15:15:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gkVrw-0002uB-FD for pgsql-admin@arkaria.postgresql.org; Fri, 18 Jan 2019 15:15:40 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gkVVY-0008I3-3u for pgsql-admin@lists.postgresql.org; Fri, 18 Jan 2019 14:52:32 +0000 Received: from smtp106.ord1c.emailsrvr.com ([108.166.43.106]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gkVVV-0007r3-0K for pgsql-admin@postgresql.org; Fri, 18 Jan 2019 14:52:30 +0000 Received: from smtp22.relay.ord1c.emailsrvr.com (localhost [127.0.0.1]) by smtp22.relay.ord1c.emailsrvr.com (SMTP Server) with ESMTP id AD8A2E02B3; Fri, 18 Jan 2019 09:52:27 -0500 (EST) X-SMTPDoctor-Processed: csmtpprox beta Received: from smtp22.relay.ord1c.emailsrvr.com (localhost [127.0.0.1]) by smtp22.relay.ord1c.emailsrvr.com (SMTP Server) with ESMTP id AA050E02BC; Fri, 18 Jan 2019 09:52:27 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=imaginesoftware.com; s=20170104; t=1547823147; bh=BoyjEpgtO7tUv52HDKgCZjz4vApH7N2uUww07BY8KzE=; h=From:To:Subject:Date:From; b=fWNCQi3vauv2l4xo7yKujKaWoIm+hiZuRTvB3cNOfdVj575D22/r4+ok1AQdZvuxw Vub6ULEpzkBOEaBG126gMw1pskII7vj/1WSgUnfEuDdgzExkwtidY7wwSe4bgG1VaA 0NmwCKdGHPKbifTY9DF0RuNbOvNBsxPDrAWXZWlY= Received: from smtp192.mex09.emailsrvr.com (unknown [184.106.73.70]) by smtp22.relay.ord1c.emailsrvr.com (SMTP Server) with ESMTPS id 8A843E02B3; Fri, 18 Jan 2019 09:52:26 -0500 (EST) X-Sender-Id: davidmo@imaginesoftware.com Received: from smtp192.mex09.emailsrvr.com ([UNAVAILABLE]. [184.106.73.70]) (using TLSv1.2 with cipher AES256-GCM-SHA384) by 0.0.0.0:25 (trex/5.7.12); Fri, 18 Jan 2019 09:52:26 -0500 Received: from MBX01D-ORD1.mex09.mlsrvr.com (172.29.128.27) by MBX01C-ORD1.mex09.mlsrvr.com (172.29.128.20) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P256) id 15.1.1466.3; Fri, 18 Jan 2019 08:52:25 -0600 Received: from MBX01D-ORD1.mex09.mlsrvr.com ([fe80::c9b1:8c28:1031:4efd]) by MBX01D-ORD1.mex09.mlsrvr.com ([fe80::c9b1:8c28:1031:4efd%21]) with mapi id 15.01.1466.003; Fri, 18 Jan 2019 08:52:25 -0600 From: David Modica To: Scott Whitney , Gary Stainburn , pgsql-admin Subject: RE: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8 Thread-Topic: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8 Thread-Index: AQHUrzpZ2LaorBp0bUOJ5Z+4rzifPKW1ex8A//+gToA= Date: Fri, 18 Jan 2019 14:52:25 +0000 Message-ID: <4e0b15ef7f84466b9370324b7f384972@imaginesoftware.com> References: <201901181429.51278.gary.stainburn@ringways.co.uk> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: yes X-MS-TNEF-Correlator: x-originating-ip: [4.31.46.200] Content-Type: multipart/related; boundary="_007_4e0b15ef7f84466b9370324b7f384972imaginesoftwarecom_"; type="multipart/alternative" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_007_4e0b15ef7f84466b9370324b7f384972imaginesoftwarecom_ Content-Type: multipart/alternative; boundary="_000_4e0b15ef7f84466b9370324b7f384972imaginesoftwarecom_" --_000_4e0b15ef7f84466b9370324b7f384972imaginesoftwarecom_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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 Sent: Friday, January 18, 2019 9:31 AM To: Gary Stainburn ; pgsql-admin 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 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 hav= e progressed a lot since 2008 when I built this server, so I wonder what is t= he right thing to do moving forward. The old system has # These settings are initialized by initdb, but they can be changed. lc_messages =3D 'en_GB' # locale for system error message strings lc_monetary =3D 'en_GB' # locale for monetary formatting lc_numeric =3D 'en_GB' # locale for number formatting lc_time =3D 'en_GB' # locale for time formatting while the new system has lc_messages =3D 'en_GB.UTF-8' # locale for system error message strings lc_monetary =3D 'en_GB.UTF-8' # locale for monetary formatting lc_numeric =3D 'en_GB.UTF-8' # locale for number formatting lc_time =3D '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.] = [Image removed by sender.] [Image removed by sender.] Scott Whitney Director of IT [Image removed by sender.] 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-pr= eferences. --_000_4e0b15ef7f84466b9370324b7f384972imaginesoftwarecom_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

sorry, slightly off point but I am a = newbie and I was wondering gary,

 

why aren’t you going to  p= ostgresql 10.X  ? I keep thinking

 

that I should stay as current as poss= ible. should I relax about that ?

 

david

 

From: Scott Whitney <scott@journy= x.com>
Sent: Friday, January 18, 2019 9:31 AM
To: Gary Stainburn <gary.stainburn@ringways.co.uk>; pgsql-admi= n <pgsql-admin@postgresql.org>
Subject: Re: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8

 

S= o long as you use pg_dump from PG 9 to dump the PG 8 databases, you'll be f= ine.

<= o:p> 

e= n_GB.UTF-8 will be fine (and is probably preferred).

 <= /p>

From: Gary S= tainburn <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 perf= orming 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 thing= s have
progressed a lot since 2008 when I built this server, so I wonder what is t= he
right thing to do moving forward.  The old system has

# These settings are initialized by initdb, but they can be changed.
lc_messages =3D 'en_GB'   # locale for system error message = strings
lc_monetary =3D 'en_GB'   # locale for monetary formatting
lc_numeric =3D 'en_GB'    # locale for number formatting
lc_time =3D 'en_GB'         &n= bsp;     # locale for time formatting

while the new system has

lc_messages =3D 'en_GB.UTF-8'     # locale for system e= rror message strings
lc_monetary =3D 'en_GB.UTF-8'     # locale for monetary= formatting
lc_numeric =3D 'en_GB.UTF-8'      # locale for num= ber formatting
lc_time =3D '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 p= rocess
        b) using the database moving for= ward?

Gary

 

3D"Image

3D"Image  3D"Image

3D"Image<= o:p>

Scott Whitne= y
Director of IT

3D"Image

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, clic= k here or visit http://journyx.com/communication-preferences. =

--_000_4e0b15ef7f84466b9370324b7f384972imaginesoftwarecom_-- --_007_4e0b15ef7f84466b9370324b7f384972imaginesoftwarecom_ Content-Type: image/jpeg; name="~WRD000.jpg" Content-Description: ~WRD000.jpg Content-Disposition: inline; filename="~WRD000.jpg"; size=823; creation-date="Fri, 18 Jan 2019 14:48:57 GMT"; modification-date="Fri, 18 Jan 2019 14:48:57 GMT" Content-ID: <~WRD000.jpg> Content-Transfer-Encoding: base64 /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCABkAGQDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo ooAKKKKACiiigAooooAKKKKACiiigD//2Q== --_007_4e0b15ef7f84466b9370324b7f384972imaginesoftwarecom_ Content-Type: image/jpeg; name="image001.jpg" Content-Description: image001.jpg Content-Disposition: inline; filename="image001.jpg"; size=407; creation-date="Fri, 18 Jan 2019 14:52:25 GMT"; modification-date="Fri, 18 Jan 2019 14:52:25 GMT" Content-ID: Content-Transfer-Encoding: base64 /9j/4AAQSkZJRgABAQEAeAB4AAD/2wBDAAoHBwgHBgoICAgLCgoLDhgQDg0NDh0VFhEYIx8lJCIf IiEmKzcvJik0KSEiMEExNDk7Pj4+JS5ESUM8SDc9Pjv/wAALCABPAFABAREA/8QAHwAAAQUBAQEB AQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1Fh ByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZ WmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXG x8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/9oACAEBAAA/APZqKKKKKKKKKKKKKKKK KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK KKKKKKK//9k= --_007_4e0b15ef7f84466b9370324b7f384972imaginesoftwarecom_ Content-Type: image/jpeg; name="image002.jpg" Content-Description: image002.jpg Content-Disposition: inline; filename="image002.jpg"; size=344; creation-date="Fri, 18 Jan 2019 14:52:25 GMT"; modification-date="Fri, 18 Jan 2019 14:52:25 GMT" Content-ID: Content-Transfer-Encoding: base64 /9j/4AAQSkZJRgABAQEAeAB4AAD/2wBDAAoHBwgHBgoICAgLCgoLDhgQDg0NDh0VFhEYIx8lJCIf IiEmKzcvJik0KSEiMEExNDk7Pj4+JS5ESUM8SDc9Pjv/wAALCAAfAB8BAREA/8QAHwAAAQUBAQEB AQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1Fh ByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZ WmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXG x8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/9oACAEBAAA/APZqKKKKKKKKKKKKKKK/ /9k= --_007_4e0b15ef7f84466b9370324b7f384972imaginesoftwarecom_ Content-Type: image/jpeg; name="image003.jpg" Content-Description: image003.jpg Content-Disposition: inline; filename="image003.jpg"; size=410; creation-date="Fri, 18 Jan 2019 14:52:25 GMT"; modification-date="Fri, 18 Jan 2019 14:52:25 GMT" Content-ID: Content-Transfer-Encoding: base64 /9j/4AAQSkZJRgABAQEAeAB4AAD/2wBDAAoHBwgHBgoICAgLCgoLDhgQDg0NDh0VFhEYIx8lJCIf IiEmKzcvJik0KSEiMEExNDk7Pj4+JS5ESUM8SDc9Pjv/wAALCAA8AGQBAREA/8QAHwAAAQUBAQEB AQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1Fh ByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZ WmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXG x8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/9oACAEBAAA/APZqKKKKKKKKKKKKKKKK KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK KKKKKKKKKKK//9k= --_007_4e0b15ef7f84466b9370324b7f384972imaginesoftwarecom_--