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