Opened 8 years ago

Closed 8 years ago

#2545 closed defect (wontfix)

postgis_tiger_geocoder extension restore from backup fails

Reported by: robe Owned by: robe
Priority: critical Milestone: PostGIS 2.1.2
Component: tiger geocoder Version: 2.1.x
Keywords: Cc:

Description

Just ran into this issue that when

CREATE EXTENSION postgis_tiger_geocoder;

is restored via just plain restore of backup, it fails with

ERROR: function soundex(character varying) does not exist

This might be because we have fuzzystrmatch installed in non-public schema or because tiger itself is installed in tiger so the backup might be setting schema search_path to just tiger.

Change History (1)

comment:1 Changed 8 years ago by robe

Resolution: wontfix
Status: newclosed

I did another restore first creating the database with the search_paths I had in old and then restoring and that seemed to work. So though its kind of a surprise, it is nothing we can do about easily and people need to set their search_path anyway before they run (I'm usually in habit of setting it after restore).

Note: See TracTickets for help on using tickets.