From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | mr(dot)kovalchuk(dot)andrey(at)gmail(dot)com |
Subject: | BUG #15382: Error create dictionary in pg_dump |
Date: | 2018-09-13 03:42:40 |
Message-ID: | 153681016068.22333.14472119446449542505@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: 15382
Logged by: Андрей Ковальчук
Email address: mr(dot)kovalchuk(dot)andrey(at)gmail(dot)com
PostgreSQL version: 10.5
Operating system: Ubuntu 16.04
Description:
Hello!
I need for dump my database and i used command:
/usr/lib/postgresql/10/bin/pg_dump" --host /tmp --port 50432 --username
postgres --schema-only --quote-all-identifiers --binary-upgrade
--format=custom --file="pg_upgrade_dump_2678369.custom" 'dbname=apteka25'
>> "pg_upgrade_dump_2678369.log" 2>&1
Dump is creates, but have one trouble. Result of using pg_resote command:
pg_restore: создаётся TEXT SEARCH DICTIONARY "public.ispell_apteka25"
pg_restore: создаётся TEXT SEARCH DICTIONARY "public.ispell_russian"
pg_restore: создаётся TEXT SEARCH DICTIONARY "public.simple_apteka25"
pg_restore: создаётся TEXT SEARCH DICTIONARY "public.synonym_apteka25"
pg_restore: создаётся TEXT SEARCH DICTIONARY "public.thesaurus_apteka25"
pg_restore: [архиватор (БД)] Ошибка при обработке оглавления:
pg_restore: [архиватор (БД)] Ошибка из записи оглавления 2125; 3600 2618599
TEXT SEARCH DICTIONARY thesaurus_apteka25 postgres
pg_restore: [архиватор (БД)] could not execute query: ОШИБКА (Error):
словарь текстового поиска (text search dictionary) "ispell_apteka25" не
существует (not exists)
Выполнялась команда (running command): CREATE TEXT SEARCH DICTIONARY
"public"."thesaurus_apteka25" (
TEMPLATE = "pg_catalog"."thesaurus",
dictfile = 'apteka25', dictionary = 'ispell_apteka25' );
If i change argument dictionary for this note to: dictionary =
'public.ispell_apteka25' - it's now ok!
Chage dump file - not my way. How i can fix it? Or it's really bug?
I find this problen also in 9.5v.
Thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Munro | 2018-09-13 04:22:31 | Re: BUG #15350: Getting invalid cache ID: 11 Errors |
Previous Message | kalyani kaniganti | 2018-09-13 02:07:17 | Re: BUG #15376: Postgres sql 9.4.19 pg_upgrade stops with error The source cluster was not shut down cleanly. |