I am unable to restore a database backup when the database contains schema's that contain geometry datatypes or postgis functions.
During restore, I get the spatial_ref_sys relation not found error. The backup file that pg_dump sets search paths that do not include the public schema.
Is there a way to produce a file that is restorable? Or will the backup file always require manual modification of the
SET search_path = statement?