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 responsibility of pg_dumpall, which
> you bypassed (for databases anyway).
> 
> There's been some discussion of refactoring these responsibilities,
> but no consensus.

Ah, this is my first upgrade using that methodology, in order to get concurrent 
restore functionality. Prior to this I've always used pg_dumpall.

-- 
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice






-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to