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 1mcVMM-0006FT-Vw for pgsql-www@arkaria.postgresql.org; Mon, 18 Oct 2021 16:19:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mcVML-0006Hl-CM for pgsql-www@arkaria.postgresql.org; Mon, 18 Oct 2021 16:19:33 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mcVML-0006Hc-3q for pgsql-www@lists.postgresql.org; Mon, 18 Oct 2021 16:19:33 +0000 Received: from ploudseeker.com ([78.199.165.48]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mcVMH-0006P5-MB for pgsql-www@lists.postgresql.org; Mon, 18 Oct 2021 16:19:32 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=cmatte.me; s=myselector; t=1634573966; bh=SUOC+lX05NYlkfBrF19528eKyrzmNAKUxU0o76gzycQ=; h=Date:To:From:Subject; b=Kz7NTpeFH1KMpbJN3T58zJWyLkJOc+1dCMOir5YffABuPYGCiiRt/b2R+7vLqSpXA bX6DdoKSs8NS5/AI5FWh7l8Wdccf5J7VPrgtLfifyHRzBzwl4MVag7pj8oGYeIv7Dk 45KlAi+HGt8sLm3cVBvTPxmBONdaJRXWSwBRxlPNa8eI7bjIB0ezUblRHpD5d/6VBp O2Mff1Fp6KS/+v8al6gJ2xGucv3Xg2SS+WhMdIdlGzEK6TZ7d3Vk9Q1qhMxhKOIQQ/ XwZZhkra3bL/PLi8JRdCzacaknFS8uU5jwIVpY8IIZ7cUqfr1W9nxa1OG0YhXA3tYQ GTU66vlZz03gw== Content-Type: multipart/mixed; boundary="------------QchnSPko0RvKEm2IeTs4Vm4L" Message-ID: Date: Mon, 18 Oct 2021 18:19:25 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.2.0 To: PostgreSQL WWW Content-Language: en-US From: =?UTF-8?Q?C=c3=a9lestin_Matte?= Subject: [PATCH] pgarchives: Fix database install procedure: remove redundant tables in schema.sql List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------QchnSPko0RvKEm2IeTs4Vm4L Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Hello, While installing pgarchives, I've encountered issues that are addressed in this patch. Django's model and schema.sql both contain tables that are necessary for the execution of the application, but are mutually exclusive. This is due to some fields in the "messages" table that cannot be defined in django, and definition of tables in schema.sql that are already created by django. Additionally, I have two questions: - Where is the "tsparser" parser defined? (See commit e05f813b of pgarchives). It is used in schema.sql, but I haven't found its definition in the pgarchives, pglister or pgweb repositories. Is it an alias to pg_catalog.pg_ts_parser? (I have been able to complete the install procedure by reverting e05f813b, but I have no idea what the consequences are for the application) - Same question for /usr/share/postgresql/12/tsearch_data/pg_dict.stop I've found pg_dict.syn in pgweb, but not this file. Cheers, -- Célestin Matte --------------QchnSPko0RvKEm2IeTs4Vm4L Content-Type: text/x-patch; charset=UTF-8; name="0001-Fix-database-install-procedure-remove-redundant-tabl.patch" Content-Disposition: attachment; filename*0="0001-Fix-database-install-procedure-remove-redundant-tabl.pa"; filename*1="tch" Content-Transfer-Encoding: base64 RnJvbSA1OGFmOTVhODlmMDhlN2JkOTRiNzM4MDEzZmVjYmU2YzgwMzBjZmYxIE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiA9P1VURi04P3E/Qz1DMz1BOWxlc3Rpbj0yME1hdHRl Pz0gPGdpdGxhYkBjbWF0dGUubWU+CkRhdGU6IE1vbiwgMTggT2N0IDIwMjEgMTg6MDQ6Mzcg KzAyMDAKU3ViamVjdDogW1BBVENIXSBGaXggZGF0YWJhc2UgaW5zdGFsbCBwcm9jZWR1cmU6 IHJlbW92ZSByZWR1bmRhbnQgdGFibGVzIGluCiBzY2hlbWEuc3FsCgpEamFuZ28ncyBtb2Rl bCBhbmQgc2NoZW1hLnNxbCBib3RoIGNvbnRhaW4gdGFibGVzIHRoYXQgYXJlIG5lY2Vzc2Fy eSBmb3IKdGhlIGV4ZWN1dGlvbiBvZiB0aGUgYXBwbGljYXRpb24sIGJ1dCBhcmUgbXV0dWFs bHkgZXhjbHVzaXZlLgpUaGlzIGlzIGR1ZSB0byBzb21lIGZpZWxkcyBpbiB0aGUgIm1lc3Nh Z2VzIiB0YWJsZSB0aGF0IGNhbm5vdCBiZSBkZWZpbmVkIGluCmRqYW5nbywgYW5kIGRlZmlu aXRpb24gb2YgdGFibGVzIGluIHNjaGVtYS5zcWwgdGhhdCBhcmUgYWxyZWFkeSBjcmVhdGVk CmJ5IGRqYW5nby4KLS0tCiBsb2FkZXIvc3FsL3NjaGVtYS5zcWwgfCA0OSArKysrLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCiAxIGZpbGUgY2hhbmdlZCwgNCBp bnNlcnRpb25zKCspLCA0NSBkZWxldGlvbnMoLSkKCmRpZmYgLS1naXQgYS9sb2FkZXIvc3Fs L3NjaGVtYS5zcWwgYi9sb2FkZXIvc3FsL3NjaGVtYS5zcWwKaW5kZXggZDliNWQ1Zi4uMjgz NGUxMiAxMDA2NDQKLS0tIGEvbG9hZGVyL3NxbC9zY2hlbWEuc3FsCisrKyBiL2xvYWRlci9z cWwvc2NoZW1hLnNxbApAQCAtMiwyMyArMiwxMCBAQAogCiBCRUdJTjsKIAotQ1JFQVRFIFRB QkxFIG1lc3NhZ2VzICgKLSAgIGlkIFNFUklBTCBOT1QgTlVMTCBQUklNQVJZIEtFWSwKLSAg IHBhcmVudGlkIGludCBSRUZFUkVOQ0VTIG1lc3NhZ2VzLAotICAgdGhyZWFkaWQgaW50IE5P VCBOVUxMLAotICAgX2Zyb20gdGV4dCBOT1QgTlVMTCwKLSAgIF90byB0ZXh0IE5PVCBOVUxM LAotICAgY2MgdGV4dCBOT1QgTlVMTCwKLSAgIHN1YmplY3QgdGV4dCBOT1QgTlVMTCwKLSAg IGRhdGUgdGltZXN0YW1wdHogTk9UIE5VTEwsCi0gICBsb2FkZGF0ZSB0aW1lc3RhbXB0eiBO T1QgTlVMTCBERUZBVUxUIENVUlJFTlRfVElNRVNUQU1QLAotICAgaGFzX2F0dGFjaG1lbnQg Ym9vbGVhbiBOT1QgTlVMTCwKLSAgIGhpZGRlbnN0YXR1cyBpbnQgTlVMTCwKLSAgIG1lc3Nh Z2VpZCB0ZXh0IE5PVCBOVUxMLAotICAgYm9keXR4dCB0ZXh0IE5PVCBOVUxMLAotICAgcmF3 dHh0IGJ5dGVhIE5PVCBOVUxMLAotICAgZnRpIHRzdmVjdG9yIE5PVCBOVUxMCi0pOworQUxU RVIgVEFCTEUgbWVzc2FnZXMKKyAgIEFERCBDT0xVTU4gcmF3dHh0IGJ5dGVhIE5PVCBOVUxM LAorICAgQUREIENPTFVNTiBmdGkgdHN2ZWN0b3IgTk9UIE5VTEw7CisKIENSRUFURSBJTkRF WCBpZHhfbWVzc2FnZXNfdGhyZWFkaWQgT04gbWVzc2FnZXModGhyZWFkaWQpOwogQ1JFQVRF IFVOSVFVRSBJTkRFWCBpZHhfbWVzc2FnZXNfbXNnaWQgT04gbWVzc2FnZXMobWVzc2FnZWlk KTsKIENSRUFURSBJTkRFWCBpZHhfbWVzc2FnZXNfZGF0ZSBPTiBtZXNzYWdlcyhkYXRlKTsK QEAgLTQyLDIxICsyOSw2IEBAIENSRUFURSBUQUJMRSB1bnJlc29sdmVkX21lc3NhZ2VzKAog CiBDUkVBVEUgVU5JUVVFIElOREVYIGlkeF91bnJlc29sdmVkX21zZ2lkX21lc3NhZ2UgT04g dW5yZXNvbHZlZF9tZXNzYWdlcyhtc2dpZCwgbWVzc2FnZSk7CiAKLUNSRUFURSBUQUJMRSBs aXN0Z3JvdXBzKAotICAgZ3JvdXBpZCBpbnQgTk9UIE5VTEwgUFJJTUFSWSBLRVksCi0gICBn cm91cG5hbWUgdGV4dCBOT1QgTlVMTCBVTklRVUUsCi0gICBzb3J0a2V5IGludCBOT1QgTlVM TAotKTsKLQotQ1JFQVRFIFRBQkxFIGxpc3RzKAotICAgbGlzdGlkIGludCBOT1QgTlVMTCBQ UklNQVJZIEtFWSwKLSAgIGxpc3RuYW1lIHRleHQgTk9UIE5VTEwgVU5JUVVFLAotICAgc2hv cnRkZXNjIHRleHQgTk9UIE5VTEwsCi0gICBkZXNjcmlwdGlvbiB0ZXh0IE5PVCBOVUxMLAot ICAgYWN0aXZlIGJvb2xlYW4gTk9UIE5VTEwsCi0gICBncm91cGlkIGludCBOT1QgTlVMTCBS RUZFUkVOQ0VTIGxpc3Rncm91cHMoZ3JvdXBpZCkKLSk7Ci0KIENSRUFURSBUQUJMRSBsaXN0 X21vbnRocygKICAgIGxpc3RpZCBpbnQgTk9UIE5VTEwgUkVGRVJFTkNFUyBsaXN0cyhsaXN0 aWQpLAogICAgeWVhciBpbnQgTk9UIE5VTEwsCkBAIC03MSwxMyArNDMsNiBAQCBDUkVBVEUg VEFCTEUgbGlzdF90aHJlYWRzKAogKTsKIENSRUFURSBJTkRFWCBsaXN0X3RocmVhZHNfbGlz dGlkX2lkeCBPTiBsaXN0X3RocmVhZHMobGlzdGlkKTsKIAotQ1JFQVRFIFRBQkxFIGF0dGFj aG1lbnRzKAotICAgaWQgc2VyaWFsIG5vdCBudWxsIHByaW1hcnkga2V5LAotICAgbWVzc2Fn ZSBpbnQgbm90IG51bGwgcmVmZXJlbmNlcyBtZXNzYWdlcyhpZCksCi0gICBmaWxlbmFtZSB0 ZXh0IG5vdCBudWxsLAotICAgY29udGVudHR5cGUgdGV4dCBub3QgbnVsbCwKLSAgIGF0dGFj aG1lbnQgYnl0ZWEgbm90IG51bGwKLSk7CiBDUkVBVEUgSU5ERVggaWR4X2F0dGFjaG1lbnRz X21zZyBPTiBhdHRhY2htZW50cyhtZXNzYWdlKTsKIAogQ1JFQVRFIFRBQkxFIGFwaWNsaWVu dHMoCkBAIC04NiwxMiArNTEsNiBAQCBDUkVBVEUgVEFCTEUgYXBpY2xpZW50cygKICAgIHBv c3RiYWNrIHZhcmNoYXIoNTAwKSBOT1QgTlVMTAogKTsKIAotQ1JFQVRFIFRBQkxFIHRocmVh ZHN1YnNjcmlwdGlvbnMoCi0gICBpZCBTRVJJQUwgTk9UIE5VTEwgUFJJTUFSWSBLRVksCi0g ICBhcGljbGllbnRfaWQgaW50ZWdlciBOT1QgTlVMTCBSRUZFUkVOQ0VTIGFwaWNsaWVudHMo aWQpLAotICAgdGhyZWFkaWQgaW50ZWdlciBOT1QgTlVMTAotKTsKLQogQ1JFQVRFIFRBQkxF IHRocmVhZG5vdGlmaWNhdGlvbnMoCiAgICBhcGljbGllbnRfaWQgaW50ZWdlciBOT1QgTlVM TCBSRUZFUkVOQ0VTIGFwaWNsaWVudHMoaWQpLAogICAgdGhyZWFkaWQgaW50ZWdlciBOT1Qg TlVMTCwKLS0gCjIuMzMuMQoK --------------QchnSPko0RvKEm2IeTs4Vm4L--