Larry Rosenman <l...@lerctr.org> writes:
> On Fri, Jul 06, 2018 at 11:35:41AM -0700, Joshua D. Drake wrote:
>> Knowing the errors would be helpful.
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error from TOC entry 12; 3079 887963 EXTENSION
> postgis_tiger_geocoder
> pg_restore: [archiver (db)] could not execute query: ERROR: function
> soundex(character varying) does not exist
> HINT: No function matches the given name and argument types. You might need
> to add explicit type casts.
This looks like a problem with the postgis_tiger_geocoder extension.
It's depending on the fuzzystrmatch extension (which has the soundex
function), but seemingly this dependency is not declared in the
extension's control file. If it were, the search path would've been
set to include the schema of the fuzzystrmatch extension during
CREATE EXTENSION.
regards, tom lane
