Re: Backing up multiple databases

Jacob Atzen <jaa@interflow.dk>

From: Jacob Atzen <jaa@interflow.dk>
To: Richard Huxton <dev@archonet.com>
Cc: pgsql-general@postgresql.org
Date: 2005-06-17T12:45:02Z
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