Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sqYFC-00Aggp-Uo for pgsql-general@arkaria.postgresql.org; Tue, 17 Sep 2024 13:27:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sqYFA-00Azuf-9C for pgsql-general@arkaria.postgresql.org; Tue, 17 Sep 2024 13:27:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sqYF9-00AzuV-Oh for pgsql-general@lists.postgresql.org; Tue, 17 Sep 2024 13:27:47 +0000 Received: from mx3.stadt-zuerich.ch ([194.56.33.12]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sqYF5-001ehT-JC for pgsql-general@postgresql.org; Tue, 17 Sep 2024 13:27:46 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=zuerich.ch; i=@zuerich.ch; l=10758; q=dns/txt; s=zuerichch202311; t=1726579665; x=1758115665; h=from:to:subject:date:message-id:references:in-reply-to: mime-version; bh=2mTcxRObuRGtqaD3sM1iFb8syl5GkfzlIEZ6uZt+RiM=; b=CYqlSxIIUugSmsx/yYC6cVWXr1CMZ1WWLsbpfIcEk7tTe700G/4M53uE wK6BBbln5YNilvh48mZW8p/+7NH94J/45xjHai0euxtR5Q51JaRlEOuhs khAA9jMs8Ol9ZgH67RSYH0pbsFk5SXaqNzeWRvQaJQEnlyph1Jnk/lnaT s3eUz9lVxNksUeYnO46RcgCd+2UhyqTawTYK7NsWoLrMrPRE5I/diDwye 7McXvMCrUm8rOzexNCc7YQrcdaXZcbCX7No6+9nOXnra13lhkgeHclPuI fQxroKYLkQ+AeqnZpxp7Vm3hqSGTi49m7wCkbDLN69pyQV9Z7l3HXhi9G A==; X-CSE-ConnectionGUID: 5D2AcYALQ6uVrDECLioiuw== X-CSE-MsgGUID: SVqvAJawQ5mWuFhIWUVTMw== X-IronPort-AV: E=Sophos;i="6.10,235,1719871200"; d="scan'208,217";a="224206330" Received: from unknown (HELO szhm35323.global.szh.loc) ([10.34.130.219]) by mx3.prm.szh.zone with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 17 Sep 2024 15:27:44 +0200 Received: from szhm35323.global.szh.loc (10.34.130.219) by szhm35323.global.szh.loc (10.34.130.219) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1544.11; Tue, 17 Sep 2024 15:27:43 +0200 Received: from ZR1P278CU001.outbound.protection.outlook.com (10.7.48.75) by szhm35323.global.szh.loc (10.34.130.219) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1544.11 via Frontend Transport; Tue, 17 Sep 2024 15:27:43 +0200 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=u2zgGCeh1d/YPB446J4SKRNpyBtH4wowVDN042yItMZlvCNhTGJfCx+95a6BXUdL2cak0nRitEvSImRU/6xqYCsjsaIuS6lYqOBR80FQnC15fGcU69cwXApj12QrIpkY+rOIjZHdfZoNjma8Suu0MZxDbb9gQkohziEgH8xTjAO45VZyVtvFLZAaKvtP6q7a8y/dkkcUadX2xbFZz0ygPdTCckb13uoXbPhSLep0IwvVjOpRiqBzkh6V5XgOmv4doMguCQIUhgKG905xAVrYyk58PXkpboMvIoY/Mp0fzLxFXE5OPZLQAEg6l27aPLgeIYkSJmqWeSmwdx0LYKkLiw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=2mTcxRObuRGtqaD3sM1iFb8syl5GkfzlIEZ6uZt+RiM=; b=B0MCoF63atATf7N6dkwhVaJbnYimoqv+XvahQ8ilmHdLa5H6jPVPGtAcmI0icnTlvL904ov+a25NiKGqosLnP+Du/EzhlL4k9xxxmBJhH0aMjAUw3xAGs0ETJbNwNmBCO82usq9jwsxRoD6dvHO35S04/JTxI6sv0/hObUwol8CnIc5tsJadj/c15hLPoJSVW5QU8dHeMJgX2Z2VKnH4WoBZ2P36KP8ZDOi7LBy0ZhPc+zjN/Xqx+UH4i2Qtn9ScP6kFIRaveVpoL/6oENb8GYsT822eZXZArjBA1Kb2ZDZ7Ea97DbZOuIa1pHx5RgccwIHdiT5r4a6A26n8mP/vUg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=zuerich.ch; dmarc=pass action=none header.from=zuerich.ch; dkim=pass header.d=zuerich.ch; arc=none Received: from GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM (2603:10a6:710:27::12) by ZR0P278MB1530.CHEP278.PROD.OUTLOOK.COM (2603:10a6:910:93::11) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7962.24; Tue, 17 Sep 2024 13:27:42 +0000 Received: from GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM ([fe80::bf73:d490:294c:3df3]) by GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM ([fe80::bf73:d490:294c:3df3%4]) with mapi id 15.20.7962.022; Tue, 17 Sep 2024 13:27:42 +0000 From: "Zwettler Markus (OIZ)" To: PG-General Mailing List Subject: WG: question on plain pg_dump file usage Thread-Topic: question on plain pg_dump file usage Thread-Index: AdsI/Dm3z5gVcpZ8Qe6aBjkJQGcfRwACLzeA Date: Tue, 17 Sep 2024 13:27:42 +0000 Message-ID: References: In-Reply-To: Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=zuerich.ch; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: GV0P278MB0099:EE_|ZR0P278MB1530:EE_ x-ms-office365-filtering-correlation-id: 0b01b9fd-648c-43e6-a8a8-08dcd71c8247 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|1800799024|376014|366016|38070700018; x-microsoft-antispam-message-info: =?us-ascii?Q?IXSJuD/U5M6ZCV7zfMQP1LVagVRbW2gPiQv/w+uuaojfutv7573psCSMVCLd?= =?us-ascii?Q?88T0P7Se4VhHmCPzMP/d3GotdJyLbiK+l087m6mX762DIy0+cO/tcdBMvmsA?= =?us-ascii?Q?d7G80Ed5Bk25Rt5bS8kjDTrCmSkTl7B1m6dwN2ExDvVbs06cdkxab5prw93d?= =?us-ascii?Q?+ByhNz8SrGGTO6NDwAmZaebA7OJdH51uGuOiYfT8mhsCTGdNZ0FY8J/GcefN?= =?us-ascii?Q?fJhBE+cXLuGRz5Xjy7Irp8DD26VX+nGie7RmhN5vb17u9Yf+GWjis8Q+I6V6?= =?us-ascii?Q?4C0CtrfensgEISACXNrmODBYAEra5ZT0lSXxNxrbbH7yHNU7m0di4cIbnixH?= =?us-ascii?Q?GCNTFieRVi07+Hoita0pl8/BZTB3PlQKjOjbSDR8BQOkOoEDO3szhKRjqNKp?= =?us-ascii?Q?UuqnAEJ6/jgw5J6AFMCEaozZJa79C6UzWegWYWL6SPogzQBTE1sLROY/FwBm?= =?us-ascii?Q?qRQUe8F5hr5cGy/thbKPHfu4YpIYpNiDXzsm/V5kUMK5jIB07ML4ADqgVc+h?= =?us-ascii?Q?8KKnv7BI84FPhWcvN3uHaOU1j9QrVhoGZXY23r0WUoHwTpopdcFwoU0CykI+?= =?us-ascii?Q?tLJpEqpXDroKlcFec+G/sPSIA9itLkEEVfn3WPy4ibCksQsBYohpNKu8xm0H?= =?us-ascii?Q?xPGRW5ly/vU4I3S5Gun25jWkRUmedYQL+of2KoArZPN7IgkmVHDN5IY7EPV+?= =?us-ascii?Q?VvbcacznqOVD5MTrhX05oElLV5Z9DJQ6AsbQHhfJzDtV5VKTmdbeJmsdVFJ7?= =?us-ascii?Q?4Xj5j52xIxgym+ZCNWLXQNyywPp3poNjmrh4Pb3TwvBlw8BvX2klx0PMWSGD?= =?us-ascii?Q?pGaFQyzB9pCVxYxT3DmoBiHTY9/PeDmp40p54Nd0F9L+trLBZdh65ZaGutKN?= =?us-ascii?Q?T0S5NHB6lWcBe5rdNJ3cMG7VESjc49nqC4jIEGgDJe9j+cf/5gxiQ590L1LR?= =?us-ascii?Q?Lqq2jHteI8G/uoBhfv7BQcQdD039KXRMGKarEQhdq4vv7POgAFsgm+Dbg1J3?= =?us-ascii?Q?fjHQ1rqENZiWb99W+lKJWQXL3aSxu52uoGqztVf+Qv9XyYtWx4xGabBXEAVK?= =?us-ascii?Q?L5W1EfYfPGESYHjATR5UwmLxr7/zzx8DWn767auHkZKX9GPgn+9gWkhOb8yC?= =?us-ascii?Q?wuYaFFTCcrpRjt0gByWMf4ydOdID0bsEYEItiBeoT0aG5rT0N/kmskYcHa8i?= =?us-ascii?Q?a5aS1clligICmCYRDRjs9sDt7ieZqj8u45+HFC+ZzZ83inOR18zpu+8+GZ0T?= =?us-ascii?Q?5d0GRccIR0GaxGM2+6p8n4VKDi6WN2/N2Lz3GRDWqshz/LgjcZ/yvlxknB3L?= =?us-ascii?Q?Y2y/nJBeY1YADYX/N6ZiITdZXqITrnv4LEd4ulUFLWd2eTnz7HbEXKb+dTyN?= =?us-ascii?Q?ZkxjJ7QeBZ2qp8zYBBP7RMLi9W9QeAh31Bd1HdTGZX3KrqMBlg=3D=3D?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230040)(1800799024)(376014)(366016)(38070700018);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?Yjp0O3hsBN/yKd0UAXLhGMhqUpNIiDLp8KGfwWETyDzC6n7lxw/6Mxyn5KGV?= =?us-ascii?Q?EXOJ5sn1q+QacLXpJITEIbMAwgCuoh++2XCIaXqJ3ZwkajpJxHfWIgVWdPbv?= =?us-ascii?Q?Mi0LvVPleN3JCoG12GgeRWVb7JLsH4fWtVoRYiwKueU6h+/lINKcWSzdRp+i?= =?us-ascii?Q?qs/xlQhlS7pRbmE3BGpHp13scolCT++J3jHR+oI8bBzstNqwH3/01Ukuay38?= =?us-ascii?Q?ypHve618xSwuxACG7+ADwzScKfGsqd3KrKkzza4qOQSxy6E3eMTsrkVpC6eb?= =?us-ascii?Q?zO5sL8GKd4codRAbDC6YWWnmkIFuvAbDltk8u+S4tkfFw8Zafgv15Xyx8mc7?= =?us-ascii?Q?3g25fQtN9S+AshZIylnovW40Ny/zmrH4o6zuBBUiVbTSjXa5ETGnH++52scE?= =?us-ascii?Q?VlLK9k7liWXuXIyAG8lB/RmxILy0PMXqlwvST98DQAOC9BBj0u51b6zAvQzq?= =?us-ascii?Q?I/LwZzhJTvuNE1ns/v5fR/BhSLiOJm/oOJ7xhurrbyVmEmEPDXLc1Mr3Gndj?= =?us-ascii?Q?h8FeHA8v13K3QTmpmEcISh4MRn9BYlmdZseF+44Bvfm2vXFDl0jFPVfg4aG2?= =?us-ascii?Q?BxUqVj7blY2Su6VVTaszZz8og1SM7uwZ4MFpr3CQQy8x1lmf0C2vZLT+OGRh?= =?us-ascii?Q?rnWgASBBUsw4bjrYPOIdtuujfn9w4dAwLn2dLRHi44hG9Tawa05I8zA1lKSB?= =?us-ascii?Q?U3NwFRgSkl5WioB9gypyNUYonQL9bLyoQYTCWAKnonPJXCZet0/oa7xHACa+?= =?us-ascii?Q?kAkSVCzvlYtYspJ3ubHcfOh+GcH+S2rDqPuzX7Dcv21T7frpWTBf5/Lfq9bn?= =?us-ascii?Q?/sDhpUnPLdCqx9E+9m6t8199waofVgBH/LNu0F18V3oV4EF5ujK/KeOTrqs6?= =?us-ascii?Q?RiBcg+dCZ6lsIODIJOD8cocRjnO461bPcKc9AHOQJpJxGpy6v/sv4ZigwFsF?= =?us-ascii?Q?SemBZdE+rb2S5iKoJsZXV9xfsCjfTRKxHBs01Nqqdqa8fe0b8L2w51bOtGMt?= =?us-ascii?Q?VxPctdg7+LdVIm5LMVfxvIkn+I6khUV9Y0dec2d0ymvLXCxGd8UuxMzY+P5t?= =?us-ascii?Q?M0SgksHlMaERjpkiGi6jKlY/j0Sc9x0piHhIWBBtS585KSEoTlu0N8pEqFfE?= =?us-ascii?Q?h6vyGLIi4X7mzuLkCkthiXQ6Zkrhxlyhr/Vg+XC2O6z1wXK9WH0tcZwQms/9?= =?us-ascii?Q?5xe92w4rTzCI21lID6gQcYwV+gYIBGT+vl5Tqp7qWnymR/+E8Q5uGrHw3sdl?= =?us-ascii?Q?1tS6hFx6VrFxdtRSmvOXmfOcL7GfTJXpKPYTvolWtNVDYk1hqItO1JfHf3bZ?= =?us-ascii?Q?dHW4G/QYkqw+dtwFTRZqipGk610yTJ0ri7z0bC7wxKiqpInQ9x76BQAz8/Nd?= =?us-ascii?Q?wiztzA7vOwS0kTVF30/4Qne+oPlzfJ6JOlBAU9xhaTsQ97qktoAW7BWParuc?= =?us-ascii?Q?qfLJFYyzvvojWOqS6hUtWjGPq5etedU1u8Ov9cJk0UPU+OZ9Uka8FGA3i5a4?= =?us-ascii?Q?OQhwc7gRsCDjH2cs6hXhzI9ScUt8B8/0HFDa0XiyOsPgU+oqlogMTnA4aZhN?= =?us-ascii?Q?8Bhr1rDzSeN/JFZQ6qknRXdfVmYVOyvUhpi/X7Sd?= Content-Type: multipart/alternative; boundary="_000_GV0P278MB00996F003F2A695EFAF823948B612GV0P278MB0099CHEP_" MIME-Version: 1.0 X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: 0b01b9fd-648c-43e6-a8a8-08dcd71c8247 X-MS-Exchange-CrossTenant-originalarrivaltime: 17 Sep 2024 13:27:42.3944 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 9f489fcc-e452-4509-8234-6f97b42d0117 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: KQkBpmMzDSXf7PX1eDevR2hISGEdgsgSQGwjhA4HPHSBHFFcq7ADfhCv9qvX3Bwf3+aXP1gjjhT7yQz7OxKjR1r7oGVtkCYRfDxjeEqp0QE= X-MS-Exchange-Transport-CrossTenantHeadersStamped: ZR0P278MB1530 X-OriginatorOrg: zuerich.ch List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_GV0P278MB00996F003F2A695EFAF823948B612GV0P278MB0099CHEP_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Von: Zwettler Markus (OIZ) Gesendet: Dienstag, 17. September 2024 14:22 An: PG-General Mailing List Betreff: question on plain pg_dump file usage I have to do an out-of-place Postgres migration from PG12 to PG16 using: pg_dump -F p -f dump.sql ... sed -i "s/old_name/new_name/g" psql -f dump.sql ... Both databases are on UTF-8. I wonder if there could be character set conversion errors here, as the dat= a is temporarily written to a plain text file. Thanks, Markus I found that the tempory plain text file is also encoded in UTF-8. There should not be any problem so. Agreed? $ file -bi dump.sql text/plain; charset=3Dutf-8 --_000_GV0P278MB00996F003F2A695EFAF823948B612GV0P278MB0099CHEP_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

=  

Von: Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>
Gesendet: Dienstag, 17. September 2024 14:22
An: PG-General Mailing List <pgsql-general@postgresql.org>
Betreff: question on plain pg_dump file usage

 

I have to do an out-of-place Po= stgres migration from PG12 to PG16 using:

 

pg_dump -F p -f dump.sql …= ;

sed -i "s/old_name/new_nam= e/g"

psql -f dump.sql …

 

Both databases are on UTF-8.

 

I wonder if there could be char= acter set conversion errors here, as the data is temporarily written to a p= lain text file.

 

Thanks, Markus

 

 

 

 

I found that the tempory plain text file is also encoded in = UTF-8.

 

There should not be any problem so. Agreed?

 

$ file -bi dump.sql

text/plain; charset=3Dutf-8

 

--_000_GV0P278MB00996F003F2A695EFAF823948B612GV0P278MB0099CHEP_--