Topology search_path lost on dump/restore

[strk]

I'm not sure this is to be considered a bug, but as we make an effort to add "topology" schema to the search_path it's annoying that the path is lost on dump/restore.

See ​https://trac.osgeo.org/postgis/ticket/3444#comment:11 for a possible consequence.

I wonder if we should make "postgis_restore.pl" take care of this, for example.

[strk]

Hint from ​irc://irc.freenode.org/#postgresql

< Zr40> if you set that per-database or per-user, pg_dumpall --globals-only would include it
< strk> Zr40: so, any way to include it in a single-database dump ?
< Zr40> strk: no, pg_dump doesn't include it
< Zr40> strk: I'd add it as a separate preparation step for your tests after restoring

[strk]

(In [14655]) Re-append "topology" schema on restore, with —dumprestore

See #3454

[strk]

(In [14656]) Re-append "topology" schema on restore, with —dumprestore

See #3454

[strk]

Closing as it's not a bug (but something to keep in mind). With r14655 (trunk) and r14656 (2.2 branch) I've made run_test.pl re-add the topology schema, using the topology.AddToSearchPath function which is part of the topology support.

[robe]

Milestone renamed