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