Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oMsmO-0000wB-J7 for pgsql-novice@arkaria.postgresql.org; Sat, 13 Aug 2022 15:10:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oMsmL-0001Ck-NB for pgsql-novice@arkaria.postgresql.org; Sat, 13 Aug 2022 15:10:21 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oMsmK-00016N-Ou for pgsql-novice@lists.postgresql.org; Sat, 13 Aug 2022 15:10:21 +0000 Received: from sonic311-31.consmr.mail.ir2.yahoo.com ([77.238.176.163]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oMsmH-0007CH-Bt for pgsql-novice@postgresql.org; Sat, 13 Aug 2022 15:10:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.uk; s=s2048; t=1660403414; bh=kKuCJJ/Bdo4sud0ui65QPZZt3dvxxTAkAfdmcR/UCc4=; h=Subject:From:Reply-To:To:Date:References:From:Subject:Reply-To; b=KciQPWqc6r/T4c/aQjpnyWSs8HNPOLQHLSRGRBLEL8Lmq9wZS+DKW/kAs7DytUPOmbGCYAYehgFcyD5U40ygtPK/AbbnyrNJ1nxKCyYAu8BDMMPbyD8IYWsa77IRc5f9SAFXOOmuxsfEG483ZNcqrFG0K27XSdHWRtcRxE6dsDHCl+IBg5pGg/bhmQLbQi6WQ367GWVmx/IvkDiTt4FYYmp572DnCW8qu2NwXPOoUKoaSljTzATa3bmK0B3iBNxtAgzDqkTcSeznKhYlZafRtuTpBtLHZ/eyGeimgWJiI8So0DT2fCnTfEdklUE8kJaigtaq9PF+OYGRPgBKCB5xyw== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1660403414; bh=1kixxASp5RsO+4mBUlcuZ8tk49AD2MnOLD9SjFkkl3v=; h=X-Sonic-MF:Subject:From:To:Date:From:Subject; b=Eax6HMPSRQ6t1Bg2Cx17869F+JDdOp8PLdo7QJayHexYUT++2f5Sicc6rLJEipw5DtQzQLRE6yAVw6STmXZn1cv6IKrvP/hDltvl4QArKth87DvcCwhyHFDa6PImB9zRMaAHLBp6tgWzBD/yqwzSW4fIy0c/ZPIWB2VfK5P4R3s4UjK6jyCAMm0K5tPFpqdFmBbVUArKd1q242Lohn5GH6IISPpMg/EKyWOiY2G0XQa67JMG8zQvVgbnluY06Lo8w5OzNubchpLr+2YqdV7E4WNOFsf6Y3UozGKFelSBvtEk7IDVs8WvMgfhXyGcY6Xac95yqz1y3EgOg/ORmD7SLw== X-YMail-OSG: _buNafwVM1k3NfkY1w2V_d_4UVs53fmuGljsez9dzaBk16Ye7I47Ej39rX.Fppo Fd5FWu5k_uP93oINLf_wa_J9KTKNIP4K14e_QSMoCKERU28L0KwOO0d5PPSBeG1HtGZj680wNs3u rbSbtggH0nWJkDBOoRe3ZFXveaaOPfhqt5LJl60EutscQ3GVuQsDzCb3LM58YrDTTISaAburPVXc xkHzQLHCLqMZamr3W76fWO5lYbnTdhGRg5Kx8li3V0slH95FxQIFl_e9X.AQEwmG0YjYSJKZNuvI wG3X70ex4IW6krrW7Zz_qlQzrQeqiSpdWGk3WBP7aGozESkpo.sa2UD5ReE2QTfrsctLGexLLqpo oRd4Th_D7k4SmtEWqeatHeIl1yszWZuHtx24g74Cb5AXQvwVE0pgJhSQAwTkvw_Xp3Yh.nhqei0I mNWVlPAjr9WtaWUzPxXvYrAZNLQfdCyzryDNFclWxRG00OhlA9AZSPL1xIhqz2VSEFbHXzdqv7Js NM2IWzot41xs269d0S7XSM9FKkSO388Et5n9udHV4NLMh2_fJO3..P0CvXThHCUJnOCR98OYG4lA ByjDMEBM8x5zcMhHH6A5iQswIn5j1tFmDH0GbbbXYaU8RfWduM7.lg6EToK0n3OVkp0XPhKndmB9 XiC5AY263Kqof34qL6QJejBQ18MlqDbUWSkP3QrhZoMkdur2meUVI3DNP8Te.8e0.O9hUS5bMNez cfgSz8ZUIMSfFJ4G3kgKNrEUDcejBVLNpJ0.15Tci9iDjSOyXHrKgFO2wbLdkpCzg0RBWaRQz5g6 inwQUwpmCc1XCZ3lXVRyxW6eNoYyACcnkyGiGHY_M0bu4RIk6DiMguQ1yKygLrYNp7tcVHSTmd7k jfDE3wGwtdCUi_PpRgjkkjTISg.s4xvpz_7Cuhw48Ysa4aKCUbDgikbN6JalN8yzGuit_46Dt.ts RjlnScjcOsQOmiaoEGQx4Azqk1kCz2i_3NunOv19boQEO_zktPuUEWk6XxOJMoo1EOytRWEe.STs R6LEmKd3V3UjlXU1PZDgDx9T7TYmhfXwm7CeTwFxGb97ZjqxdiKz0Rzp9U78VM4tFonKh8YZALg4 DoM5b2evUYm.fmXk7z9Rg7HhBOtMYxA8lGBinUdTiAETQTBOxIDF9PlTFE0Ib9zFP7ozdMbF4z2z Z0cYap7b0_cUab1ND6e27n27hm_kVvcmit6c4ZKg9z0oFJMAInVpbcqGh1ITjqNZJjSl7Um1NmWq GwKIZiwznaPaR.8cXoIi9g5k135WjwhTUYGS7eZ7Op8EhYJgw8I_z8D0gPwWtZXzyzGmdgvIH1Mw 9Z5Z_UucdZh2G3uoyRFNCRnoJBi35M1Z.2uN.c3_f3PEAjuT.e4ZOYA0o3SybRhQW2Nfd6Xd_b2L AxRwh1coMs_ZOwa3I4jn1Y3nIxWGTvI8Eek7padn8kBfx_jOvoaj5UFVi.xOWGESKTygNdT.PUIk WtH8I3R7zA.MUQI7EpMJDxO_Ce97DsUQZLF6SMEJAtjhzWYmnNWiu8nbLoV0Ox0FQl8lPPwPw20q D.3dc9d0a4GRMKUlHTm0TJKU.RAov8.rXv1J3IBmRJeSfUs_eph8fMyaBt1XqgHVvwNNb6l6sJ_V 7GcOKdkv52e_nqe1iNoaqK3XLd8729ZOTJnldRDiTZ9XrfiaOhoeJYOtWE5vm6mmawMR_m3Emb.8 PSZFb0K8t3e519WDsHiaSFJJGWRZpjdUFfLe3bZtbmuUXEEp9oa_KLHmBfmM2_xOxOJUoziTLJqt Zc0Z8QYn2nLjpua5OP2qTX5KlCsNVu9bFr6Wwn.1ORqeQ3Wn6kAjgK6m2ZvQZsNOLA7K_cgnr8E4 LtrmdJf4nst8BM6KhCGmPNK9pJzZUsSl5T.SPAeWE1r3rxg5QBqNalJAtzBM7fTytyZy5ZpJqvNA l2KsmwpMqMlJtZfIGMJgd816CUlsUQKzNcD7oS9.LOKjfUz_NQqcZATl7jdU.wfQzQ3ezv1jTV6o H6HzaWK32ON1g4N1MibpeeDYGw3f5IBh_1xF9OMJO2jZct9HX70a2KHs0pOpeqlCCWffGlLd_RKN jHlsHo1eC_uw._aVaKlnbqkHY66VO4xvM_qc7J.tt7FOFd1M78BJCyFy6if83uCksClgbbE.QwHy 1c1KQeA3ApCiq.qnMDFGoQ3aGXG6eOIf9ZcXOarB.8_spaMgbWrJNpuBk4OfcxKRxZkMKmgc8gWS VZlA_pfdbPA9hH4_3frbgGsrd_zUS_n25tqxFnvKlZJ8GafDaK1vEUaOglhAqYOOv5YZAwkQi2up SOZoiBNwAicJtqIZH9.wSXDxZsA-- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic311.consmr.mail.ir2.yahoo.com with HTTP; Sat, 13 Aug 2022 15:10:14 +0000 Received: by hermes--canary-production-ir2-f74ffc99c-wgh75 (Yahoo Inc. Hermes SMTP Server) with ESMTPA ID 3854379d87628ec96d9e5d2a3e9f7ca0; Sat, 13 Aug 2022 15:10:10 +0000 (UTC) Message-ID: Subject: database encoding migration from a pg_dumpall set From: Steve T Reply-To: stevetucknott@yahoo.co.uk To: PostGreSQL Organization: Personal Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Date: Sat, 13 Aug 2022 16:10:10 +0100 MIME-Version: 1.0 User-Agent: Evolution 3.44.4 (3.44.4-1.fc36) References: X-Mailer: WebService/1.1.20531 mail.backend.jedi.jws.acl:role.jedi.acl.token.atz.jws.hermes.yahoo Content-Length: 497 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Postgresql 14.3 Fedora 36 I have been meaning to move a few databases from an ISO encoding to UTF-8 f= or a while. I had taken a pg_dumpall dump of the complete instance and then created a new instance with a UTF-8 encoding= and imported the pg_dumpall. The databases were all imported ok, but still show as LATIN9/ISO... - so presumably the r= estore from pg_dumpall takes the instruction for the encoding from the dump records.=20 Is there an official way for migrating database encodings?