On Fri, Jun 15, 2012 at 04:15:57PM +0100, Daniele Varrazzo wrote: > Hello, > > pg_upgrade fails on missing FTS dictionaries requiring external files. > --check fails to detect the incompatibility. > > E.g. after installed italian_fts (http://pgxn.org/dist/italian_fts/) > into a database, the pg_upgrade_dump_db.sql contains the command: > > CREATE TEXT SEARCH DICTIONARY italian_ispell ( > TEMPLATE = pg_catalog.ispell, > dictfile = 'italian_ispell', afffile = 'italian_ispell', stopwords > = 'italian_ispell' ); > > that fails with a: > > psql:/var/lib/postgresql/pg_upgrade_dump_db.sql:56891: ERROR: could > not open dictionary file > "/usr/share/postgresql/9.1/tsearch_data/italian_ispell.dict": No such > file or directory > > I think it would be enough to detect the incompatibility at --check > time, as much as it's done for the required libraries, and only for > the builtin dict types. > > If you want the issue to be fixed I can try to fix it myself: it seems > easy enough.
Sure, we can test for that. What system column stores these file names? Do we have any other file references in our system tables? -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
