Skip site navigation (1) Skip section navigation (2)

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

From: Richard Huxton <dev(at)archonet(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Does anything dump per-database config settings? (was Re: ALTER DATABASE vs pg_dump)
Date: 2008-06-27 16:58:41
Message-ID: 48651C41.4000701@archonet.com (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2008-06-27 17:14:15
Subject: Re: Vacuuming leaked temp tables (once again)
Previous:From: Alvaro HerreraDate: 2008-06-27 16:52:10
Subject: Re: Vacuuming leaked temp tables (once again)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group