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|
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 by , 10 years ago
|Status:||new → closed|
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).