Re: Dump all databases to corresponding files

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: CSN <cool_screen_name90001(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Dump all databases to corresponding files
Date: 2006-11-06 03:26:17
Message-ID: 27972.1162783577@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

CSN <cool_screen_name90001(at)yahoo(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Premsun Choltanwanich 2006-11-06 04:08:46 Header meaning for pg_dump
Previous Message Merlin Moncure 2006-11-06 03:12:35 Re: Dump all databases to corresponding files