Thread: BUG #15264: pg_dump / psql failure. When loading,psql fails to create TEXT SEARCH dictionaries.
BUG #15264: pg_dump / psql failure. When loading,psql fails to create TEXT SEARCH dictionaries.
From
PG Bug reporting form
Date:
The following bug has been logged on the website: Bug reference: 15264 Logged by: Brian Ceccarelli Email address: ceccareb@talusmusic.com PostgreSQL version: 10.4 Operating system: Red Hat Enterprise Linux 7.5 Description: I create several text search dictionaries which point to my own stemmers. When I pg_dump the database, a subsequent psql to load the database fails to recreate them. My files exist, but psql shows. CREATE TEXT SEARCH DICTIONARY psql:10dollar.dmp:208298: ERROR: text search dictionary "net32_en_us_no_stop_stemmer" does not exist CREATE TEXT SEARCH CONFIGURATION psql:10dollar.dmp:208309: ERROR: text search dictionary "public.net32_en_us_thesaurus" does not exist psql:10dollar.dmp:208312: ERROR: text search dictionary "public.net32_en_us_thesaurus" does not exist ALTER TEXT SEARCH CONFIGURATION ALTER TEXT SEARCH CONFIGURATION ALTER TEXT SEARCH CONFIGURATION ALTER TEXT SEARCH CONFIGURATION ALTER TEXT SEARCH CONFIGURATION ALTER TEXT SEARCH CONFIGURATION ALTER TEXT SEARCH CONFIGURATION psql:10dollar.dmp:208336: ERROR: text search dictionary "public.net32_en_us_thesaurus" does not exist psql:10dollar.dmp:208339: ERROR: text search dictionary "public.net32_en_us_thesaurus" does not exist ALTER TEXT SEARCH CONFIGURATION psql:10dollar.dmp:208345: ERROR: text search dictionary "public.net32_en_us_thesaurus" does not exist psql:10dollar.dmp:208348: ERROR: text search dictionary "public.net32_en_us_thesaurus" does not exist ALTER TEXT SEARCH CONFIGURATION -------------------------- A Postgres 9.6.2 to Postgres 10.4 does not fail when I use v9's pg_dump command. v9's pg_dump loads successfully to a Postgres 10.4 DB. When I use Postgres's 10.4 pg_dump, then I get subsequent load failures.