Re: Does anything dump per-database config settings? (was Re: ALTER DATABASE vs pg_dump) - Mailing list pgsql-hackers

Richard Huxton wrote:
> Richard Huxton wrote:
>> At present it means you can't reliably do:
>>  DROP DATABASE foo;
>>  pg_restore --create foo.dump
>> I'd then have to either hand edit the dumpall dump or wade through a 
>> bunch of errors checking that none of them were relevant.
> 
> Actually, I'm not sure pg_dumpall does them either.
[snip]
> Am I doing something stupid here?

OK - so to get the ALTER DATABASE commands I need to dump the schema for 
the entire cluster. Is that really desired behaviour?

--   Richard Huxton  Archonet Ltd