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 1rOIlN-0034F7-NZ for pgsql-bugs@arkaria.postgresql.org; Fri, 12 Jan 2024 14:44:02 +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 1rOIlM-002Rk0-2m for pgsql-bugs@arkaria.postgresql.org; Fri, 12 Jan 2024 14:44:00 +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 1rOIdm-002NzV-7y for pgsql-bugs@lists.postgresql.org; Fri, 12 Jan 2024 14:36: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 1rOIdi-001CSC-IO for pgsql-bugs@lists.postgresql.org; Fri, 12 Jan 2024 14:36: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=hx84Ft6kNiYZGedxSt3MpYftUU2aOdNYM1UKw0DRgNU=; b=ui2rB9hyqrVu3lLAyd6+QY4mzb q7MnE2sbVNo5eR07En83oaeTLUJVN25o8NqQW2iJokc50NFY7c9M2dvtKb5z/esiVJyyeULNE3kvK kaXZ9obw1Jk9sLw5ldG+L0qbT1HLW6RfCH/9pzVU2K3GL4gFR6cQ2laxLBW+8ikjoyX5cW/8f063u xHKnltu69xXZqy08efel9bDDgXAf6geHGYxwNiEsc6MTs8brCaQ30Jwb4kO/ji5mX0XbNZHS8xxDF 3gUaK5gKTVH6j59Yh+z+P7LkpHIbM47WXXezf4nDbJrjX/TeOc1sakXd0sKFCiZRdFfziYZyVs/Ut O7JMwKiA==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rOIdf-003Ydg-SC for pgsql-bugs@lists.postgresql.org; Fri, 12 Jan 2024 14:36: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 1rOIde-008qfr-Kr for pgsql-bugs@lists.postgresql.org; Fri, 12 Jan 2024 14:36:02 +0000 Content-Type: multipart/mixed; boundary="===============6098813592683976168==" MIME-Version: 1.0 Subject: BUG #18287: pg_restore with -C and -c options does not do what is said in the documentation To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: loic.seguin@hotmail.fr Reply-To: loic.seguin@hotmail.fr, pgsql-bugs@lists.postgresql.org Date: Fri, 12 Jan 2024 14:35:29 +0000 Message-ID: <18287-33f359333ba64817@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 --===============6098813592683976168== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODI4NwpMb2dnZWQgYnk6ICAgICAgICAgIExvaWMgU2VndWluCkVtYWls IGFkZHJlc3M6ICAgICAgbG9pYy5zZWd1aW5AaG90bWFpbC5mcgpQb3N0Z3JlU1FMIHZlcnNpb246 IDE0LjAKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUKRGVzY3JpcHRpb246ICAgICAgICAKCkhl bGxvLA0KDQpJIGNyZWF0ZWQgdHdvIGRhdGFiYXNlcyBvbiBsb2NhbGhvc3Qgb24gbXkgUEMuIEkg Y2FsbGVkIHRoZW0gbGlrZSB0aGlzIDogDQotIHNvdXJjZQ0KLSB0YXJnZXQNCg0KVGhlcmUgYXJl IGVtcHR5IGRhdGFiYXNlcy4NCg0KSSB3YW50IHRvIHBnX2R1bXAgdGhlIHNvdXJjZSBhbmQgcGdf cmVzdG9yZSBpbnRvIHRoZSB0YXJnZXQuDQoNCkkgZG8gdGhpcyBjb21tYW5kIDoNCg0KInBnX2R1 bXAgLWggbG9jYWxob3N0IC1VIG15X3VzZXIgLUYgYyAtZCBzb3VyY2UgLXYgLWYgZHVtcC5iaW4i DQoNCnBnX2R1bXA6IGxhc3QgYnVpbHQtaW4gT0lEIGlzIDE2MzgzDQpwZ19kdW1wOiByZWFkaW5n IGV4dGVuc2lvbnMNCnBnX2R1bXA6IGlkZW50aWZ5aW5nIGV4dGVuc2lvbiBtZW1iZXJzDQpwZ19k dW1wOiByZWFkaW5nIHNjaGVtYXMNCnBnX2R1bXA6IHJlYWRpbmcgdXNlci1kZWZpbmVkIHRhYmxl cw0KcGdfZHVtcDogcmVhZGluZyB1c2VyLWRlZmluZWQgZnVuY3Rpb25zDQpwZ19kdW1wOiByZWFk aW5nIHVzZXItZGVmaW5lZCB0eXBlcw0KcGdfZHVtcDogcmVhZGluZyBwcm9jZWR1cmFsIGxhbmd1 YWdlcw0KcGdfZHVtcDogcmVhZGluZyB1c2VyLWRlZmluZWQgYWdncmVnYXRlIGZ1bmN0aW9ucw0K cGdfZHVtcDogcmVhZGluZyB1c2VyLWRlZmluZWQgb3BlcmF0b3JzDQpwZ19kdW1wOiByZWFkaW5n IHVzZXItZGVmaW5lZCBhY2Nlc3MgbWV0aG9kcw0KcGdfZHVtcDogcmVhZGluZyB1c2VyLWRlZmlu ZWQgb3BlcmF0b3IgY2xhc3Nlcw0KcGdfZHVtcDogcmVhZGluZyB1c2VyLWRlZmluZWQgb3BlcmF0 b3IgZmFtaWxpZXMNCnBnX2R1bXA6IHJlYWRpbmcgdXNlci1kZWZpbmVkIHRleHQgc2VhcmNoIHBh cnNlcnMNCnBnX2R1bXA6IHJlYWRpbmcgdXNlci1kZWZpbmVkIHRleHQgc2VhcmNoIHRlbXBsYXRl cw0KcGdfZHVtcDogcmVhZGluZyB1c2VyLWRlZmluZWQgdGV4dCBzZWFyY2ggZGljdGlvbmFyaWVz DQpwZ19kdW1wOiByZWFkaW5nIHVzZXItZGVmaW5lZCB0ZXh0IHNlYXJjaCBjb25maWd1cmF0aW9u cw0KcGdfZHVtcDogcmVhZGluZyB1c2VyLWRlZmluZWQgZm9yZWlnbi1kYXRhIHdyYXBwZXJzDQpw Z19kdW1wOiByZWFkaW5nIHVzZXItZGVmaW5lZCBmb3JlaWduIHNlcnZlcnMNCnBnX2R1bXA6IHJl YWRpbmcgZGVmYXVsdCBwcml2aWxlZ2VzDQpwZ19kdW1wOiByZWFkaW5nIHVzZXItZGVmaW5lZCBj b2xsYXRpb25zDQpwZ19kdW1wOiByZWFkaW5nIHVzZXItZGVmaW5lZCBjb252ZXJzaW9ucw0KcGdf ZHVtcDogcmVhZGluZyB0eXBlIGNhc3RzDQpwZ19kdW1wOiByZWFkaW5nIHRyYW5zZm9ybXMNCnBn X2R1bXA6IHJlYWRpbmcgdGFibGUgaW5oZXJpdGFuY2UgaW5mb3JtYXRpb24NCnBnX2R1bXA6IHJl YWRpbmcgZXZlbnQgdHJpZ2dlcnMNCnBnX2R1bXA6IGZpbmRpbmcgZXh0ZW5zaW9uIHRhYmxlcw0K cGdfZHVtcDogZmluZGluZyBpbmhlcml0YW5jZSByZWxhdGlvbnNoaXBzDQpwZ19kdW1wOiByZWFk aW5nIGNvbHVtbiBpbmZvIGZvciBpbnRlcmVzdGluZyB0YWJsZXMNCnBnX2R1bXA6IGZsYWdnaW5n IGluaGVyaXRlZCBjb2x1bW5zIGluIHN1YnRhYmxlcw0KcGdfZHVtcDogcmVhZGluZyBwYXJ0aXRp b25pbmcgZGF0YQ0KcGdfZHVtcDogcmVhZGluZyBpbmRleGVzDQpwZ19kdW1wOiBmbGFnZ2luZyBp bmRleGVzIGluIHBhcnRpdGlvbmVkIHRhYmxlcw0KcGdfZHVtcDogcmVhZGluZyBleHRlbmRlZCBz dGF0aXN0aWNzDQpwZ19kdW1wOiByZWFkaW5nIGNvbnN0cmFpbnRzDQpwZ19kdW1wOiByZWFkaW5n IHRyaWdnZXJzDQpwZ19kdW1wOiByZWFkaW5nIHJld3JpdGUgcnVsZXMNCnBnX2R1bXA6IHJlYWRp bmcgcG9saWNpZXMNCnBnX2R1bXA6IHJlYWRpbmcgcm93LWxldmVsIHNlY3VyaXR5IHBvbGljaWVz DQpwZ19kdW1wOiByZWFkaW5nIHB1YmxpY2F0aW9ucw0KcGdfZHVtcDogcmVhZGluZyBwdWJsaWNh dGlvbiBtZW1iZXJzaGlwDQpwZ19kdW1wOiByZWFkaW5nIHN1YnNjcmlwdGlvbnMNCnBnX2R1bXA6 IHJlYWRpbmcgbGFyZ2Ugb2JqZWN0cw0KcGdfZHVtcDogcmVhZGluZyBkZXBlbmRlbmN5IGRhdGEN CnBnX2R1bXA6IHNhdmluZyBlbmNvZGluZyA9IFVURjgNCnBnX2R1bXA6IHNhdmluZyBzdGFuZGFy ZF9jb25mb3JtaW5nX3N0cmluZ3MgPSBvbg0KcGdfZHVtcDogc2F2aW5nIHNlYXJjaF9wYXRoID0g DQpwZ19kdW1wOiBzYXZpbmcgZGF0YWJhc2UgZGVmaW5pdGlvbg0KDQpUaGVuIEkgZG8gdGhpcyBj b21tYW5kIHdpdGggLUMgYW5kIC1jIG9wdGlvbnMgdG8gcmVzdG9yZSB0aGUgZHVtcCB0byB0aGUK dGFyZ2V0IGRhdGFiYXNlIDogDQoNCiJwZ19yZXN0b3JlIC1oIGxvY2FsaG9zdCAtVSBteV91c2Vy IC1DIC1jIC1kIHRhcmdldCAtdiBkdW1wLmJpbiINCg0KcGdfcmVzdG9yZTogY29ubmVjdGluZyB0 byBkYXRhYmFzZSBmb3IgcmVzdG9yZQ0KcGdfcmVzdG9yZTogZHJvcHBpbmcgREFUQUJBU0Ugc291 cmNlDQpwZ19yZXN0b3JlOiBjcmVhdGluZyBEQVRBQkFTRSAic291cmNlIg0KcGdfcmVzdG9yZTog d2hpbGUgUFJPQ0VTU0lORyBUT0M6DQpwZ19yZXN0b3JlOiBmcm9tIFRPQyBlbnRyeSAyOTc1OyAx MjYyIDEwNjUwNCBEQVRBQkFTRSBzb3VyY2UgbXlfdXNlcg0KcGdfcmVzdG9yZTogZXJyb3I6IGNv dWxkIG5vdCBleGVjdXRlIHF1ZXJ5OiBFUlJPUjogIG9wdGlvbiAibG9jYWxlIiBub3QKcmVjb2du aXplZA0KTElORSAxOiAuLi5vdXJjZSBXSVRIIFRFTVBMQVRFID0gdGVtcGxhdGUwIEVOQ09ESU5H ID0gJ1VURjgnIExPQ0FMRSA9ICcuLi4NCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICBeDQpDb21tYW5kIHdhczogQ1JFQVRFIERBVEFC QVNFIHNvdXJjZSBXSVRIIFRFTVBMQVRFID0gdGVtcGxhdGUwIEVOQ09ESU5HID0KJ1VURjgnIExP Q0FMRSA9ICdlbl9VUy51dGY4JzsNCg0KDQpwZ19yZXN0b3JlOiBlcnJvcjogY291bGQgbm90IGV4 ZWN1dGUgcXVlcnk6IEVSUk9SOiAgZGF0YWJhc2UgInNvdXJjZSIgZG9lcwpub3QgZXhpc3QNCkNv bW1hbmQgd2FzOiBBTFRFUiBEQVRBQkFTRSBzb3VyY2UgT1dORVIgVE8gbXlfdXNlcjsNCg0KcGdf cmVzdG9yZTogY29ubmVjdGluZyB0byBuZXcgZGF0YWJhc2UgInNvdXJjZSINCnBnX3Jlc3RvcmU6 IGVycm9yOiByZWNvbm5lY3Rpb24gZmFpbGVkOiBjb25uZWN0aW9uIHRvIHNlcnZlciBhdCAibG9j YWxob3N0IgooMTI3LjAuMC4xKSwgcG9ydCA1NDMyIGZhaWxlZDogRkFUQUw6ICBkYXRhYmFzZSAi c291cmNlIiBkb2VzIG5vdCBleGlzdA0KDQpUaGUgZXJyb3IgbG9nIGlzIG5vdCB3aGF0IEkgYW0g aW50ZXJlc3RlZCBpbi4NCg0KVGhlIHByb2JsZW0gaXMgdGhhdCBJIGp1c3QgZHJvcHBlZCB0aGUg ZGF0YWJhc2Ugc291cmNlIGJ1dCBJIHRob3VnaHQgdGhlCnRhcmdldCBkYXRhYmFzZSB3aWxsIGJl IGRyb3BwZWQgYmVjYXVzZSBvZiB0aGUgZG9jdW1lbnRhdGlvbi4NCg0KSW5kZWVkIGluIHRoZSBk b2N1bWVudGF0aW9uIHN0YXRlZCBoZXJlCmh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3Mv Y3VycmVudC9hcHAtcGdyZXN0b3JlLmh0bWwuIFRoZSAtQyBvcHRpb24gb2YKcGdfcmVzdG9yZSBz YXlzIDogDQoNCiJDcmVhdGUgdGhlIGRhdGFiYXNlIGJlZm9yZSByZXN0b3JpbmcgaW50byBpdC4g SWYgLS1jbGVhbiBpcyBhbHNvIHNwZWNpZmllZCwKZHJvcCBhbmQgcmVjcmVhdGUgdGhlIHRhcmdl dCBkYXRhYmFzZSBiZWZvcmUgY29ubmVjdGluZyB0byBpdC4NCg0KV2l0aCAtLWNyZWF0ZSwgcGdf cmVzdG9yZSBhbHNvIHJlc3RvcmVzIHRoZSBkYXRhYmFzZSdzIGNvbW1lbnQgaWYgYW55LCBhbmQK YW55IGNvbmZpZ3VyYXRpb24gdmFyaWFibGUgc2V0dGluZ3MgdGhhdCBhcmUgc3BlY2lmaWMgdG8g dGhpcyBkYXRhYmFzZSwgdGhhdAppcywgYW55IEFMVEVSIERBVEFCQVNFIC4uLiBTRVQgLi4uIGFu ZCBBTFRFUiBST0xFIC4uLiBJTiBEQVRBQkFTRSAuLi4gU0VUCi4uLiBjb21tYW5kcyB0aGF0IG1l bnRpb24gdGhpcyBkYXRhYmFzZS4gQWNjZXNzIHByaXZpbGVnZXMgZm9yIHRoZSBkYXRhYmFzZQpp dHNlbGYgYXJlIGFsc28gcmVzdG9yZWQsIHVubGVzcyAtLW5vLWFjbCBpcyBzcGVjaWZpZWQuDQoN CldoZW4gdGhpcyBvcHRpb24gaXMgdXNlZCwgdGhlIGRhdGFiYXNlIG5hbWVkIHdpdGggLWQgaXMg dXNlZCBvbmx5IHRvIGlzc3VlCnRoZSBpbml0aWFsIERST1AgREFUQUJBU0UgYW5kIENSRUFURSBE QVRBQkFTRSBjb21tYW5kcy4gQWxsIGRhdGEgaXMgcmVzdG9yZWQKaW50byB0aGUgZGF0YWJhc2Ug bmFtZSB0aGF0IGFwcGVhcnMgaW4gdGhlIGFyY2hpdmUuIg0KDQpJZiB5b3UgYW5hbHl6ZSB0aGUg bG9nIGFib3ZlIHlvdSBjYW4gc2VlIHRoYXQgdGhlIGRhdGFiYXNlIHRoYXQgaXMgZHJvcHBlZApp cyBub3QgdGhlIG9uZSB1c2VkIGFmdGVyIHRoZSAtZCBvcHRpb24gYnV0IHRoZSBvbmUgaW4gdGhl IGR1bXAgZmlsZS4NCg0KU28gSSB0aGluayBpdCBpcyBhbiBlcnJvciBpbiB0aGUgZGVzY3JpcHRp b24gb2YgdGhlIG9wdGlvbiAtQyBubyA/DQoNCk9yIG1heWJlIEkgZG9uJ3QgdW5kZXJzdGFuZCBt YXliZSB0aGUgZGVzY3JpcHRpb24gYnV0IGl0IGFsc28gc2F5cyBhYm92ZQ0KIklmIC0tY2xlYW4g aXMgYWxzbyBzcGVjaWZpZWQsIGRyb3AgYW5kIHJlY3JlYXRlIHRoZSB0YXJnZXQgZGF0YWJhc2Ug YmVmb3JlCmNvbm5lY3RpbmcgdG8gaXQuIg0KDQpJdCBpcyBjbGVhcmx5IHN0YXRlZCAidGFyZ2V0 IiBoZXJlIG5vdCB0aGUgc291cmNlIGRhdGFiYXNlLgoK --===============6098813592683976168==--