Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
