Re: Backing up multiple databases

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jacob Atzen <jaa@interflow.dk>
Cc: Richard Huxton <dev@archonet.com>, pgsql-general@postgresql.org
Date: 2005-06-17T13:57:33Z
Lists: pgsql-general
Jacob Atzen <jaa@interflow.dk> writes:
> On Fri, Jun 17, 2005 at 01:21:13PM +0100, Richard Huxton wrote:
>> I'd use pg_dump anyway - unless you have hundreds of databases, it makes 
>> it easier to keep by backups separate.

> I will do that then. Thanks.

Note that you probably also want to run "pg_dumpall -g" as part of that
set of backups, else you have no restorable record of your users and
groups.

			regards, tom lane