BUG #15264: pg_dump / psql failure. When loading, psql fails to create TEXT SEARCH dictionaries.

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: ceccareb(at)talusmusic(dot)com
Subject: BUG #15264: pg_dump / psql failure. When loading, psql fails to create TEXT SEARCH dictionaries.
Date: 2018-07-06 17:04:56
Message-ID: 153089669666.1408.7757864075370381214@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15264
Logged by: Brian Ceccarelli
Email address: ceccareb(at)talusmusic(dot)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.

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2018-07-06 18:10:47 BUG #15265: The program "initdb" is needed by pg_ctl but was not found in the same directory as "pg_ctl".
Previous Message PG Bug reporting form 2018-07-06 16:19:06 BUG #15263: pg_dump / psql failure. When loading, psql does not see function-based constraints or indices