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.
--
Command Prompt, Inc. - http://www.commandprompt.com/
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 warni
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
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 se
On 05/27/2015 06:53 PM, Alvaro Herrera wrote:
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.
True but this is about pg_dump right? I mean contextually it doesn't
matter if they can issue a separate SQ
