Re: Backing up multiple databases

From: Jacob Atzen <jaa(at)interflow(dot)dk>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Backing up multiple databases
Date: 2005-06-17 12:45:02
Message-ID: 20050617124502.GA11159@interflow.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jun 17, 2005 at 01:21:13PM +0100, Richard Huxton wrote:
> What's the problem with creating a superuser called "postgres" on both
> machines? Or you could choose not to dump (or restore) ownership
> information (--no-owner). The section of the manuals you want is
> "PostgreSQL Client Applications" - it covers all the options.

> 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.

--
Cheers,
Jacob Atzen

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Együd Csaba 2005-06-17 12:49:07 Making the DB secure
Previous Message Christopher Browne 2005-06-17 12:43:21 Re: Backing up multiple databases