Re: pg_upgrade fails saying function unaccent(text) doesn't exist

2018-08-31 Thread Adrian Klaver
On 08/30/2018 09:03 AM, Gunnlaugur Thor Briem wrote: \dFd unaccent List of text search dictionaries  Schema |   Name   | Description +--+-  public | unaccent | (1 row) \dFd+ unaccent     List of text search dictionaries  Schema |   Name   |    Temp

Re: pg_upgrade fails saying function unaccent(text) doesn't exist

2018-08-31 Thread Adrian Klaver
On 08/30/2018 09:03 AM, Gunnlaugur Thor Briem wrote: \dFd unaccent List of text search dictionaries  Schema |   Name   | Description +--+-  public | unaccent | (1 row) \dFd+ unaccent     List of text search dictionaries  Schema |   Name   |    Temp

Re: pg_upgrade fails saying function unaccent(text) doesn't exist

2018-08-30 Thread Gunnlaugur Thor Briem
\dFd unaccent List of text search dictionaries Schema | Name | Description +--+- public | unaccent | (1 row) \dFd+ unaccent List of text search dictionaries Schema | Name |Template |Init options| Description +--

Re: pg_upgrade fails saying function unaccent(text) doesn't exist

2018-08-30 Thread Adrian Klaver
On 08/30/2018 02:24 AM, Gunnlaugur Thor Briem wrote: Thank you! That got the pg_upgrade to completion. But then during ./analyze_new_cluster.sh vacuum fails thus: vacuumdb: processing database "dm_test": Generating minimal optimizer statistics (1 target) vacuumdb: vacuuming of database "dm_tes

Re: pg_upgrade fails saying function unaccent(text) doesn't exist

2018-08-30 Thread Gunnlaugur Thor Briem
Thank you! That got the pg_upgrade to completion. But then during ./analyze_new_cluster.sh vacuum fails thus: vacuumdb: processing database "dm_test": Generating minimal optimizer statistics (1 target) vacuumdb: vacuuming of database "dm_test" failed: ERROR: text search dictionary "unaccent" does

Re: pg_upgrade fails saying function unaccent(text) doesn't exist

2018-08-29 Thread Bruce Momjian
On Wed, Aug 29, 2018 at 06:09:53PM +, Gunnlaugur Thor Briem wrote: > Hi, > > I'm trying to upgrade an old PG 9.4 cluster to PG 10, and it's failing on > creating an index that uses the unaccent(text) function. > > That function is part of the unaccent extension, which is installed in the old