Re: 9.2 upgrade glitch with search_path

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
Cc: Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: 9.2 upgrade glitch with search_path
Date: 2013-01-13 21:51:55
Message-ID: 12568.1358113915@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-general

Scott Ribe <scott_ribe(at)elevated-dev(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2013-01-13 22:18:26 Re: 9.2 upgrade glitch with search_path
Previous Message SUNDAY A. OLUTAYO 2013-01-13 21:12:21 Re: Linux Distribution Preferences?