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