Re: Backing up multiple databases - Mailing list pgsql-general

From Tom Lane
Subject Re: Backing up multiple databases
Date
Msg-id 20136.1119016653@sss.pgh.pa.us
Whole thread Raw
In response to Re: Backing up multiple databases  (Jacob Atzen <jaa@interflow.dk>)
List 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

pgsql-general by date:

Previous
From: Együd Csaba
Date:
Subject: Re: Making the DB secure
Next
From: Kathir Velu
Date:
Subject: PostgreSQL 8.0.3 : initdb fails with the time zone value WAT0 on HP-Unix platforms