Bruce Momjian writes:
> On Sun, Jan 13, 2013 at 04:51:55PM -0500, Tom Lane wrote:
>> pg_dump does not dump/restore database properties, only database
>> contents. Properties are the responsibility of pg_dumpall, which
>> you bypassed (for databases anyway).
> Isn't this a bug? Seems there is no
On Sun, Jan 13, 2013 at 04:51:55PM -0500, Tom Lane wrote:
> Scott Ribe 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
On Jan 13, 2013, at 2:51 PM, Tom Lane wrote:
> 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 responsibi
Scott Ribe 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_du
