Re: Dump all databases to corresponding files - Mailing list pgsql-general

From Tom Lane
Subject Re: Dump all databases to corresponding files
Date
Msg-id 27972.1162783577@sss.pgh.pa.us
Whole thread Raw
In response to Dump all databases to corresponding files  (CSN <cool_screen_name90001@yahoo.com>)
List pgsql-general
CSN <cool_screen_name90001@yahoo.com> writes:
> Also, would this approach add up to equal the output of pg_dumpall, or
> does pg_dumpall dump additional things (if so, please describe how
> they'd also be dumped)?

You'd be missing roles (user/group definitions) and tablespace
definitions.  pg_dump doesn't emit either.

            regards, tom lane

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Dump all databases to corresponding files
Next
From: "Premsun Choltanwanich"
Date:
Subject: Header meaning for pg_dump