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

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

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Richard Huxton <dev(at)archonet(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Does anything dump per-database config settings? (was Re: ALTER DATABASE vs pg_dump)
Date: 2008-06-30 02:47:03
Message-ID: 200806292247.03492.xzilla@users.sourceforge.net (view raw or flat)
Thread:
Lists: pgsql-hackers
On Friday 27 June 2008 12:58:41 Richard Huxton wrote:
> 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?
>

Certainly not desired by a number of people I have talked to, but I don't have 
much hope in seeing the behavoir change... perhaps someday if we get around 
to merging pg_dump and pg_dumpall....

-- 
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

In response to

Responses

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2008-06-30 03:30:08
Subject: Re: Does anything dump per-database config settings? (was Re:ALTER DATABASE vs pg_dump)
Previous:From: Tom LaneDate: 2008-06-29 20:57:10
Subject: WIP patch: reducing overhead for repeat de-TOASTing

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