From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
Cc: | pgsql-docs <pgsql-docs(at)postgresql(dot)org> |
Subject: | Re: per feedback I received directly, pg_dump manpage patch |
Date: | 2015-05-28 01:53:12 |
Message-ID: | 20150528015312.GH5885@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
Joshua D. Drake wrote:
>
> On 05/27/2015 06:31 PM, Alvaro Herrera wrote:
> >
> >Joshua D. Drake wrote:
> >>The man page does not clearly state that pg_dump will not dump things like
> >>users or roles. It does mention briefly in the notes section that pg_dumpall
> >>is needed for items that are set via SET but that isn't very clear on the
> >>other items.
> >
> >I agree that we need a warning about this, but I think it should be a
> >bit more generic rather than focused exclusively on pg_dumpall; perhaps
> >something like "global objs such as roles/tblspcs should be backed up
> >separately, for example using pg_dumpall".
>
> As the only way to back up global objects is pg_dumpall....?
Well, my point is that the roles could be set up separately by other
means.
> >I didn't check the location of the warning in your patch, or whether a
> >warning is really appropriate rather than, say, <note> or a plain
> ><para>.
>
> The warning is directly after the first paragraph. I thought about using
> <note> but I think this does warrant a <warning>. You can't actually restore
> a database correctly without pg_dump + pg_dumpall (in this context).
Okay, +0 there. (That is, I don't disagree with you but I won't stand
in the way of others disagreeing on that point.)
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2015-05-28 01:57:45 | Re: per feedback I received directly, pg_dump manpage patch |
Previous Message | Joshua D. Drake | 2015-05-28 01:37:13 | Re: per feedback I received directly, pg_dump manpage patch |