[PATCH] pgarchives: Fix database install procedure: remove redundant tables in schema.sql

From: Célestin Matte <celestin(dot)matte(at)cmatte(dot)me>
To: PostgreSQL WWW <pgsql-www(at)lists(dot)postgresql(dot)org>
Subject: [PATCH] pgarchives: Fix database install procedure: remove redundant tables in schema.sql
Date: 2021-10-18 16:19:25
Message-ID: d6edac7f-c882-9531-f223-7899e5d93123@cmatte.me
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-www

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

Attachment Content-Type Size
0001-Fix-database-install-procedure-remove-redundant-tabl.patch text/x-patch 3.0 KB

Responses

Browse pgsql-www by date

  From Date Subject
Next Message Célestin Matte 2021-10-22 14:59:17 [PATCH] pgweb: Search: bugfix: replace sites.baseurl with sites.hostname
Previous Message Daniel Gustafsson 2021-10-15 12:15:31 Re: GSoC page under /developer is out of date