From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | "Karl O(dot) Pinc" <kop(at)meme(dot)com>, nikolay(at)samokhvalov(dot)com, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: pg_dump design problem (bug??) |
Date: | 2006-06-27 17:10:36 |
Message-ID: | 200606271310.37130.xzilla@users.sourceforge.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tuesday 27 June 2006 11:10, Karl O. Pinc wrote:
> On 06/27/2006 09:29:36 AM, Nikolay Samokhvalov wrote:
> > So, what about it?
> >
> > I periodically encounter with the same problem. People (e.g. me :-)
> > but not only) expect that when they use pg_dump to backup some
> > database (either schema only or both schema and data), all database
> > properties will be dumped and, then, restored.
> >
> > People think that this thing seems to be gotcha. Anyway, if we can
> > assign variable's value to database, it makes this value to be the
> > property of database and, therefore, should be dumped...
>
> There are obvious acceptable work-arounds, but none (AFIK) that don't
> involve having to manually look through a bunch of pg_dumpall output
> if you want to restore just one database. There are only 2 real
> choices, either pg_dumpall takes an option to specify just one
> db be dumped, or pg_dump takes a flag that allows "alter database"
> into the output and pg_restore takes a flag that ignores
> such "alter database" information. I'd prefer
> pg_dump/pg_restore, it has the advantage
> of producing a single file per db. (Humm, it'd probably
> be best if the pg_restore flag only worked on
> -F c style data.)
>
I think I would prefer the former... pg_dumpall --database foo that dumped
all globals along with a specific database.
> The real question is whether the pg developers would
> object to such a feature, whatever the design is,
> or whether it's just that nobody's
> gotten around to writing it.
>
Probably more of no one getting around to it, but you need to come up with a
solution that doesnt break backwards compatability; ie you need to be able to
still make "dbname" agnostic dumps with pg_dump.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2006-06-27 17:57:21 | Re: unique attributes in profile management system |
Previous Message | Matthew T. O'Connor | 2006-06-27 17:05:33 | Re: auto-vacuum & Negative "anl" Values |