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 1qgiH3-00Gxiw-Rw for pgsql-bugs@arkaria.postgresql.org; Thu, 14 Sep 2023 09:04:34 +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 1qgiGz-0075Bs-EF for pgsql-bugs@arkaria.postgresql.org; Thu, 14 Sep 2023 09:04:29 +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 1qggmk-006Y5w-8w for pgsql-bugs@lists.postgresql.org; Thu, 14 Sep 2023 07:29:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qggmg-004zTv-0M for pgsql-bugs@lists.postgresql.org; Thu, 14 Sep 2023 07:29:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=qxQXr/4KFl7DYK2XazVVQxAF4abjvC1P9CnHaSfos5U=; b=D8rtHRADYYX2oxF3eVvd4sBEog eBc4PFK70o6QFtzo663w0ebrYwGyD0i6y4wY4zZMaVpqBZP1bnR3SEDFhXn/F9MTv5u/Y0pzlnT+l WdSROPHAuiTF7JSVfjR/Ec6+TsIj2FGOZlf6eu4mF+gZlF/y8h8DhND444hTZF1PbueAGxtvo6u3F gBNDvR6HCyl22P7b8fXFvs/dfYLWU4MPuej8YsitEwm6u4gHTyxsyXbz3D4Vb+8gT9F40jYArDIU6 ZujOnnHfoi8IMTwj1G3ZF/TdXLk5wlw9h2+3HYd5PHbO34fKtDCX82iTEnVM9tXu7beqBnWVG9m6u 0otyEJyA==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qggme-0006MO-EM for pgsql-bugs@lists.postgresql.org; Thu, 14 Sep 2023 07:29:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qggmc-00EtRB-RD for pgsql-bugs@lists.postgresql.org; Thu, 14 Sep 2023 07:29:03 +0000 Content-Type: multipart/mixed; boundary="===============2383555306568135683==" MIME-Version: 1.0 Subject: BUG #18107: "policy ... for table ... already exists" errors when restore postgres database from dump To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: antoniok.spb@gmail.com Reply-To: antoniok.spb@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 14 Sep 2023 07:28:44 +0000 Message-ID: <18107-2668460d8c2804d2@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2383555306568135683== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODEwNwpMb2dnZWQgYnk6ICAgICAgICAgIEFudG9uaW9LCkVtYWlsIGFk ZHJlc3M6ICAgICAgYW50b25pb2suc3BiQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDE1 LjQKT3BlcmF0aW5nIHN5c3RlbTogICBEZWJpYW4gR05VL0xpbnV4IDEyIChib29rd29ybSkKRGVz Y3JpcHRpb246ICAgICAgICAKCkknbSByZXN0b3JpbmcgcG9zdGdyZXNxbCBkYXRhYmFzZSBmcm9t IGR1bXAgb24gYSBmcmVzaCBuZXcgc2VydmVyLiBTb3VyY2UKZGF0YWJhc2UgdXNlcyBwZ2Nyb24g ZXh0ZW5zaW9uLCB0YXJnZXQgc2VydmVyIGhhdmUgcGdjcm9uIGV4dGVuc2lvbgppbnN0YWxsZWQu DQoNClRoaXMgaXMgaG93IEkgY3JlYXRlIGR1bXBzIG9uICJzb3VyY2UiIHNlcnZlcjoNCiQgcGdf ZHVtcGFsbCAtaCBob3N0bmFtZSAtcCA1NDM1IC1VIG15dXNlciAtLXJvbGVzLW9ubHkgfCBiemlw MiAtYyAteiA+CmR1bXAtcm9sZS5zcWwuYnoyDQokIHBnX2R1bXAgLUMgLWggaG9zdG5hbWUgLXAg NTQzNSAtVSBteXVzZXIgbXlkYXRhYmFzZSB8IGJ6aXAyIC1jIC16ID4KZHVtcC1kYXRhLnNxbC5i ejINCg0KVGhpcyBpcyBob3cgSSByZXN0b3JlIGR1bXBzIG9uIGVtcHR5ICJ0YXJnZXQiIHNlcnZl cjoNCiQgZ3JlcCAtRWl2ICcoQ1JFQVRFIFJPTEUgcG9zdGdyZXN8QUxURVIgUk9MRSBwb3N0Z3Jl cyAuKlBBU1NXT1JEKScKZHVtcC1yb2xlLnNxbCB8IHBzcWwgLVVwb3N0Z3JlcyA+IC9kZXYvbnVs bA0KJCBwc3FsIC1VcG9zdGdyZXMgLWYgZHVtcC1kYXRhLnNxbCA+IC9kZXYvbnVsbA0KDQooYGdy ZXBgIG9uIHRoZSBmaXJzdCBjb21tYW5kIGlzIHVzZWQgdG8gbGVmdCAicG9zdGdyZXMiIHN1cGVy dXNlciB1bnRvdWNoZWQKb24gYSB0YXJnZXQgc2VydmVyLikNCg0KV2hlbiByZXN0b3JpbmcgZnJv bSBkdW1wLCBJIGdvdCB0d28gZXJyb3JzOg0KcHNxbDovcGF0aC90by9kdW1wLWRhdGEuc3FsOjE4 ODMxNzkxOiBFUlJPUjogIHBvbGljeSAiY3Jvbl9qb2JfcG9saWN5IiBmb3IKdGFibGUgImpvYiIg YWxyZWFkeSBleGlzdHMNCnBzcWw6L3BhdGgvdG8vZHVtcC1kYXRhLnNxbDoxODgzMTc5ODogRVJS T1I6ICBwb2xpY3kKImNyb25fam9iX3J1bl9kZXRhaWxzX3BvbGljeSIgZm9yIHRhYmxlICJqb2Jf cnVuX2RldGFpbHMiIGFscmVhZHkgZXhpc3RzDQoNClRoZXkgcmVmZXJzIHRvIHRoZSBmb2xsb3dp bmcgbGluZXMgb2YgZHVtcDoNCi0tIE5hbWU6IGpvYiBjcm9uX2pvYl9wb2xpY3k7IFR5cGU6IFBP TElDWTsgU2NoZW1hOiBjcm9uOyBPd25lcjogc29tZV91c2VyDQpDUkVBVEUgUE9MSUNZIGNyb25f am9iX3BvbGljeSBPTiBjcm9uLmpvYiBVU0lORyAoKHVzZXJuYW1lID0KQ1VSUkVOVF9VU0VSKSk7 DQotLSBOYW1lOiBqb2JfcnVuX2RldGFpbHMgY3Jvbl9qb2JfcnVuX2RldGFpbHNfcG9saWN5OyBU eXBlOiBQT0xJQ1k7IFNjaGVtYToKY3JvbjsgT3duZXI6IHNvbWVfdXNlcg0KQ1JFQVRFIFBPTElD WSBjcm9uX2pvYl9ydW5fZGV0YWlsc19wb2xpY3kgT04gY3Jvbi5qb2JfcnVuX2RldGFpbHMgVVNJ TkcKKCh1c2VybmFtZSA9IENVUlJFTlRfVVNFUikpOw0KDQpJIG5ldmVyIGNyZWF0ZWQgdGhvc2Ug UE9MSUNZIGJ5IGhhbmRzIG9uICJzb3VyY2UiIGRhdGFiYXNlLiBUaGUgZ3Vlc3MgaXMKKEBzZWUg aHR0cHM6Ly9kYmEuc3RhY2tleGNoYW5nZS5jb20vYS8zMzExOTgvODI0NjMpIHRoYXQgJ0NSRUFU RSBFWFRFTlNJT04KLi4uIHBnX2Nyb24gLi4uJyBzdGF0ZW1lbnQgaW4gdGhlIGR1bXAgZmlsZSBp cyBpbXBsaWNpdGx5IGV4ZWN1dGVzIFBPTElDWQpjcmVhdGlvbiwgc28gJ0NSRUFURSBQT0xJQ1kg Li4uIE9OIGNyb24uLi4nIHN0YXRlbWVudHMgaW4gdGhlIGR1bXAgZmlsZSBhcmUKcmVkdW5kYW50 IGFuZCB1bm5lY2Vzc2FyeS4NCg0KU2hvdWxkIHdlIGNvbnNpZGVyIHRoaXMgYXMgcGdfZHVtcCBi dWc/DQoNClNvdXJjZSBzZXJ2ZXI6DQojIGdyZXAgUFJFVFRZX05BTUUgL2V0Yy8qcmVsKg0KUFJF VFRZX05BTUU9IkRlYmlhbiBHTlUvTGludXggMTIgKGJvb2t3b3JtKSINCg0KIyBwc3FsIC1WDQpw c3FsIChQb3N0Z3JlU1FMKSAxNS4zIChEZWJpYW4gMTUuMy0xLnBnZGcxMjArMSkNCg0KIyBkcGtn IC1sIHwgZ3JlcCBwb3N0Z3Jlc3FsDQppaSAgcG9zdGdyZXNxbC0xNSAgICAgICAgICAgICAgICAg ICAxNS4zLTEucGdkZzEyMCsxICAgICAgICAgICAgICAgYW1kNjQgICAgCiANCmlpICBwb3N0Z3Jl c3FsLTE1LWNyb24gICAgICAgICAgICAgIDEuNS4yLTEucGdkZzEyMCsxICAgICAgICAgICAgICBh bWQ2NCAgCg0KaWkgIHBvc3RncmVzcWwtY2xpZW50LTEwICAgICAgICAgICAgMTAuMjMtMS5wZ2Rn MTIwKzErYjIgICAgICAgICAgIGFtZDY0DQppaSAgcG9zdGdyZXNxbC1jbGllbnQtMTEgICAgICAg ICAgICAxMS4yMC0xLnBnZGcxMjArMSAgICAgICAgICAgICAgYW1kNjQgICAKDQppaSAgcG9zdGdy ZXNxbC1jbGllbnQtMTIgICAgICAgICAgICAxMi4xNS0xLnBnZGcxMjArMSAgICAgICAgICAgICAg YW1kNjQgIAoNCmlpICBwb3N0Z3Jlc3FsLWNsaWVudC0xMyAgICAgICAgICAgIDEzLjExLTEucGdk ZzEyMCsxICAgICAgICAgICAgICBhbWQ2NCAgCg0KaWkgIHBvc3RncmVzcWwtY2xpZW50LTE0ICAg ICAgICAgICAgMTQuOC0xLnBnZGcxMjArMSAgICAgICAgICAgICAgIGFtZDY0ICAgCg0KaWkgIHBv c3RncmVzcWwtY2xpZW50LTE1ICAgICAgICAgICAgMTUuMy0xLnBnZGcxMjArMSAgICAgICAgICAg ICAgIGFtZDY0ICAgCg0KaWkgIHBvc3RncmVzcWwtY2xpZW50LWNvbW1vbiAgICAgICAgMjUwLnBn ZGcxMjArMSAgICAgICAgICAgICAgICAgIGFsbCAgICAgIAoNCmlpICBwb3N0Z3Jlc3FsLWNvbW1v biAgICAgICAgICAgICAgIDI1MC5wZ2RnMTIwKzEgICAgICAgICAgICAgICAgICBhbGwgICAgICAK ICAgDQppaSAgcG9zdGdyZXNxbC1wbHB5dGhvbjMtMTUgICAgICAgICAxNS4zLTEucGdkZzEyMCsx ICAgICAgICAgICAgICAgYW1kNjQgICAKDQppaSAgcG9zdGdyZXNxbC1zZXJ2ZXItZGV2LTEwICAg ICAgICAxMC4yMy0xLnBnZGcxMjArMStiMiAgICAgICAgICAgYW1kNjQNCmlpICBwb3N0Z3Jlc3Fs LXNlcnZlci1kZXYtMTEgICAgICAgIDExLjIwLTEucGdkZzEyMCsxICAgICAgICAgICAgICBhbWQ2 NCAgCg0KaWkgIHBvc3RncmVzcWwtc2VydmVyLWRldi0xMiAgICAgICAgMTIuMTUtMS5wZ2RnMTIw KzEgICAgICAgICAgICAgIGFtZDY0ICANCmlpICBwb3N0Z3Jlc3FsLXNlcnZlci1kZXYtMTMgICAg ICAgIDEzLjExLTEucGdkZzEyMCsxICAgICAgICAgICAgICBhbWQ2NCAgDQppaSAgcG9zdGdyZXNx bC1zZXJ2ZXItZGV2LTE0ICAgICAgICAxNC44LTEucGdkZzEyMCsxICAgICAgICAgICAgICAgYW1k NjQgIAoNCmlpICBwb3N0Z3Jlc3FsLXNlcnZlci1kZXYtMTUgICAgICAgIDE1LjMtMS5wZ2RnMTIw KzEgICAgICAgICAgICAgICBhbWQ2NCAgCg0KaWkgIHBvc3RncmVzcWwtc2VydmVyLWRldi1hbGw6 YW1kNjQgMjUwLnBnZGcxMjArMSAgICAgICAgICAgICAgICAgIGFtZDY0DQoNClRhcmdldCBzZXJ2 ZXI6DQojIGdyZXAgUFJFVFRZX05BTUUgL2V0Yy8qcmVsKg0KUFJFVFRZX05BTUU9IkRlYmlhbiBH TlUvTGludXggMTIgKGJvb2t3b3JtKSINCg0KIyBwc3FsIC1WDQpwc3FsIChQb3N0Z3JlU1FMKSAx NS40IChEZWJpYW4gMTUuNC0xLnBnZGcxMjArMSkNCg0KIyBkcGtnIC1sIHwgZ3JlcCBwb3N0Z3Jl c3FsDQppaSAgcG9zdGdyZXNxbC0xNSAgICAgICAgICAgICAgICAgICAxNS40LTEucGdkZzEyMCsx ICAgICAgICAgICAgICAgYW1kNjQgICAgCiANCmlpICBwb3N0Z3Jlc3FsLTE1LWNyb24gICAgICAg ICAgICAgIDEuNS4yLTIucGdkZzEyMCsyICAgICAgICAgICAgICBhbWQ2NCAgCg0KaWkgIHBvc3Rn cmVzcWwtY2xpZW50LTE1ICAgICAgICAgICAgMTUuNC0xLnBnZGcxMjArMSAgICAgICAgICAgICAg IGFtZDY0ICAgCg0KaWkgIHBvc3RncmVzcWwtY2xpZW50LWNvbW1vbiAgICAgICAgMjUzLnBnZGcx MjArMSAgICAgICAgICAgICAgICAgIGFsbCAgICAgIAoNCmlpICBwb3N0Z3Jlc3FsLWNvbW1vbiAg ICAgICAgICAgICAgIDI1My5wZ2RnMTIwKzEgICAgICAgICAgICAgICAgICBhbGwgICAgICAKICAg DQppaSAgcG9zdGdyZXNxbC1wbHB5dGhvbjMtMTUgICAgICAgICAxNS40LTEucGdkZzEyMCsxICAg ICAgICAgICAgICAgYW1kNjQNCmlpICBwb3N0Z3Jlc3FsLXNlcnZlci1kZXYtMTUgICAgICAgIDE1 LjQtMS5wZ2RnMTIwKzEgICAgICAgICAgICAgICBhbWQ2NAoK --===============2383555306568135683==--