buschmann(at)nidsa(dot)net writes:
> On the origin database I had entered
> ALTER DATABASE xxxdb SET search_path TO public,partition2;
> The restore omits setting the search path, it must be entered again with
> ALTER DATABASE on the target machine.
This is operating as designed: pg_dump dumps the content of a database,
not settings attached to the database object as such. You can use
pg_dumpall (possibly with the -g switch) to capture that info.
There've been repeated discussions about refactoring this division of
labor, but nothing's been agreed to yet.
regards, tom lane