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

From Jacob Atzen
Subject Re: Backing up multiple databases
Date
Msg-id 20050617124502.GA11159@interflow.dk
Whole thread Raw
In response to Re: Backing up multiple databases  (Richard Huxton <dev@archonet.com>)
Responses Re: Backing up multiple databases  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Backing up multiple databases  (Gavin Love <gavin@aardvarkmedia.co.uk>)
List 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

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Hungry postmaster
Next
From: Együd Csaba
Date:
Subject: Making the DB secure