Re: 9.2 upgrade glitch with search_path

Scott Ribe <scott_ribe@elevated-dev.com> writes:
> Built & installed 9.2.3. Dumped 9.1 db (using 9.2 pg_dump IIRC). Restored.
> Database search path was not restored. Had to execute alter database ... set search_path to...

That's a hole in the particular dump methodology you selected:

> pg_dumpall -g -f roles.dump
> pg_dump -F c -Z 0 -v pedcard > db.dump

pg_dump does not dump/restore database properties, only database
contents.  Properties are the responsibility of pg_dumpall, which
you bypassed (for databases anyway).

There's been some discussion of refactoring these responsibilities,
but no consensus.

            regards, tom lane