Re: Backing up multiple databases

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jacob Atzen <jaa(at)interflow(dot)dk>
Cc: Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Backing up multiple databases
Date: 2005-06-17 13:57:33
Message-ID: 20136.1119016653@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jacob Atzen <jaa(at)interflow(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kathir Velu 2005-06-17 14:04:41 PostgreSQL 8.0.3 : initdb fails with the time zone value WAT0 on HP-Unix platforms
Previous Message Tom Lane 2005-06-17 13:54:52 Re: Autovacuum in the backend