Opened 10 years ago
Closed 10 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.
Note:
See TracTickets
for help on using tickets.
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).